INSERT INTO user_center
.two_element_todo
(name
,phone
)
SELECT true_name
AS name
,mobile
AS phone
FROM test
.two_element_todo
mysql 先查询后新增
最新推荐文章于 2022-05-10 20:44:18 发布
INSERT INTO user_center
.two_element_todo
(name
,phone
)
SELECT true_name
AS name
,mobile
AS phone
FROM test
.two_element_todo