MySQL error 1241: Operand should contain 1 column(s)

by

Syntax error, remove the ( ) from select.

insert into table2 (name, subject, student_id, result)
select name, subject, student_id, result
from table1;

More Related Contents:

  1. MySQL INSERT INTO … VALUES and SELECT
  2. Recreating a query using INNER JOIN? [duplicate]
  3. What is better subquery vs literal on IN clause in mysql
  4. quick selection of a random row from a large table in mysql
  5. How to do a batch insert in MySQL
  6. Operand Should Contain 1 Column – MySQL NOT IN
  7. Ordering by specific field value first
  8. MySQL – Operand should contain 1 column(s)
  9. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  10. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  11. How to copy a row and insert in same table with a autoincrement field in MySQL?
  12. Checking multiple columns for one value
  13. MySQL Error 1264: out of range value for column
  14. How do I get the ID of multiple inserted rows in MySQL?
  15. How to insert data to MySQL with auto-incremented column(field)?
  16. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  17. quick selection of a random row from a large table in mysql
  18. Compare only day and month with date field in mysql
  19. Syntax error when using except in a query
  20. SELECT query return 1 row from each group
  21. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  22. MySQL INNER JOIN select only one row from second table
  23. MySQL Select Query – Get only first 10 characters of a value
  24. SQL query to check if a name begins and ends with a vowel
  25. MySQL – insert data from another table merged with constants
  26. How to SELECT by MAX(date)?
  27. MySQL optimizing INSERT speed being slowed down because of indices
  28. MySQL: Insert datetime into other datetime field
  29. “Unknown column in ‘field list'”, but column does exist
  30. Insert and set value with max()+1 problems

Leave a Comment