插入数据：

INSERT INTO table_name (column1, column2,…)VALUES (value1, value2,….)

查询数据

SELECT column_name(s) FROM table_name

修改数据

UPDATE table_name SET column_name = new_value  WHERE column_name = some_value

删除数据

DELETE FROM table_name   WHERE column_name = some_value

 
WHERE 子句  选取匹配指定条件的数据

 ORDER BY 关键词用于对记录集中的数据进行排序