MySQL – SELECT * INTO OUTFILE LOCAL ?

by

From the manual: The SELECT ... INTO OUTFILE statement is intended primarily to let you very quickly dump a table to a text file on the server machine. If you want to create the resulting file on some client host other than the server host, you cannot use SELECT ... INTO OUTFILE. In that case, you should instead use a command such as mysql -e "SELECT ..." > file_name to generate the file on the client host.”

http://dev.mysql.com/doc/refman/5.0/en/select.html

An example:

mysql -h my.db.com -u usrname--password=pass db_name -e 'SELECT foo FROM bar' > /tmp/myfile.txt

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '0
  2. how to delete data from table A besides the customer service and director data in table B?
  3. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  4. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  5. MySQL/MariaDB – order by inside subquery
  6. Cast int to varchar
  7. MySQL export into outfile : CSV escaping chars
  8. Recreating a query using INNER JOIN? [duplicate]
  9. Create a Cumulative Sum Column in MySQL
  10. Equivalent of explode() to work with strings in MySQL
  11. How can I tell when a MySQL table was last updated?
  12. mysql select dynamic row values as column names, another column as value
  13. MySQL DELETE FROM with subquery as condition
  14. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  15. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  16. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  17. Simple Random Samples from a Sql database
  18. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  19. Determine Rank based on Multiple Columns in MySQL
  20. Checking multiple columns for one value
  21. What is better in MYSQL count(*) or count(1)?
  22. Delete query not working in mysql
  23. How to enable INNODB in mysql
  24. Bash script to insert values in MySQL
  25. MySQL GROUP BY DateTime +/- 3 seconds
  26. How do I lag columns in MySQL?
  27. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  28. How to use a user variables in MySQL LIKE clause?
  29. Syntax error on MERGE statement
  30. Update multiple rows with multiple ‘where’ clauses for each individual row

Leave a Comment