Error in mysql syntax
amsy10
-
le père -
le père -
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?
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?
A voir également:
- Error in mysql syntax
- Girl in the basement streaming vf - Forum Cinéma / Télé
- In da place - Forum Mail
- Navigation in private - Guide
- Dc in - Forum Disque dur / SSD
- Network error ✓ - Forum Réseaux sociaux
