How Can I Easily Import Excel Data into My MySQL Database?

Importing Excel Data into MySQL Database: A Simple Tool

Importing an Excel file into a MySQL database can be a tedious task, but there's an online tool that simplifies the process: SQLizer.io.

Using SQLizer to Import Excel Data into MySQL

1. Upload your XLSX file: Visit sqlizer.io and click "Upload a File" to select your Excel file.
2. Specify sheet name and cell range: Enter the name of the worksheet containing the data and the specific range of cells.
3. Generate SQL statements: Click "Create SQL" to generate a CREATE TABLE statement and INSERT statements to import the data.
4. Copy and paste into MySQL: Copy the generated SQL statements and paste them into your MySQL command window (e.g., MySQL Workbench, MySQL Shell).

Your Excel data will now be imported into a MySQL database.

Example

Consider the following Excel table:

Using SQLizer, you can easily import this data into a MySQL database with a few simple steps. The generated SQL statements would look something like this:

CREATE TABLE IF NOT EXISTS excel_data (
  Country VARCHAR(255) NOT NULL,
  Amount INT NOT NULL,
  Qty DECIMAL(5,2) NOT NULL
);

INSERT INTO excel_data (Country, Amount, Qty) VALUES
('America', 93, 0.60),
('Greece', 9377, 0.80),
('Australia', 9375, 0.80);

The above is the detailed content of How Can I Easily Import Excel Data into My MySQL Database?. For more information, please follow other related articles on the PHP Chinese website!