Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as Bash by GoodV1n ( 14 years ago )
spamkiller2# /usr/local/bin/mysql -h127.0.0.1 -u user -ppass exim -e 'SELECT user_to INTO OUTFILE '/tmp/result.text' FROM  new_sended_list;'

ERROR 1064 (42000) at line 1: 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 '/tmp/result.text FROM  new_sended_list' at line 1

spamkiller2# /usr/local/bin/mysql -h127.0.0.1 -u user -ppass exim 

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 444895
Server version: 5.5.20 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> SELECT user_to INTO OUTFILE '/tmp/result.text' FROM  new_sended_list;
Query OK, 56 rows affected (0.00 sec)

mysql> exit;
Bye

 

Revise this Paste

Parent: 46136
Your Name: Code Language: