Hi,

Can somebody tell me if there is a way to accomplish this update without
locking both tables.

UPDATE t1, t2 SET t2.a = t1.a WHERE t2.id = t1.id

t1 is not being updated yet it becomes locked and does not allow any
read queries until it is done.

Can somebody help?

Thanks,

 Mike.

 



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************

Reply via email to