MySQL Forums
Forum List  »  MySQL for Excel

Re: LOAD DATA LOCAL INFILE, but only if the Snapshot date isn't the CURDATE
Posted by: Javier Treviño
Date: May 23, 2017 11:28AM

Hi JP,
This forum is intended for the MySQL for Excel product which is an Excel add-in.
For your question you should refer to a different forum.
As far as I can tell the SQL statement you are writing is totally invalid, you can't mix an IF statement with a SELECT, IF statements are meant to be used with stored procedures only.

You should write a stored procedure that you can execute from VBA where you can have your conditional that loads the data.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: LOAD DATA LOCAL INFILE, but only if the Snapshot date isn't the CURDATE
91
May 23, 2017 11:28AM


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.