SQL SELECT syntax
SELECT column_name,column_name FROM table_name;
and
SELECT * FROM table_name;
SQL INSERT INTO syntax
INSERT INTO statements can be written in two forms.
The first form does not need to specify the column name to insert data, just provide the inserted value:
INSERT INTO table_name VALUES (value1,value2,value3,...);
The second form requires specifying the column name and the inserted value:
INSERT INTO table_name (column1,column2,column3,...) VALUES (value1,value2,value3,...);
SQL UPDATE syntax
UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;
SQL DELETE syntax
DELETE FROM table_name WHERE some_column=some_value;
Recommended tutorial: sql tutorial
The above is the detailed content of SQL database add, delete, modify, query syntax. For more information, please follow other related articles on the PHP Chinese website!