Exporting Data Out of a Table : Save To Text File « Backup Load « SQL / MySQL






  1. SQL / MySQL
  2. Backup Load
  3. Save To Text File

Exporting Data Out of a Table

        
mysql>
mysql> CREATE TABLE CDs
    -> (
    ->     CDID SMALLINT NOT NULL PRIMARY KEY,
    ->     CDName VARCHAR(50) NOT NULL,
    ->     InStock SMALLINT UNSIGNED NOT NULL,
    ->     Category VARCHAR(20)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO CDs VALUES
    -> (101, 'Xml', 10, 'Rock'),
    -> (102, 'SQL', 17, 'Jazz'),
    -> (103, 'MySQL', 9, 'Classical'),
    -> (104, 'CSS', 24, NULL),
    -> (105, 'Oracle', 2, 'Blues'),
    -> (106, 'Data type', 12, 'Country'),
    -> (107, 'Flash', 5, 'New Age'),
    -> (108, 'Photoshop', 42, 'Classical'),
    -> (109, 'MacBook', 20, 'Opera'),
    -> (110, 'Notebook', 23, 'Country'),
    -> (111, 'Pascal', 18, 'Jazz'),
    -> (112, 'Ruby', 22, 'Blues'),
    -> (113, 'C', 42, 'Blues');
Query OK, 13 rows affected (0.00 sec)
Records: 13  Duplicates: 0  Warnings: 0

mysql>
mysql>
mysql>
mysql> SELECT CDName, InStock, Category
    -> INTO OUTFILE 'CDsOut.txt'
    -> FROM CDs;
mysql>
mysql> drop table CDs;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

1.Backup records into txt file
2.Backup table records into txt file: indicate terminator
3.Set OPTIONALLY ENCLOSED
4.set ENCLOSED terminator
5.Escape sign
6.Create dump file
7.Add null value to dumped file
8.Dump data into a text file
9.Dump data into text file and change the default terminators
10.Change the terminator for fields
11.Change the ternimator for lines
12.Exporting Data to a Dump File
13.Adding an ESCAPED BY subclause:
14.LINES subclauses.
15.To put the rows on separate lines, you must modify the TERMINATED BY subclause
16.Terminates each line with <>
17.To export the passwd table in CSV format with CRLF-terminated lines, use this statement: