On 06/04/04 11:28 Bob Lockie spoke:
Rows matched=1 but rows changed=0. :-(
What is wrong with my query?
mysql> update records, audit_log, audit_log_records
-> set records.name=audit_log_records.name,
-> records.type=audit_log_records.type,
-> records.content=audit_log_records.content,
-> records.ttl=audit_log_records.ttl,
-> records.prio=audit_log_records.prio
-> where audit_log.tracker_id=audit_log_records.tracker_id
-> and records.id=audit_log_records.id
-> and audit_log.operation='C'
-> and audit_log.completed is null;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
Sometimes it works, sometimes not. :-(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]