Web lists-archives.com

update, insert ... gee.. a puzzle




.. that you experts I hope can crack like a digestive biscuit...

how does one update, or merge or whatever is right technical term for it - a my.table from my.another table (both are schematically identical, no foreign keys, one primary key) but.. does it a way so when there is a duplicate only NULLs in my.table get updated/replaced with proper values from my.another table?

many thanks, specially for actual syntax hints.
L.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql