SQL快速参考list
来源:互联网 发布:集搜客网页抓取软件 编辑:程序博客网 时间:2024/05/22 06:59
看过之后的东西如果长时间不用就会忘记,有一个list还是很重要的,可以在用到的时候很快找到需要查找的内容。
SQL 语句
FROM table_name
WHERE condition
AND|OR conditionALTER TABLE (add column)ALTER TABLE table_name
ADD column_name datatypeALTER TABLE (drop column)ALTER TABLE table_name
DROP COLUMN column_nameAS (alias for column)SELECT column_name AS column_alias
FROM table_nameAS (alias for table)SELECT column_name
FROM table_name AS table_aliasBETWEENSELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2CREATE DATABASECREATE DATABASE database_nameCREATE INDEXCREATE INDEX index_name
ON table_name (column_name)CREATE TABLECREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
.......
)CREATE UNIQUE INDEXCREATE UNIQUE INDEX index_name
ON table_name (column_name)CREATE VIEWCREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE conditionDELETE FROMDELETE FROM table_name
(Note: Deletes the entire table!!)
or
DELETE FROM table_name
WHERE condition
FROM table_name
GROUP BY column_name1HAVINGSELECT column_name1,SUM(column_name2)
FROM table_name
GROUP BY column_name1
HAVING SUM(column_name2) condition valueINSELECT column_name(s)
FROM table_name
WHERE column_name
IN (value1,value2,..)INSERT INTOINSERT INTO table_name
VALUES (value1, value2,....)
or
INSERT INTO table_name
(column_name1, column_name2,...)
VALUES (value1, value2,....)
FROM table_name
WHERE column_name
LIKE patternORDER BYSELECT column_name(s)
FROM table_name
ORDER BY column_name [ASC|DESC]SELECTSELECT column_name(s)
FROM table_nameSELECT *SELECT *
FROM table_nameSELECT DISTINCTSELECT DISTINCT column_name(s)
FROM table_nameSELECT INTO
(used to create backup copies of tables)SELECT *
INTO new_table_name
FROM original_table_name
or
SELECT column_name(s)
INTO new_table_name
FROM original_table_name
(deletes only the data inside the table)TRUNCATE TABLE table_nameUPDATEUPDATE table_name
SET column_name=new_value
[, column_name=new_value]
WHERE column_name=some_valueWHERESELECT column_name(s)
FROM table_name
WHERE condition
转载自:http://www.w3school.com.cn/sql/sql_quickref.asp
0 0
- SQL快速参考list
- PL/SQL快速参考
- SQL 语句快速参考
- sql语句快速参考
- SQL 快速参考
- SQL 快速参考
- 【快速参考】SQL
- SQL 快速参考
- SQL快速参考
- SQL 语句快速参考
- SQL 快速参考
- SQL语句快速参考
- SQL总结(快速参考)
- SQL 快速参考
- SQL快速参考
- SQL 快速参考
- SQL 快速参考
- SQL快速参考
- java对rendis 的简单操作
- JSP的scope作用域
- 朴素贝叶斯--matlab自带工具箱的使用
- 【ACM】:菜鸟,大牛跟教主的区别
- jvm原理
- SQL快速参考list
- linux下安装nginx
- Java的ArrayList与Vector比较
- Spring Boot示例 - 1. 使用Spring Boot Actuator构建RESTful web service
- CentOS7 常用命令总结
- Sieve of Eratosthenes(埃拉托斯特尼素数筛选法)--java实现
- CentOS7 PHP 连接 MSSQL 2008
- 他成就比李安还高,却半辈子活在歧视中
- iOS给照片添加水印效果