Excel:
Note:
1. Create a table in MySQL with the same table structure as Excel (contains ID)
2, Excel best without any format, just pure value, otherwise you will not be able to import errors
------------------------------------------------------------------------------------------------
①
Ii
Note: When selecting a file path, make sure that Excel is opened, or the following error will be reported:
--------------------------------------------------------------------------------------------------------
③
Note: Select child table
-------------------------------------------------------------------------------------------------------
④
Note:
1, the column name line: The property is the first few lines
First row of data: Data starts from line
(Count starting from 1 )
2.
Date separator '-' and Time separator ':' indicates the time of the format '2016-03-21 12:12:12'
--------------------------------------------------------------------------------------------------------
⑤
⑥
⑦
⑧
Mysql:
Import Excel into MySQL (using navicat)