MySQL 错误 1241:操作数应包含 1 列
我正在尝试将 table1 中的数据插入 table2
I am trying to Insert data from a table1 into table2
insert into table2(Name,Subject,student_id,result)
select (Name,Subject,student_id,result)
from table1;
table2 的键是 student_id.
Key for table2 is student_id.
假设没有任何重复项.
我收到错误:MySQL error 1241: Operand should contain 1 column(s)
table2 中只有四列.
There are only four columns in table2.
推荐答案
语法错误，从select中删除( ).
insert into table2 (name, subject, student_id, result)
select name, subject, student_id, result
from table1;
相关文章