SQL数据库增删改查语法

SELECT column_name,column_name

FROM table_name;

SELECT * FROM table_name;

INSERT INTO table_name

VALUES (value1,value2,value3,...);

INSERT INTO table_name (column1,column2,column3,...)

VALUES (value1,value2,value3,...);

UPDATE table_name

SET column1=value1,column2=value2,...

WHERE some_column=some_value;

DELETE FROM table_name

WHERE some_column=some_value;