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
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
Hi
we have what we think is a bug regarding an insert (or an update) during times of
heavy load on the mysql server. Our application should perform an insert in one table
and updates on two other tables but the insert is performed up to 9 times.
I'm not entierly sure that the problem is NOT in
ONLY that
part of the body tag, the duplication problem went away.
- Original Message -
From: "Eddie Heard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 20, 2001 12:05 AM
Subject: Duplicate Inserts
> I'm running MySQL on a WIN2k
I'm running MySQL on a WIN2k server box. I'm doing inserts using PHP.
Here's the code for the insert:
$db = mysql_connect($hostname, $uid, $pwd); //$hostname is "localhost" and
$uid/$pwd are userid and password
mysql_select_db("heroes",$db);
$insertQuery = "INSERT INTO UniqueCardList (MCardI
