SQL基本查询语句(查增改删)

查

SELECT /column FROM table
WHERE condition
ORDER BY condition (column desc)

LIMIT number（5）

增

INSERT INTO table(column1,column2…)
VALUES(value1,value2…)

改

UPDATE table
SET column=value1…
WHERE condition

删

DELETE FROM table
WHERE condition

Value要用括号括起来
一个命令结束要打一个分号