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 social_networking
WHERE social_networking.id=1
AND social_networking.user_id IN(11,10,24,43,124,2,7)
Hope this helps.
Dan
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, recipient, subject, body,
messages.timestamp) VALUES(1, social_networking.user_id, 'dfdf', 'adfgdf',
1144463208) WHERE social_networking.id=1 AND social_networking.user_id
IN(11,10,24,43,124,2,7)
However it doesn't appear that can be done.
Does anyone know a method to do bulk dupe inserts without using an INSERT,
compacted INSERT for each individual recipient or require the use of a temp
table?
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
