Re: Parameter passing on shell script

2002-03-25 Thread Gerald Clark
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

RE: Parameter passing on shell script

2002-03-25 Thread Gurhan Ozen
; 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

Parameter passing on shell script

2002-03-25 Thread Oswaldo Castro
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: