VS Code: Creating a SQLite Database from a SQL Script

Publicado em: 29 Novembro 2024
no 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.

Nesta página do site você pode assistir ao vídeo on-line VS Code: Creating a SQLite Database from a SQL Script duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Thomas Blum 29 Novembro 2024, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 461 vezes e gostou 1 espectadores. Boa visualização!