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.co
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
James Lowe writes:
> ERROR: Query failed (Unknown table 'disclosure' in where clause)
>
> Is it perhaps because it is an UPDATE?
According to the manual, MySQL 4.1 will have multi-table updates.
A while back Monty stated a target release date. I'm not quite
sure about it, but I think it'll be
Dear Steve:
Thanks for your help. Actually, the table is there. the error reads
ERROR: Query failed (Unknown table 'disclosure' in where clause)
Is it perhaps because it is an UPDATE?
In Paul''s book, he says try the where clause with a select first. The
following works fine.
select fileN
Can someone tell me what I'm doing wrong?
The following SQL gets an error
"Disclosure" table not found
UPDATE patents set patents.clientNumber=disclosure.clientNumber where
patents.disclosureNumber=disclosure.disclosureNumber;
Any help would be appreciated.
Thanks.
Jim Lowe
Patent Attorney
