MySQL Forums
Forum List  »  Newbie

Re: My first SQL script
Posted by: Peter Brawley
Date: December 01, 2016 11:42AM

Best to check the manual page for a capability before you try to use it for the first time.

In MySQL, the + operator is exclusively arithmetic. Use Concat() to concatenate strings.

But there's a more fundamental problem: MySQL PREPARE does not support LOAD DATA, so to parameterise multiple invocations of LOAD DATA, you will need to use a more complete language, eg PHP.

Options: ReplyQuote


Subject
Written By
Posted
S B
December 01, 2016 11:21AM
Re: My first SQL script
December 01, 2016 11:42AM


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.