How will the data into the excel table into database tables? Solving

God, help rookie·····

Started by Leonard at December 16, 2016 - 1:44 PM

In the txt load data import

Posted by Kathy at December 28, 2016 - 2:31 PM

How to write ah?

Posted by Leonard at December 31, 2016 - 3:11 PM

Save the file as CSV, and then directly use the command in the MYSQL, please refer to the specific MYSQL manual example and description.


LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]

Posted by Duncan at January 07, 2017 - 3:16 PM