Passing variable from shelle - bash to my sql script

[lhg1]

Hi

I need to give a variable to a mysql script from a bash shell script.

It is a date where the time is hardcoded in the script.

The Shell script

#!/bin/bash
#
####################################################
#     Script by Lars Grynderup                     #

echo "This script is used to insert a standart Weekday"
echo

[b]the_date=2007-03-30 [/b]

mysql -h localhost -u itdrift -pitdrift < weekday.sql

Paping the sql script into the connect string is a must, any other suggestions on how to do it is mutch appriciatede



The Sql script

use ah;

insert into test_table
values ("",
"Test of dates",
",
"0",
"",
date "[b]$the_date[/b] 06:00:00",
date "[b]$the_date[/b] 07:15:00"
);

The example dosn't work - and I tryede several other ways.

The only thing i need is to use the the_date variable in the sql script that I define in the shell.

Hope someone can help.

/Lhg

 

[hvass]

sed or you could use a macro processor like m4

 

[lhg1]

I don't know what m4 is.

But I know that i could do a sed command to change all the text in the script. But that wasn't the way I wantede to do it.

I've done something simular from unix to oracle, witch was mutch simpler.

#/bin/ksh

echo $1  


sqlplus -s test/test@oracledb <<EOF
set head off
select *
from test_table 
where filename like '$1%';
EOF

it is something like this I would like in mysql.

/Lhg

 

[hvass]

You could try the command line client mysql

mysql -e "select * from test_table where filename like '$1%'"

You might have to play around with " and ' and possibly escaping some characters. OK if you are just submitting a few SQL statements I was envisaging you were submitting whole jobs.