table增删改查
增:
INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);
*浅色部分可以忽略不计
删:
DELETE FROM table_name
WHERE some_column=some_value;
WHERE some_column=some_value;
改;
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
*没有where 全部改
查:
SELECT (DISTINCT) column_name,column_name
FROM table_name;
FROM table_name;
*DISTINCT 去除重复值
其他基本语句
ORDER BY column_name,column_name ASC|DESC;