- 创建字段并赋值注释
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 '创建时间';
- 修改字段类型
alter table exchange_statistics alter sys_id type varchar(255)
参考:参考连接
- mysql数据库的初始化(truncate 表名)
truncate fault_abort;
truncate latitude_longitude;
truncate organization_manage;