update same table from another database
update db1.table1 set varcharCol=null
where db2.table1.varcharCol=null
where db2.table1.varcharCol=null
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
chaau
Thanks mwvisa. I have noticed that after I have written my post. You are right, for MySQL server the syntax will be slightly different
ASKER
I am using mysql not microsoft sql
will this solution work for mysql
will this solution work for mysql
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
this updates one table with values from another, thanks