VS Code: Creating a SQLite Database from a SQL Script

Publicado el: 29 noviembre 2024
en el canal de: 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.

En esta página del sitio puede ver el video en línea VS Code: Creating a SQLite Database from a SQL Script de Duración hora minuto segunda en buena calidad , que subió el usuario Thomas Blum 29 noviembre 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 461 veces y le gustó 1 a los espectadores. Disfruta viendo!