VS Code: Creating a SQLite Database from a SQL Script

Published: 29 November 2024
on channel: Thomas Blum

461

In this video we demonstrate using VS Code (with two SQLite extensions installed) to execute two SQL scripts. The first script creates two tables and inserts some records into each table. Creating a table is part of the Data Definition Language (DDL), while inserting rows is part of the Data Manipulation Language (DML). We also point out that the metadata (table and column names) may appear in tick marks, whereas the actual data may appear in single or double quotes. If the script is highlighted in VS Code, it is invoked by going to View/Command Palette/SQLite: Run Query (even though strictly speaking it's not a query). In the first script each record/row of data was inserted using a single SQL statement. In a second script we show the syntax for a "multi-insert" -- a single SQL statement that inserts more than one record.

On this page of the site you can watch the video online VS Code: Creating a SQLite Database from a SQL Script with a duration of hours minute second in good quality, which was uploaded by the user Thomas Blum 29 November 2024, share the link with friends and acquaintances, this video has already been watched 461 times on youtube and it was liked by 1 viewers. Enjoy your viewing!