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
- Dc in - Forum Audio
- Deco in paris avis ✓ - Forum Consommation & Internet
- In da place - Forum Mail
- Network error iptv - Forum Réseaux sociaux
- Aux in ✓ - Forum Enceintes / HiFi
