"KKoTY" <[EMAIL PROTECTED]> wrote: > hi, you can try something like this > > mysql --force -uuser -ppass -Ddatabase -e"query.sql"
You forgot source command: mysql ... -e "source query.sql" > > where you can put all your SQL commands into to file named "query.sql" > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, February 02, 2004 8:38 PM > Subject: mysql command line syntax > >> Why does the following command, entered as a single line at a bash prompt, > prompt me to enter more? >> >> mysql -u user -ppass -D database -e 'select field into outfile > \'/tmp/field.1\' from mytable where id = 1;' >> > >> >> And is there any way to supress the 300 lines of useless usage that > accumpanies every failed attempt to execute a command? >> -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]