how to do sql scrip to import data from excel mysql terminal 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;