首页| 论坛| 消息
主题:add column
北斗星发表于 2019-01-29 13:18
ALTER TABLE `f_threads`
ADD COLUMN `thick`int(11) NULL DEFAULT NULL COMMENT '厚度' AFTER `status`,
ADD COLUMN `height`int(11) NULL DEFAULT NULL COMMENT '高' AFTER `thick`,
ADD COLUMN `width`int(11) NULL DEFAULT NULL COMMENT '宽' AFTER `height`,
ADD COLUMN `outer_d`int(11) NULL DEFAULT NULL COMMENT '外径' AFTER `width`,
ADD COLUMN `inner_d`int(11) NULL DEFAULT NULL COMMENT '内径' AFTER `outer_d`,
ADD COLUMN `arm_width`int(11) NULL DEFAULT NULL COMMENT '臂宽' AFTER `inner_d`,
ADD COLUMN `arm_thick`int(11) NULL DEFAULT NULL COMMENT '臂厚' AFTER `arm_width`,
ADD COLUMN `size`int(11) NULL DEFAULT NULL COMMENT '圈口' AFTER `arm_thick`,
ADD COLUMN `inlay`tinyint(3) NULL DEFAULT 0 COMMENT '镶嵌' AFTER `size`,
ADD COLUMN `carving`tinyint(3) NULL DEFAULT 0 COMMENT '雕刻' AFTER `inlay`,
ADD COLUMN `price`decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '价格' AFTER `carving`,
ADD COLUMN `taobao`varchar(255) NULL DEFAULT NULL COMMENT '淘宝链接' AFTER `price`
回帖(8):
8楼:update f_threads set fid=0 where fid is null;
SELECT * FROM `f_threads`;
UPDATE f_ ..
7楼:UPDATE f_threads_collect set f_threads_collect.fid=(select fid where f_threads where f_thr ..
6楼:update mm_fyinfo a   set re2=(select b.pname from oy_district b  where a.disid=b ..

全部回帖(8)»
最新回帖
收藏本帖
发新帖