insert multiple rows returned from a subquery

[jez]

Hi Everyone,

I am trying to do this;-

INSERT INTO RackData (rackNumber) VALUES (SELECT DISTINCT Rack FROM Server);

I am trying to copy all the unique rack numbers from my server table to the new rack table. I could not find info on this on mysql.com and I am currently getting an error about the right syntax to use near 'SELECT.. '.

Is it possible to insert rows like this? I know all the other fields of the new RackData table will be default, but that is not a problem.

Many thanks in advance.

Jez

 

[r937]

you can have VALUES, or you can have SELECT, but not both

the correct syntax (yes, it's in da manual) is

INSERT INTO RackData (rackNumber)
SELECT DISTINCT Rack FROM Server



r937.com | rudy.ca

 

[jez]

Thanks very much for this, I am sure it is in the manual, i just couldn't find it ;-)...

Thanks again!

Jez

 

[r937]

INSERT ... SELECT

http://dev.mysql.com/doc/refman/5.0/en/insert-select.html

;-)

r937.com | rudy.ca