MySQL Forums
Forum List  »  Newbie

Re: Execute multiple statements
Posted by: Peter Brawley
Date: December 25, 2020 03:16PM

See the manual page for use of variables with Load Data.

eg given columns speed, time, day, dir ...

load data file ...
fields separated by ' '
...
( columns speed, time, @usdate, dir )
set day = str_to_date( @usdate, "%d.%m.%y" );

Options: ReplyQuote


Subject
Written By
Posted
December 25, 2020 06:05AM
December 25, 2020 11:32AM
Re: Execute multiple statements
December 25, 2020 03:16PM
December 26, 2020 04:52AM
January 21, 2021 06:44AM


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.