Question

mysql如何将一张表里的数据添加到另一张新表里

alone_auth_user是一张新表，要把lms_employee的username复制到alone_auth_user的name字段中，sql语句怎么写？

Answer 1

insert into alone_auth_user(name) values select username from lms_employee

Answer 2

insert into alone_auth_user (username) select name from lms_employee

追问

[SQL]
insert into alone_auth_user (username) select name from lms_employee
[Err] 1054 - Unknown column 'name' in 'field list'