Excel data import MySQL

Since importing Excel data with Dbeaver Import is unsuccessful, the following methods are used:

1 Excel Save as CSV file--Open with Notepad--Save as TXT file, set encoding UTF8;

2 MySQL new table Data_analyst

3 Load Data local infile ' f:/dataanalyst.txt ' into table data_analyst fields terminated by ', ' (TXT file, separating different columns)

Load data local infile ' f:/dataanalyst.txt ' into table data_analyst fields terminated by ' \ t ' (the TXT file separates different columns with line breaks)

Excel data import MySQL