MySQL 经典语句总结.docVIP

MySQL 经典语句总结 （侯惠阳 PHPer.yang） SELECT SELECT 列名称 FROM 表名称 SELECT LastName,FirstName FROM Persons SELECT * FROM Persons SELECT DISTINCT 列名称 FROM 表名称 SELECT DISTINCT Company FROM Orders //去除重复的distinct WHERE SELECT 列名称 FROM 表名称 WHERE 列 运算符 值 SELECT * FROM Persons WHERE City=Beijing SELECT * FROM Persons WHERE Year1965 INSERT INTO INSERT INTO 表名称 VALUES (值1, 值2,....) INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....) INSERT INTO Persons VALUES (Gates, Bill, Xuanwumen 10, Beijing) INSERT INTO Persons (LastName, Address) VALUES (Wilson, Champs-Elysees) Insert into table () select * from name;