前言
MySQL数据字段基本操作
一、字段操作
-- 备选字段添加脚本
ALTER TABLE product ADD COLUMN UserDefine1 VARCHAR (255);
ALTER TABLE product ADD COLUMN UserDefine2 VARCHAR (255);
ALTER TABLE product ADD COLUMN UserDefine3 VARCHAR (255);
ALTER TABLE product ADD COLUMN UserDefine4 VARCHAR (255);
ALTER TABLE product ADD COLUMN UserDefine5 VARCHAR (255);
ALTER TABLE product ADD COLUMN UserDefine6 VARCHAR (255);
ALTER TABLE product ADD COLUMN UserDefine7 DECIMAL (18, 4) DEFAULT 0 COMMENT '备选7';
ALTER TABLE product ADD COLUMN UserDefine8 DECIMAL (18, 4) DEFAULT 0 COMMENT '备选8';
-- 修改
ALTER TABLE product MODIFY COLUMN UserDefine8 DECIMAL (18, 4) DEFAULT 0 COMMENT '备选8';
-- 删除
ALTER TABLE product DROP COLUMN UserDefine8
二、表操作
ALTER TABLE help_text CHARACTER SET = utf8mb4, COLLATE = utf8mb4_general_ci;
总结
持续更新