probablement en faisant un truc du genre :
echo "commande sql "$valeur" where ..... "$variable" ; " | interpreteurSQL
exemple :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| $ unset toto ; unset titi
$ toto=20
$ titi=gazoil
$ echo "select * from "$titi" where ref >= "$toto" ; " | mysql -u francois -p perso -h undertaker
Enter password:
ref date prix km
20 2011-07-03 39.83 564
21 2011-08-01 56.26 716
22 2011-08-27 54.85 722
23 2011-09-17 46.7 581
24 2011-10-09 55.4 708
25 2011-11-01 58.47 718
26 2011-11-29 57.74 691
$
$
$ unset toto ; unset titi |
Partager