【总结】MySQL 语句 分类： mysql 数据库 2014-08-03 21:16 201人阅读 评论(1) 收藏

1、创建数据库

CREATE DATABASE database_name

2、创建表

CREATE TABLE Persons 
(
personID int NOT NULL AUTO_INCREMENT, //自增长字段
PRIMARY KEY(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)

3、增/插入

INSERT INTO table_name
VALUES (value1, value2,....)

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

4、删/删除

DELETE FROM table_name
WHERE column_name1 = some_value1 AND column_name2 = some_value2

5、改/修改

UPDATE table_name
SET column_name1 = new_value1, column_name2 = new_value2
WHERE column_name1 = some_value1 AND column_name2 = some_value2

6、查/查询

SELECT column_name(s) FROM table_name

7、WHERE

SELECT column FROM table
WHERE column operator value

8、ORDER BY

SELECT column_name(s)
FROM table_name
ORDER BY column_name

SELECT column_name(s)
FROM table_name
ORDER BY column_name DESC(ASC)

SELECT column_name(s)
FROM table_name
ORDER BY column_name1, column_name2

9、修改自增长首位大小

alter table table_name AUTO_INCREMENT 1

版权声明：本文为博主原创文章，未经博主允许不得转载。