Re: MySql CSV and also Update command help request
1 exponential format
2 Set needs '=', not 'to'. With the left join in your update ...
update tablea as a
left join tableb as b on a.link = b.link
set a.pallet=b.pallet, a.tray=b.tray ;
... rows in a with no matching b.link will get null pallet and tray values. Is that desired?
Subject
Written By
Posted
Re: MySql CSV and also Update command help request
January 25, 2017 07:49PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.