Text file import MySQL database table and insert command inserts data into table

1, Text file Import database table format:mysql> load data local INFILE ' text path ' into table table name; example:mysql> load data local INFILE ' d:/pet.txt ' into TABLE pet;<pre name= "code" class= "plain" > can create a text file "Pet.txt", each line containing a record, with a locator (tab) to separate the values, and create The column order listed in the table statement. For null values, in order to represent empty content in your text file, use \ n = (backslash, letter N, uppercase N). 2. Data insertion table can also insert into pet VALUES (' puffball ', ' Diane ', ' hamster ', ' f ', ' 1999-03-30 ', NULL) with insert command;

Text file import MySQL database table and insert command inserts data into table