At 11:28 -0400 6/4/04, Bob Lockie wrote:
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
Perhaps nothing. If the statement WHERE clause selects a row to
update, but the column assignments do not actually change any values
(e.g., they set the columns to the values they already have), the Changed
count will be zero.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
