weixin_44892460的博客

UPDATE t_s_user a ,(SELECT ur.id,bu.username,bu.realname,ur.roleids, (SELECT r.rolename FROM t_s_role r WHERE r.id IN(IFNULL(ur.roleids,''))) rolenames from t_s_base_user bu LEFT JOIN ( SELECT u.id,ru.roleids FROM t_s_user u LEFT j...

添加列： ALTER TABLE tablename ADD column datatype [primary key/default/not null/…] COMMENT ‘注释’ AFTER ‘columnX’ //在colunmX列后增加字段 其中 [] 里面的内容没有顺序 例：ALTER TABLE test ADD phone int not null DEFAULT 1 COM...