select distinct
在表中,一个列可能会包含多个重复值,有时您也许希望仅仅列出不同(distinct)的值。
DISTINCT 关键词用于返回唯一不同的值。
SELECT DISTINCT column_name,column_name
FROM table_name;
where
order by
对结果进行排序,asc升序,desc降序
SELECT column_name,column_name
FROM table_name
ORDER BY column_name,column_name ASC|DESC;
插入 insert into
INSERT INTO table_name
VALUES (value1,value2,value3,...);
INSERT INTO table2
SELECT * FROM table1;
update更新
UPDATE table_name
SET column1=value1,column2=value2,...
WHERE some_column=some_value;
delete删除
DELETE FROM table_name
WHERE some_column=some_value;
limit
从结果中选前number个
SELECT column_name(s)
FROM table_name
LIMIT number;
like操作符
按照匹配模型进行筛选
SELECT * FROM Websites
WHERE name LIKE 'G%'; | not like
in
IN 操作符允许您在 WHERE 子句中规定多个值。
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);
as 别名
SELECT column_name AS alias_name
FROM table_name;
SELECT w.name, w.url, a.count, a.date
FROM Websites AS w, access_log AS a
WHERE a.site_id=w.id and w.name="菜鸟教程";
join连接
SELECT Websites.id, Websites.name, access_log.count, access_log.date
FROM Websites
INNER JOIN access_log
ON Websites.id=access_log.site_id
where ;
create database