Import an Excel table into MySQL

//Import Excel Table method one:1Open Excel Save as CSV file2) Convert the file encoding to UTF8, using Notepad++Open CSV file, choose Format-Convert to UTF8 encoding format-save2to build the table in MySQL, the order of the fields is consistent with Excel3）LoadData local infile'[your CSV file path]'  into Table [Table name]Fields terminated by ','; for example:LoadData local infile'E:\\1.csv'  into TableGift_list Fields terminated by ','; Note:3.1The delimiter for the CSV file is a comma, so the last terminated by followed by a comma. 3.2If it is a tab, use the'\ t', this step remembers to check log, must not be warning to be counted as successful. 3.3If you can't determine whether a tab or a comma is between the fields, import it once to see the results of the import see the Reference link: http://Www.cnblogs.com/Latifrons/Archive/ -/ the/ -/2675141. html method Two: Open the table's data interface, select "Import Data" to start the process of importing files

Import an Excel table into MySQL