Assume that you have two tables (in two different databases):
table A in database dbA:
------------------------
id CHAR(6)
foo int
bar int
table B in database dbB:
------------------------
id INT(6)
foo int
bar int
Both tables has a several records with identical ID values, but the format is
different ('001234' vs 1234).
Is it possible to create a update query that copies the 'foo' and 'bar' from
table dbA.A to dbB.B for each record in dbB.B?
--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
