update, insert ... gee.. a puzzle

lejeczek <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <[email protected]>
..  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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.