mysqldump syntax error
Posted: Wed Dec 11, 2002 11:36 am
I need to run this mysqldump:
The problem is the syntax is just not correct.
If is use --where=id_fitxa<100 instead of --where=id_fitxa IN ($llista), the code works fine.
Anyway, I don't want to dump records with id_fitxa below 100, but records with id_fitxa contained in $llista.
Code: Select all
passthru("mysqldump --add-drop-table -hlocal -ume -pmypass database table --where=id_fitxa IN ($llista)|mysql -haway -usomeone -psomepass database");If is use --where=id_fitxa<100 instead of --where=id_fitxa IN ($llista), the code works fine.
Anyway, I don't want to dump records with id_fitxa below 100, but records with id_fitxa contained in $llista.