I m following your course. But i had an error : Parse error near line 4: no such column: mike RT INTO users (username, password, email) VALUES ("mike", "mypassword", "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.
@bruzote
Жыл бұрын
Mine is allowing double quotes. It has been several years since I used SQL and do recall some versions (including the ANSI std, IIRC, called for single quotes). I have no idea why this version allows double quotes and why yours is not working with them. Maybe there is a VS Code setting or a setting in the SQLite extension?
@princeardalan
7 ай бұрын
Yes, double quotes are supposed to be used for identifiers (i.e. names) only. Strings of characters must use single quotes. This is written in the SQL standard commonly referred to as "ANSI standard". Regardless of which SQL implementation you use, always enclose your table names and column names in double quotes, and your string values in single quotes.
@deathspasm9
Жыл бұрын
exactly what i was looking for, thanks!
@mathew4239
2 жыл бұрын
thank you , vs code is much better than using the sqlite software
@sandilemasuku2240
Ай бұрын
12:50 Failed to open database 'c:\Users\vim\Desktop\Database_sqlite\test.db': Parse error near line 4: no such column: "table" - should this be a string literal in single-quotes? aster WHERE (type="table" OR type="view") error here ---^
@lukajovanovic3656
5 ай бұрын
Whery nice explanaining, thank you.
@bytemyke
5 ай бұрын
Glad it was helpful!
@kendcey
2 ай бұрын
Missing so much detail how is this beginning. Vs code doesn't magically start up
@bytemyke
2 ай бұрын
I apologize for the confusion. There are many tutorial videos on KZitem that will teach you how to install and run visual studio code on your device if you need help.
@arafi611
Жыл бұрын
can u advice someone to use sqlite for an android app like uber?
@imindyboyz
2 жыл бұрын
Hi Mike, thanks for your good video. anyways, How can i import .csv file into sqlite vscode ?
@builder481
2 жыл бұрын
.mode csv
@RinglisLuan
2 жыл бұрын
need db file to study
@ChrisG59
2 күн бұрын
I was stressed because some videos didn't teach how this extension worked, you saved me man! Thanks!
@Joe-wv8gl
2 жыл бұрын
Love you way you teach bit by bit, step by step, covering all of it!
@bytemyke
2 жыл бұрын
Thank you! Glad it helped
@bruzote
Жыл бұрын
I get extremely frustrated watching someone train beginners like me and they are using studio interface features that have not been explained to the beginners. For example, at 11:05, I hear clickety-clack and it seems like the mouse points at line 1, and then magically two lines of code are commented out. How did those comment markers get placed there? The viewers get zero explanation on this. Likewise for other parts of the video. It's a challenge to follow without explanations being offered. By the way, I have decades of experience in various languages and shells and studios, so it is not like I am stupid. This video is simply assuming users understand the VS Code Studio and also assumes viewers understand how and why the VS Studio Code is configured the way the video is using it. Those are invalid assumptions. I am disappointed. The expectation users have this VS Code knowledge and skill set just makes this harder than it has to be, and probably impossible for some people.
@christender3614
Жыл бұрын
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.
@veiisk
2 жыл бұрын
in case it helps = im a noob and got frustrated lost at about 14 mins. This might be above me though.
@raaghavgr1990
2 жыл бұрын
Is there any difference in syntax between Oracle SQL and SQLite?
@HeinzRuetschi
11 ай бұрын
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!
@publayout8014
Жыл бұрын
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.
@jefflambert7513
2 жыл бұрын
Good info, thank you !!!
@kamatz4156
2 жыл бұрын
Great video! glad I could be your 100th subscriber.
@bytemyke
2 жыл бұрын
Thank you!
@mdhossen7082
2 жыл бұрын
This video is Very helpful, Thanks
@relax2234
2 жыл бұрын
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.
@CM_Burns
Жыл бұрын
I keep getting "Code language not supported or defined." and can't run it.
@mdhossen7082
2 жыл бұрын
How to use this SQLite database with javascript?
@bytemyke
2 жыл бұрын
I have a video on that. Node JS SQLite Crash Course (2022) kzitem.info/news/bejne/u4iP1GqqoKB2moI
@ahassan7270
Жыл бұрын
Thank you so much. It is really an interesting tutorial and easy to understand.
@lawrencedoliveiro9104
2 жыл бұрын
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.
@swarupsudulaganti4821
Жыл бұрын
Hi @Lawrence, I'm looking for information something like this for my job interviews. (I have been trying to build simple ELT pipeline using SQLite and python )if possible could you please example links. thank you
@lawrencedoliveiro9104
Жыл бұрын
@@swarupsudulaganti4821 You can see this function in action in one of my “Python Topics Notebooks” on Git
@lawrencedoliveiro9104
Жыл бұрын
Hub.
@johnzgallerie2827
Жыл бұрын
Dude, great job. I'm gonna start following from now on!
@gokhalesadan
Жыл бұрын
helpful video
@bytemyke
Жыл бұрын
Glad to hear that!
@sonalipandagre7614
9 ай бұрын
thanks its helpful
@gopinath502
2 жыл бұрын
Don't we need to install sqlite locally in our pc .or is it ok to work in the vs code with extension .
@bytemyke
2 жыл бұрын
You do not need to install it locally. This video covers everything
@lightningg252
2 жыл бұрын
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?
@bytemyke
2 жыл бұрын
do have a video showing how to use this with PHP kzitem.info/news/bejne/uqeI3HqJcmmZqqQ. I have not made a specific video for web pages yet, but I plan to. If you want to get a head start, the basic idea is that a web form will be used to dynamically load data into the database. Reading data will work the exact same it will just be displayed in html instead of logged to the console. Please let me know if you have any questions :)
Пікірлер: 46