Steps to fix the error “ operand should contain 1 column(s)”

Question

Ada Williams

Asked: May 12, 20222022-05-12T07:49:58+00:00 2022-05-12T07:49:58+00:00In: sql

. Advertisement .

..3..

. Advertisement .

..4..

I’m trying to Insert data from a table 1 into table 2 :

insert into table2(Name,Subject,student_id,result) 

select (Name,Subject,student_id,result) 

from table1;

but in my program, I am getting the warning :

"#1241 - Operand should contain 1 column(s)"

Can someone explain to me why the issue of the “ operand should contain 1 column(s)” happened? Where have I gone wrong? Thank you!

You must login to add an answer.

Need An Account,

lyytutoria · Accepted Answer · 2022-05-30T01:35:39+00:00

Best Answer

lyytutoria Expert

The cause: Syntax error

Solution: Remove the

( )

from

select

.

insert into table2 (name, subject, student_id, result) 

select name, subject, student_id, result 

from table1;