Operand should contain 1 column(s)??? IT DOES but still error. Is this a bug?

Question

I'm having a verry strange problem. I am certain I have done nothing wrong in this line of code:

INSERT INTO 
 oc_address     
  (`cust_id`, `firstname`, `lastname`, `address_1`, `city`, `postcode`, `country_id`)
SELECT          
  (`cust_id`, `first_name`, `last_name`, `address`, `city`, `postalcode`, `country`)
FROM    old_customer;

Still I get the message "#1241 - Operand should contain 1 column(s)"

Does anybony see something I don't see? I was thinking it may be caused by the _1 at address_1. But why would that be... I hope there is another explanation

@HLGEM YES it did work! What a stupid stupid mistake of me. Thanks you verry much — , Apr 23 '13 at 15:42
See https://stackoverflow.com/questions/456644/mysql-syntax-error-message-operand-should-contain-1-columns — Bill Karwin, Oct 11 '14 at 18:04

score 3 · Answer 1 · answered Apr 23 '13 at 15:18

3

Remove the ' symbols for your column names and the () in your SELECT.

  INSERT INTO 
  oc_address     
  (cust_id, firstname, lastname, address_1, city, postcode,country_id)
  SELECT          
  cust_id, first_name, last_name, address, city, postalcode, country
  FROM    old_customer;

answered Apr 23 '13 at 15:18

phadaphunk

12,785
15
73
107

3

-1 no comments ? what is wrong with my answer? – phadaphunk Apr 23 '13 at 15:21
nevermind them, i have also `2` downvotes on my answer. hehe your answer is also correct. – John Woo Apr 23 '13 at 15:32

John Woo · Accepted Answer · 2013-04-23T15:25:50.077

3

remove ( ) around the columns on SELECT ststement,

INSERT  INTO oc_address (cust_id, firstname, lastname, address_1, city, postcode, country_id)
SELECT cust_id, first_name, last_name, address, city, postalcode, country
FROM    old_customer;

SQLFiddle Demo (two statements included)

edited Apr 23 '13 at 15:25

answered Apr 23 '13 at 15:19

John Woo

258,903
69
498
492

2

I would have guessed that too. @RamiNagiebMourshedy could you try remove `(` and `)`. – Joop Eggen Apr 23 '13 at 15:26

Operand should contain 1 column(s)??? IT DOES but still error. Is this a bug?

2 Answers2