I can do it with two lines: .separator ; .import myfile.csv mytable From then on, the data from your csv file will be available in the table "mytable" (of course you can change this name into whatever you want) Note: for the separator, you can replace the semicolon ; with a comma , or whatever separator is used in your csv file. If you don't know what separator is used, you can guess first (maybe leave it as a comma or semicolon), and then you can check if it's correct, see below... You can check whether or not you have imported it correctly by checking the headers like so: .schema mytable If you see each header listed out separately, then the import has been done well. However, if you see all of them lumped together as a single TEXT column header, then you can see the separator in between the headers, that is the separator you were supposed to use
You are the goat, it took me hours to get sql to work on vs code and you my friend explained it very well, I appreciate this so much. Thank you
you saved my night and hours of searching on sql and database. Many thanks
This is a very practical walkthrough. I recommend it highly.
10/10 instruction, you're the best
Awesome, thanks. Also love that you can just right click and run queries.
you saved my life, i was really stuck with a .db file , thank you!
Thank you so so much for this. This was so helpful
Excelent video my friend, you got my subscribe! A big hug from Guatemala
Exactly what I needed. Thank you.
Thank you for this. Very helpful! Cheers and Happy New Year from Australia - David
Thanks, Greetings from Colombia
Number one!
Ty for this tutorial sir!
Thanks
Excellent, thank you sir!
Straight to the point. Thank you man!
Thank you very much, this helped me a lot
Great vid man! The extension page has really poor instructions and this totally got me started on the right foot. Thank you.
Lot's of thanks.....❤❤❤❤❤❤
Awesome tutorial for beginner
Great vid
very helpful thanks!
instead of shortcuts, can they be displayed on the screen or be shown from the menu option?
Thank you, this was helpful
Nice!
Thank you mate, appreciated
Thank you so much sir.
Do we need JDBC to connect sqlite to java project in vscode ? or the sqlite extension is enough ?? please let me know
Very useful
Thank you so much!
Hi I already had table for sqlite how to import it to node js
amazinggggg
You help me a lot
Thank you, you help me a lot!
Thanks a lot
Thank you.
Thanks bro
thanks a lot man!!!
Muchas gracias amigo, exelente... saludos
Encantado de ayudarte
sir we need to comment ot each time for this
I don't find the command run sqlite query
thanks!
❤ gracias crack
thanks
Do you by any chance know how to import a csv file into a SQLite database? I am unfortunately having problems. Thanks anyway for the video!
I can do it with two lines:
.separator ;
.import myfile.csv mytable
From then on, the data from your csv file will be available in the table "mytable" (of course you can change this name into whatever you want)
Note: for the separator, you can replace the semicolon ; with a comma , or whatever separator is used in your csv file. If you don't know what separator is used, you can guess first (maybe leave it as a comma or semicolon), and then you can check if it's correct, see below...
You can check whether or not you have imported it correctly by checking the headers like so:
.schema mytable
If you see each header listed out separately, then the import has been done well. However, if you see all of them lumped together as a single TEXT column header, then you can see the separator in between the headers, that is the separator you were supposed to use
When making the table's columns I put empid , INTERGER and wondered why it wasn't working lol
Help!! need db file to study, pls!
What sort of db files do you need?
я тебя не понял, но понял то что ты делаешь
Не смогли смириться с поражением. И куда вас это привело? Снова ко индусам
gg
sicolait
Thankyou!
Thank you sir