> So, if your papers table has the columns author_id and title, then type: > INSERT INTO papers VALUES(42, 'Mu Mesons and Quark Emissions');
Hum.. I knew that, but I meant I don't want to have to know that the author ID is 42, I want to look it up in the table AUTHORS. Anyway, the next post seems to say that I can't do it straight with MYSQL, >in theory this will work, but not with mysql. mysql does not support >(yet) subselects (those in the brackets). you can do single selects for >journal_id and author_id, save them in some variables and put together >the final insert statement with those variables. i guess you use php. do .. Yep, I have no problem doing that with php or perl, I was simply curious to know whether it was do-able with SQL commands only (not with UPDATE, all at once..) Thanks, Thomas.
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com
