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
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_reco
On Wednesday 22 January 2003 21:10, Norris Joseph wrote:
> Hello,
>
> I have the following in my SQL:
>
> update call_center set call_center.who_for_id = activeemployees.hr_emp_no
> where call_center.who_for_id = activeemployees.id;
>
>
> This is something I think that I should be able to do, but
-Original Message-
From: Norris, Joseph
Sent: Wednesday, January 22, 2003 10:56 AM
To: Mysql_List (E-mail)
Subject: question about update sql
Hello,
I have the following in my SQL:
update call_center set call_center.who_for_id = activeemployees.hr_emp_no
where call_center.who_for_id
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
