mysql、postgreSQL在已存在的表中新增字段并创建字段注释

1. 创建字段并赋值注释

alter table exchange_statistics add sys_id int4(32);
alter table exchange_statistics add dept_code varchar(255);
alter table exchange_statistics add create_time timestamp(0);

COMMENT ON COLUMN exchange_statistics.dept_code IS '部门code';
COMMENT ON COLUMN exchange_statistics.sys_id IS '系统id';
COMMENT ON COLUMN exchange_statistics.create_time IS '创建时间';

2. 修改字段类型

alter table exchange_statistics alter sys_id type varchar(255)

参考：参考连接

3. mysql数据库的初始化（truncate 表名）

truncate fault_abort;
truncate latitude_longitude;
truncate organization_manage;