VS Code: Importing CSV files to make a SQLite Database

Описание к видео VS Code: Importing CSV files to make a SQLite Database

In this video we use VS Code with two SQLite extensions to import a CSV (comma separated values) file to create a table in a database. The first row of the CSV file was the names of the columns in the database table. As is normal when a file is parsed, the types are assumed to be Text. However, we can change the types, say to INTEGER or DECIMAL, and even add roles such as making a column the PRIMARY KEY or indicate that it REFERENCES another column in another table (that is, makes it a foreign key). We wrote a few queries. We exported the results of one of the queries as CSV. And we ended with exporting one of the tables as a JSON (JavaScript Object Notation) file.

Комментарии

Информация по комментариям в разработке

Похожие видео