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 
 | 
 
 
 
 
 
Copyright© 2005 Neatware. All Rights Reserved. 
 | 
 |