SQLite beginner crash course in Visual Studio Code - 2022

Показать описание

Full SQLite crash course! Come learn how to use SQLite inside of vs code and crush the crash course with this tutorial! Learn how to Create, Select, Update, Delete, Insert Into, and much more in this tutorial!
Timestamps

00:00 Intro
00:50 Slides
08:00 VS Code Setup
09:35 Creating a table
11:15 Inserting data into a table
13:30 Querying data from a database
15:30 Where
23:00 Updating a row
24:45 Deleting a row

#sqlite
#vscode
#database

Рекомендации по теме

Комментарии

I m following your course. But i had an error : Parse error near line 4: no such column: mike
To fixe that issue i went to the web. And I found the reason. I must use the simple quote for a TEXT and not a double quote.
I don't know why with the same software and syntax, we don't have the same result
I hope it will be helpfull for those who will have this problem.

tibqvvv

Love you way you teach bit by bit, step by step, covering all of it!

Joe-wvgl

Dude, great job. I'm gonna start following from now on!

johnzgallerie

exactly what i was looking for, thanks!

deathspasm

Great video! glad I could be your 100th subscriber.

kamatz

Thank you so much. It is really an interesting tutorial and easy to understand.

ahassan

7:33 Regarding username, it’s actually a 1:n relation, not 1:1. The same username can show up /n/ times in the videos table.

christender

SQLite and Python are a potent combination. For example, I wrote a simple generator function called db_iter that, given an SQL query, returns an iterator over the query results. Saves continual messing about with cursors.

Another handy technique is using dict+zip on tuples of field names and returned field values, to produce a dictionary mapping the names to the values.

lawrencedoliveiro

thank you, vs code is much better than using the sqlite software

mathew

Great info and you explain things very well, thank you! Do you have a tutorial on the next step of using php to display sqlite data on a webpage?

lightningg

Hi Mike, there is a problem with the SQLite extension V0.14.1 in VSC when trying to open database test.db file with right click. However, the test.db file ist ok when opened with sqlite3.exe. Unfortunately I did not find any solution to this issue. The training video by itself worked greate. Thank you very much!

HeinzRuetschi

Is there any difference in syntax between Oracle SQL and SQLite?

raaghavgr

strange, it dowsn´t work, perhabs i try to find a vid which shows, how to create folders with the name sqlite and connect with the database.

relax

Hi Mike, thanks for your good video.
anyways, How can i import .csv file into sqlite vscode ?

imindyboyz

Can't create a table. Popup says I neeed to choose a connection profile from a list below. Then it offers to search for a connection. Apparently, VS Code has been modified to make this code impossible to execute. I burned up hours looking for an answer, but found nothing on the web so far.

publayout