基础sql操作，个人记录

基础sql操作

去重

SELECT DISTINCT column_name,column_name
FROM table_name;

插入

INSERT INTO table_name (column1,column2,column3,...)
VALUES (value1,value2,value3,...);

更新

UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;

删除

DELETE FROM table_name
WHERE some_column=some_value;

查找多个值

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);

添加字段

ALTER TABLE table_name
ADD column_name datatype

把字段值变成大写

SELECT UCASE(column_name) FROM table_name;

返回字段值的文本长度

SELECT LEN(column_name) FROM table_name;

格式化日期显示

SELECT name, url, DATE_FORMAT(Now(),'%Y-%m-%d') AS date
FROM Websites;

杀sql进程

kill pid

查看进行中的查询

show processlist