Insert Multiple Data From One Table To Another

[kingnutter]

Hi there,

 

I'm trying to insert multiple values from one table to another along with a few set values.

 

Hopefully you can see what I'm trying to do from the code below.

 

Could anyone tell me the correct syntax? I am doing this through PHPmyadmin.

 

Many thanks in advance.

 

INSERT INTO node (nid, vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) (SELECT moj_id FROM mojocd, SELECT moj_id FROM mojocd, 'mojocd', 'en', SELECT moj_title FROM mojoocd, 0, 1, 1293671713, 1293671713, 0, 0, 0, 0, 0, 0)

[Sock Puppet]

Your subquery needs to be a valid SQL query in itself. This should probably work for you.

 

INSERT INTO node (nid, vid, type, language, title, uid, status, created, changed, comment, promote, moderate, sticky, tnid, translate) (SELECT moj_id, moj_id, 'mojocd', 'en', moj_title, 0, 1, 1293671713, 1293671713, 0, 0, 0, 0, 0, 0 FROM mojocd)

[kingnutter]

Thanks. That works perfectly and I will refer to this syntax on all my future similar queries.