Mysql操作数据库查询数据

1.用sql导出数据库表结构清单
select TABLE_SCHEMA 数据库名,TABLE_NAME 表名,COLUMN_NAME 列名, DATA_TYPE 字段类型, COLUMN_COMMENT 字段注释
from information_schema.COLUMNS
where TABLE_SCHEMA=‘tec’

2.用sql导出数据库表结构注释
SELECT TABLE_SCHEMA 数据库名,TABLE_NAME 表名,TABLE_COMMENT 表注释
FROM information_schema.TABLES
WHERE TABLE_SCHEMA=‘ams’

3.增加数据库表字段
alter table tec.pack_record
add column PACK_WEIGHT varchar(20) NULL COMMENT ‘重量’ after SHIPMENT_PLACE

alter table tec.arch_tmp_tab modify ASSEM_ID varchar(50);