SQL database add, delete, modify, query syntax

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!