我正在尝试将 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;
这篇关于MySQL 错误 1241:操作数应包含 1 列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!