Hi All,
Does anyone have the syntax for multi-table updates?
The Online Mysql manual (for version 4.0.5) only has:
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1 [, col_name2=expr2, ...]
[WHERE where_definition]
[ORDER BY ...]
[LIMIT #]
Where as the other multi-table queries (select, delete) have separate
definitions & examples for multi-table actions.
Thanks in advance,
Fraser
_________________________________________________
Fraser Stuart
Logistics IT
77-85 Phone: +61 2 9335 1235
Roberts Rd Mobile: +61 419 233 732
Greenacre NSW [EMAIL PROTECTED]
Australia 2190 www.toll.com.au
_________________________________________________
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
