Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 3 (Many-to-Many)

Опубликовано: 02 Сентябрь 2024
на канале: Thomas Blum

This video is part 3 of a demonstration of using VS-Code with the SQLite3 Editor extension to make a quote database (imagining a backend for the Brainy Quote website). This video adds a Topic Entity (table). It also establishes that the Quote-Topic relationship is many-to-many. So in addition to the Entity table, we created a QuoteTopic table which had two foreign keys -- one connecting to Quote and the other connecting to Topic. At the end we wrote a JOIN query that connected three tables: quote, quoteTopic, and topic with two WHERE clauses (a WHERE and an AND). We established that the join was a so-called Inner Join.

Смотрите видео Using VS-Code and the SQLite3 Editor Extension to make a Quote Database -- Part 3 (Many-to-Many) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Thomas Blum 02 Сентябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 3 раз и оно понравилось людям.

14 тыс

00:00:15