154,048 views
21 votes
21 votes
How to create create a database in mysql using clv files

User Curran
by
3.1k points

1 Answer

7 votes
7 votes
Access the command line. Open whatever application you use to access your computer's command line interface.

Log into MySQL mysql -u my_user -p.

Connect to your database USE database_name;

Create a skeleton table that will house your CSV data.

Load the table with data from your CSV file.
User Alexdmejias
by
2.5k points