在什么字段后边添加一个列语句
重点是after name
Alter table risk_jrs
.jrs_sys_user
add column user_name
varchar(100) NOT NULL COMMENT ‘用户名字’ after name
表中重复的数据
SELECT * FROM user
GROUP BY phone
,card_id
HAVING COUNT(*) > 1
可以看见重复的数据
删除2个表不同的数据
DELETE FROM book_tree
WHERE book_id NOT IN (SELECT id
FROM book_info
)