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.
|
|