sql语句增删改查总结

一、查询

SELECT column_name,column_name  FROM table_name;

SELECT * FROM Websites;

二、增加

INSERT INTO table_name   VALUES (value1,value2,value3,...);

INSERT INTO table_name (column1,column2,column3,...)  VALUES (value1,value2,value3,...);

INSERT INTO Websites (name, url, alexa, country) VALUES

(' 百度','https://www.baidu.com/','4','CN');

三、删除

DELETE FROM table_name  WHERE some_column=some_value;

DELETE FROM Websites WHERE name='Facebook' AND country='USA';

四、更新

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

WHERE some_column=some_value;

UPDATE Websites SET alexa='5000', country='USA' WHERE name='苏慎臻';