Question: how do you 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.