Bonjour,
Je suis sous linux fedora .
quand je fais ma requête ci-dessous :
dir=/var/lib/mysql/amsy
mysql --user=ro --password=ro <<EOF
use call;
for num in 626 623
do
select Anum,sum(duree),sum(cout),count(*) from call.12 where Anum=$num and date between '20111202' and '20111203' group by Anum outfile donnee_CMO_$date ;
EOF
j'obtine l erreur là
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'for num in
626 623
quelqu'un pourrait m'aider?
