环境: MySQL数据库 库名:db_name 表名: table_name1 table_name2 查询一个里面所有表的信息: use information_scheam; select * from tables where table_schema = "db_name"; 查询单个表的信息: use information_sch
环境:
MySQL数据库库名:db_name表名: table_name1 table_name2
查询一个里面所有表的信息:
use information_scheam;select * from tables where table_schema = "db_name";
查询单个表的信息:
use information_scheam;select * from tables where table_schema = "db_name" and table_name = "table_name1";
查询一张表的所有字段信息:
use db_name;show full columns from table_name1;show full columns from table_name2;
一些基础:
# 创建表create table book( id int(11) primary key, title varchar(50) comment '书名', author varchar(32) comment '作者', price int(8) comment '价格');
# 修改表备注信息alter table student comment '书籍表';
# 修改表字段长度alter table book modify column author varchar(50);
# 修改表字段备注信息alter table book modify column author varchar(50) comment '作者姓名';
# 给表增加新字段alter table book add publisher varchar(100) comment '出版社';
# 在指定列后面增加新字段alter table book add publisher varchar(200) comment '出版社' after author;
# 删除表字段alter table book drop column price;
# 查看表备注信息和表字段备注信息请看上文。