MySQL语句分类
MySQL语句分类 |
英文 |
简称 |
关键字 |
数据定义语言 |
Data Ddefinition Language |
DDL |
create drop alter declare |
数据操纵语言 |
Data Manipulation Language |
DML |
insert delete update |
数据查询语言 |
Data Query Language |
DQL |
select |
数据控制语言 |
Data Control Language |
DCL |
grant revoke commit rollback |
数据定义语言 DDL
– 数据库相关
create database hello;
drop database hello;
show databases;
show create database hello;
use hello;
–表相关
create table student(
s_id int,
s_name varchar(20),
s_sex varchar(10),
s_age int
);
drop table student;
show tables
show create table student;
alter table oldTableName rename newTableName;
desc student;
alter table student add s_motherName varchar(20);
alter table student add s_motherName varchar(20),add s_fatherName varchar(20);
alter table student drop s_motherName;
alter table student