Hi,
I’m new to MySQL so don’t kill me for my limited knowledge (and probably stupid question
I’m running MySQL (version 3.23.36) using Red Hat Linux 7.1.
I’m using a Linux bash script with commands like this:
Mysql < MySQL_Batch
The MySQL_Batch file has a command like:
LOAD DATA LOCAL INFILE “file.txt” INTO TABLE Raw;
Is it possible to pass parameters from my Linux bash script into my MySQL Batch file? For instance I don’t want to use “file.txt” all the time but change to “file2.txt” when I like it?
Kind regards,
Tjeerd Talman (Amsterdam, The Netherlands);
I’m new to MySQL so don’t kill me for my limited knowledge (and probably stupid question
I’m running MySQL (version 3.23.36) using Red Hat Linux 7.1.I’m using a Linux bash script with commands like this:
Mysql < MySQL_Batch
The MySQL_Batch file has a command like:
LOAD DATA LOCAL INFILE “file.txt” INTO TABLE Raw;
Is it possible to pass parameters from my Linux bash script into my MySQL Batch file? For instance I don’t want to use “file.txt” all the time but change to “file2.txt” when I like it?
Kind regards,
Tjeerd Talman (Amsterdam, The Netherlands);