Neatware Header
Home   Products   Forums   Partners   Buy   Company   Contact   Blog   
SQL

SQL is a standard database language.

  • Error Processing
  • Connect to Database
  • Create Database
  • Create Table

    CREATE TABLE tabname (id INT PRIMARY KEY, info TEXT, ...)

  • Insert Data

    INSERT INTO table (colname1, colname2, ...) values ('value1', 'value2', ...)

  • Delete Data

    DELETE FROM table WHERE column = value [LIMIT 1]

  • Retrieve Data

    SELECT columns FROM tables WHERE conditions

  • Update Data

    UPDATE table SET colname1 = value1, colname2 = value2, ... WHERE column = value

SQL Review