You can use one of two options to insert CSV files: "Bulk Insert," a command that works from the SQL Server Management Studio, or "bcp utility," which you run from a Windows command line prompt.

Open a command line by opening the Start menu, typing "cmd" into the search bar, then clicking "Command Prompt" from the results. Log in to the MySQL server by typing "mysql -u MySQLuser -p ...

List all SQLite databases. To prove the database is indeed created, you can look for the todo.db file in the current folder, or simply issue the following command:. sqlite>.databases main: ...