Question: how to import data from excel to mysql using query?
Answer: Open your Excel file and click Save As. ... 
Log into your MySQL shell and create a database. ... 
Next we'll define the schema for our boat table using the CREATE TABLE command. ... 
Run show tables to verify that your table was created.