I am trying to update a table with a column from a different table. The code I am trying is:

UPDATE table1, table2
SET table1.column = table2.column
WHERE table1.id = table2.id

It works updating the table but it is locking both tables while it runs. I need to find a way to update a table without locking both tables


Thanks

Henry

hi,
try with this
update TableOne
    inner join TableTwo on TableOne.commonID = TableTwo.commonID
    set TableOne.field1 = TableTwo.fieldX

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com

Is it possible to add a prefixes zeros on a auto_increment field without adding new field. If ever how could I attain this goal?

More Power!

hi vickr1z,
already i post answer for this question
CREATE TABLE `tblname` (
          `fieldname` int(3) unsigned zerofill NOT NULL auto_increment,
          PRIMARY KEY (`fieldname`)
        )

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com