Import data into the specified file: Table expressioninto outfile ' filename ' < option name > |into dumpfile ' filename ' |into <user variable> &L t;,.... >< Option name: Fields [terminated by [literal]] .... lines terminated by <literal>as:select *from tes The outfile ' test.txt ' has imported the test data into the Test.txt file, and under Linux, the Test.txt and test tables are stored in the same default value:
Fields terminated by ' \ t '
Lines terminated by ' \ n '
Enclosed by '
escapsed by ' \ \ ' as:select *from testinto outfile ' test.txt ' fields terminated by ', ' lines terminated by '? ' Represents the exported data, separated by ', ' between the fields, using '? ' between the lines. Separate As:select * from Testinto outfile ' test.txt ' fields terminated by ', ' optionally enclosed by ' ' lines terminated by '? ' Indicates that the character is surrounded with ' ' ', if all is surrounded with ' ' ', then does not add optionally also can be used dumpfile, but all rows are next to each other, the value and the row is not any sign as:select *from testinto dumpfile ' Test.dump ' Load data data table, [low_priority][concurrent][local]infile ' filename ' [replace]into table Tablename[fields Terminated by Literal][lines terminated by Literal]as:load data infile ' test.txt ' replaceinto table test;as:load data infil E ' test.txt ' Replaceinto table Testfields terminated by ', ' line terminated by '? '
Table backup and recovery of database