hi, you can try something like this mysql --force -uuser -ppass -Ddatabase -e"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? > > > Thanks njs. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
