Table backup and recovery of database

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.