Try:
echo "
load data infile '/home/loader/txt/file_${date_proc}.txt' into table debits
fields terminated by ';'
" | mysql -u user -ppass dbname
Oswaldo Castro wrote:
>Hi List
>
>I'm new to MySQL and I need help on how to pass shell parameter to a mysql
>script file (bash/SuSE 7.2)
>
>I have
;
Gurhan
-Original Message-
From: Oswaldo Castro [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 9:39 AM
To: [EMAIL PROTECTED]
Subject: Parameter passing on shell script
Hi List
I'm new to MySQL and I need help on how to pass shell parameter to a mysql
script file
Hi List
I'm new to MySQL and I need help on how to pass shell parameter to a mysql
script file (bash/SuSE 7.2)
I have one file called run_db_load and I called it from the command line as
# date_proc=25032002
# export date_proc
# ./run_db_load $date_proc
Inside the run_db_load file I have: