Re: My first SQL script
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.
Subject
Written By
Posted
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.