Re: Bulk Duplicate Inserts

2006-04-08 Thread Dan Buettner
Are you wanting to insert into two tables (messages, social_networking) with one statement? If not, an INSERT / SELECT might work well for you. Like so: INSERT INTO messages (author, recipient, subject, body, timestamp) SELECT 1, social_networking.user_id, 'dfdf', 'adfgdf', 1144463208 FROM soc

Bulk Duplicate Inserts

2006-04-07 Thread Martin Gallagher
Hi, In a messaging system I'm working on, I will allow user's to send the same identical message to numerous other people. Kind of like in email you can separate recipients with ";" or use CC. It would be nice to be able to perform a query like so: INSERT INTO messages, social_networking (author