How to import excel to mysql?

Question

PHP

here https://www.youtube.com/watch?v=diEwQk4uY14 do this but it didn't work

Answer 1

LOAD DATA INFILE
statement
works

Answer 2

mysql workbench or dbForge

Answer 3

1. add one more and the very first one between all columns
2. in the very first one write: INSERT into table VALUES('
3. ', 'insert between ');
all
columns : tabs and replace with nothing - that is, remove extra tabs 8. the query is ready now paste it like this: