sql quiries

Importing CSV or JSON files into a MySQL Database Ashraf Shirani

• In MySQL database server, right-click on a database/schema name, and select Table Data Import Wizard.

• Browse to select a CSV or a JSON file to import. Then click Next.

Choose “Create new table”:

• Select/de-select the columns that you want to import, and if necessary, change the data

type/s.

• Click Next.

• Click Next.

• Refresh the database and see the imported csv file will appear as a new table in the

database schema.