阅读:http://www.runoob.com/sql/sql-tutorial.html
一些最重要的 SQL 命令
SELECT - 从数据库中提取数据
UPDATE - 更新数据库中的数据
DELETE - 从数据库中删除数据
INSERT INTO - 向数据库中插入新数据
CREATE DATABASE - 创建新数据库
ALTER DATABASE - 修改数据库
CREATE TABLE - 创建新表
ALTER TABLE - 变更(改变)数据库表
DROP TABLE - 删除表
CREATE INDEX - 创建索引(搜索键)
DROP INDEX - 删除索引
查询特定列数据
SELECT column_name,column_name
FROM table_name;
查询所有列数据
SELECT * FROM table_name;
用于返回唯一不同的值:(去重)
SELECT DISTINCT column_name,column_name
FROM table_name;
过滤查询:AND & OR 运算符用于基于一个以上的条件对记录进行过滤。
SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;
排序:order by 降序DESC 升序ASC(默认)
SELECT * FROM table_name;
用于返回唯一不同的值:(去重)
SELECT DISTINCT column_name,column_name
FROM table_name;
过滤查询:AND & OR 运算符用于基于一个以上的条件对记录进行过滤。
SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;
排序:order by 降序DESC 升序ASC(默认)
SELECT
column_name
,
column_name
FROM
table_name
ORDER BY
column_name
,
column_name
ASC|DESC; 模糊搜索:like
SELECT
column_name(s)
FROM table_name
WHERE column_name LIKE pattern ;
FROM table_name
WHERE column_name LIKE pattern ;
{
% 替代一个或多个字符
_ 仅替代一个字符
[charlist] 字符列中的任何单一字符
[^charlist]或者[!charlist] 不在字符列中的任何单一字符
}多值查询SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);范围值查询SELECT column_name(s)
FROM table_name
WHERE column_name
FROM table_name
WHERE column_name IN (value1,value2,...);范围值查询SELECT column_name(s)
FROM table_name
WHERE column_name
[NOT] BETWEEN value1 AND value2;查询限制数目(不同数据库系统可能不同)SELECT column_name(s)
FROM table_name
LIMIT number;别名SELECT column_name AS alias_name
FROM table_name;或SELECT column_name(s)
FROM table_name AS alias_name;
FROM table_name
LIMIT number;别名SELECT column_name AS alias_name
FROM table_name;或SELECT column_name(s)
FROM table_name AS alias_name;
插入数据
INSERT INTO table_name
VALUES (value1,value2,value3,...);
或
INSERT INTO table_name (column1,column2,column3,...)
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;