how to import the whole excel data into mysql code example
Example: sql query to import data from excel to mysql
$ mysql -u root -p --local-infile
mysql> create database boatdb;
mysql> use boatdb;
$ mysql -u root -p --local-infile
mysql> create database boatdb;
mysql> use boatdb;