Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 2

Published: 02 September 2024
on channel: Thomas Blum

We continue are demonstration of making a SQLite database using the Visual Studio Code (VS-Code) environment with the SQLite3 Editor extension to make a database on Quotes (like what's behind the Brainy Quotes website). Previously we made an author table. This time we made a Quote table with three fields: a primary key quoteID (auto-incremented), a quoteText , and a foreign key quoteAuthorID that references the pre-existing author table. We show how to insert some records into the quote table. Then we write some SELECT queries. SELECT * . Then SELECT certain fields. Next add a WHERE clause. And finally a JOIN query that displays authors and their quotes.

Watch video Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 2 online without registration, duration hours minute second in high quality. This video was added by user Thomas Blum 02 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 34 once and liked it 0 people.

16,572

850