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