sql命令

命令	语法	作用
SELECT	SELECT column FROM table_name (WHERE )	查找
INSERT INTO	INSERT INTO table_name VALUES (value1, value2, value3,....) or INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,....)	插入
UPDATE	UPDATE table_name SET column1=value, column2=value,... WHERE some_column=some_value	更新
DELETE	DELETE FROM table_name WHERE some_column=some_value	删除
SELECT DISTINCT	SELECT DISTINCT column1, column2, ... FROM table_name;	查找唯一不同的值
SELECT LIMIT	SELECT column_name(s) FROM table_name LIMIT number;	规定要返回的记录的数目