alter table afl_taobao_shop add column updateTime datetime;
update
afl_taobao_shop s join afltaobaosubuser u on s.ower_id=u.subId
set
s.nick = u.name
where
u.subId>0
mysql 增加列语句
alter table afl_taobao_shop add column updateTime datetime;
update
afl_taobao_shop s join afltaobaosubuser u on s.ower_id=u.subId
set
s.nick = u.name
where
u.subId>0
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
