- 数据库
- 查:
show databases;
show create database db_name; - 增:
create database [if not exists] db_name [character set, collate]; - 改:
alter database db_name [character set, collate] - 删:
drop database db_name;
- 查:
- 表:
- 查:
show tables;
show create table tb_name;
describe/desc tb_name; - 增:
create table tb_name(
col_name type,
col_name type,
col_name type
)[engine, character set, collate]; - 改
- a. 添加列:
alter table tb_name add column new_col_name type;
alter table tb_name add column new_col_name type after col_name;
alter table tb_name add column new_col_name type first; - b. 修改列
alter table tb_name change column col_name new_col_name type;
alter table tb_name modify column col_name type; - c. 删除列
alter table tb_name drop column col_name; - d. 重命名/迁移
rename table tb_name to new_tb_name; - e. 修改存储引擎,字符集,校对集
alter table tb_name [engine, character set, collate];
删:
drop table tb_name;
- a. 添加列:
- 查:
数据库day01 DML
最新推荐文章于 2024-07-17 15:00:15 发布