Home    Back    Forward    Refresh    txtSQL Homepage

txtSQL Documentation

Welcome to the new and improved comment system for txtSQL. It has been designed to mimic the php type commenting system, which I believe is a nice, simple, and easy system. Feel free to drop a comment as long as it's not off-topic and does not demean anything or anyone. And don't worry about spammers getting to your email adress; it is automatically obfuscated, and also in your comment.

DO NOT POST BUGS HERE, do that in the bugs section of the forums, and keep everything on-topic, otherwise it will be removed.

Note- this manual has been started as of txtSQL 2.0.0 Beta (not 1.0.0)

User Comments -
Xecure <vexity at gmail dot com>
February 28, 2005, 8:53 pm
Any idea when txtSQL 3.0 is going to come out? I will support this project all the way
FarazAli <saiyanm at hotmail dot com>
February 28, 2005, 7:11 pm
When txtSQL 3.0 is released, then I will be creating a tutorials section where many different 'how-to' examples will be posted.
peon <artistartistartist at hotmail dot com>
February 28, 2005, 7:11 pm
I am new to txtSQL and databases, It would be great if each section had more examples for their various uses.
Faraz Ali <saiyanM at hotmail dot com>
July 30, 2004, 11:19 pm
Yea, it was part of my original plan to have it included in the next release.
samira <samirainstl at hotmail dot com>
July 30, 2004, 11:19 pm
can we have a single file of documentation so we can print and use as a reference in addition to this online help ? I am used to and prefer the printed version.
Thanks
samira.\\n
Faraz Ali <SaiyanM at hotmail dot com>
July 30, 2004, 11:17 pm
Welcome to the new and improved comment system for txtSQL. It has been designed to mimic the php type commenting system, which I believe is a nice, simple, and easy system. Feel free to drop a comment as long as it's not off-topic and does not demean anything or anyone. And don't worry about spammers getting to your email adress; it is automatically obfuscated, and also in your comment.

__DO NOT POST BUGS HERE__, do that in the bugs section of the website, and keep everything on-topic, otherwise it will be removed.
Next Page

'Language Reference'
  • Logical Operators
  • Relational Operators
  • Data Types
  • Column Types
  • Primary Keys
  • Functions
  • Where Clauses
  • LIKE Clauses
  • Limit Clauses
  • OrderBy Clauses
  • Notes
  • txtSQL 3.0.0 Beta Readme

    User Functions
  • connect
  • disconnect
  • grant_permissions
  • getUsers
  • version
  • query_count

    Database Functions
  • showdbs
  • createdb
  • dropdb
  • renamedb
  • isLocked
  • lockdb
  • unlockdb
  • selectdb
  • db_exists

    Data Manipulation Functions
  • select
  • insert
  • update
  • delete
  • execute

    Table Functions
  • showtables
  • createtable
  • droptable
  • altertable
  • describe
  • table_count
  • emptyCache
  • table_exists
  • last_insert_id

    Error Handling Functions
  • strict
  • get_last_error
  • last_error
  • error_dump

    SQL Syntax
  • SELECT Syntax
  • INSERT Syntax
  • DELETE syntax
  • UPDATE Syntax
  • CREATE DATABASE Syntax
  • DROP DATABASE Syntax
  • SHOW DATABASES Syntax
  • USE Syntax
  • LOCK Syntax
  • UNLOCK Syntax
  • IS LOCKED Syntax
  • CREATE TABLE Syntax
  • DROP TABLE Syntax
  • SHOW TABLES Syntax
  • DESCRIBE Syntax
  • SHOW USERS Syntax
  • GRANT PERMISSIONS Syntax
  • Column Properties
  • Column Types
  • LIMIT Syntax
  • ORDERBY Syntax
  • WHERE Syntax

  • [ txtSQL Documentation powered by txtSQL ]