add column [复制链接]

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`

ALTER TABLE `f_threads`
ADD COLUMN `cid`  tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '商品对应的分类' AFTER `fid`

update f_posts_re_18 set to_id=0 where to_id is NULL;
ALTER TABLE `f_posts_re_18`
MODIFY COLUMN `to_id`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '回复对象ID' AFTER `uid`,
MODIFY COLUMN `nickname`  varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL AFTER `to_id`,
ADD COLUMN `to_name`  varchar(50) NULL DEFAULT NULL COMMENT '回复对象用户昵称' AFTER `to_id`

ALTER TABLE `f_threads`
ADD INDEX `reply_num` (`reply_num`) USING BTREE,
ADD INDEX `fid` (`fid`) USING BTREE,
ADD INDEX `audit` (`audit`) USING BTREE,
ADD INDEX `post_id` (`post_id`) USING BTREE,
ADD INDEX `cid` (`cid`) USING BTREE,
ADD INDEX `uid` (`uid`) USING BTREE,
ADD INDEX `status` (`status`) USING BTREE

{{--{{  htmlentities($data['message'])  }}--}}{!! nl2br(\App\Handlers\myfun::regface($data->postkey->message)) !!}
                                            <?php /*echo nl2br($data['message'])*/?>

UPDATE a t1,b t2
SET t1.字段名=t2.字段名
WHERE t1.字段名=t2.字段名

update mm_fyinfo a   set re2=(select b.pname from oy_district b  where a.disid=b.id )  where  a.re2='undefined' 


 


update zl_fyinfo a   set re2=(select b.pname from oy_district b  where a.disid=b.id )  where  a.re2='undefined'   
---------------------
作者：qq_37677123
来源：CSDN
原文：https://blog.csdn.net/qq_37677123/article/details/79447110
版权声明：本文为博主原创文章，转载请附上博文链接！

UPDATE f_threads_collect set f_threads_collect.fid=(select fid where f_threads where f_threads_collect.threads_id = f_threads.id);

update f_threads set fid=0 where fid is null;
SELECT * FROM `f_threads`;
UPDATE f_threads_collect set f_threads_collect.fid=(select fid from f_threads where f_threads_collect.threads_id = f_threads.id);