UPDATING 2 Tables

[aouriques]

Hi,

I'm trying use this query, but when records of the two tables are equals my server not support.
I have 12.000 records in the two tables.

UPDATE T1, T2 SET T1.name = T2.name, T1.email = T2.email WHERE T1.email = T2.email

Thanks.

[inerte]

Yay, UPDATE with multiple tables are available only on Mysql 4+ I believe.

A workaround if T1.email is an UNIQUE or a PRIMARY key is to use REPLACE SELECT

REPLACE INTO T1 (name, email) SELECT T2.name, T2.email FROM T2;

[aouriques]

Please. I need "UPDATE" comand.
I need to know the reason of this query "shutdown" my server, and obviously the solution.
My server support UPDATE with multiple tables.

[inerte]

Ok... I've tested on my server and your query ran fine with some sample data. If your server is hanging, post the last lines from your error_log file. Also post the results of this:

EXPLAIN SELECT T1.*, T2.* FROM T1, T2 WHERE T1.email = T2.email

Why can't you use REPLACE INTO?