数据库day01 DML

• 数据库
  • 查：
    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;