MySQL supports transactions so you can submit multiple SQL statements
and commit them all at once.
example of statement (from www.mysql.com)
BEGIN;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summmary=@A WHERE type=1;
COMMIT;
Robert Klinkenberg
-Oorspronkelijk bericht-
Van: andRie Is [SMTP:[EMAIL PROTECTED]]
Verzonden:Friday, July 13, 2001 2:19 AM
Aan: [EMAIL PROTECTED]
Onderwerp:[PHP-DB] data consistency
Hello php-db,
is PHP / Mysql could handle multiple access into table to keep data
consistency ?
,,,
(@-@)
+==---o00(_)00o-==+
It is better to be defeated on principle than to win on lies.
--Arthur Calwell
--
Best regards,
andRie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]