【总结】MySQL 语句

最新推荐文章于 2024-01-02 08:30:00 发布

snow_finland

最新推荐文章于 2024-01-02 08:30:00 发布

阅读量767

点赞数

分类专栏： mysql 数据库文章标签：数据库 mysql database

本文链接：https://blog.csdn.net/snow_finland/article/details/38361159

版权

5 篇文章 0 订阅

订阅专栏

3 篇文章 0 订阅

订阅专栏

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

关注

专栏目录