Replace data column with another column from another table

Question

I would like to replace the data column in the table.

Tablea
Uid - int
AnotherUid - int

Tableb
Uid - int

TableA.uid = Table .B uid And I'm trying to replace TableB.Uid with TableA.AnotherUid

Select * from TableB a, TableA b where a.uid=b.uid update TableB set a.uid=b.AnotherUid 

I got a SQL syntax error from MySQL in TableB set by a.uid = b.AnotherUid.

Please, kindly help.

Answer 1

 UPDATE TableB T SET T.uid = (SELECT AnotherUid FROM TableA A WHERE A.uid = T.uid) 

Answer 2

 UPDATE TableB SET TableB.Uid = (SELECT AnotherUid FROM TableA WHERE TableA.Uid = TableB.Uid) 

Answer 3

Try this query:

 Update TableB, TableA Set TableB.uid = TableA.AnotherUid Where TableB.uid = TableA.uid; 

For MySQL guidance on connecting in an update request, refer to http://dev.mysql.com/doc/refman/5.0/en/update.html and see this example in your document:

 UPDATE items,month SET items.price=month.price WHERE items.id=month.id;