Hi this might be a stupid question, but I was wondering why now the SQL code is all written in capital letters?
Why this: SELECT * FROM users;
And not this: select * from users;
I tried both in the online text editor and they both work but will this also work in the real world?
What is even suppose to happen? I copy and paste that query and nothing happens… I go to get unstuck and replace with their solution and I sill don’t see anything highlighted when I hit run. I’ve tried on different computers and it is driving me INSANE.
Here’s a series of questions I would have liked answered in this exercise so as to understand how SQL is articulated better:
We start on default page users.sqlite that is empty. The query we make magically fetches data and displays it in the app display and returns all elements from the database.
Questions 1 : where is the app built? I don’t see html/CSS/JS content in the directory
Question 2 : what does users refer to in the query? If it refers to the page we’re working on (users.sqlite), how can it result in anything since it is seemingly empty before our query? How is the database targeted in this syntax?
Question 3 : If tmp.txt is the content of the database, then what is the role of the db.sqlite (which I assume is the “engine” of the database)
I’m curious about those being valid questions and whether they should be addressed in the intro to SQL exercise. After all, we were shown clearly how the communication happens between html and css files, how JS is “self contained” in an html page and affects said page. Here it feels like everything is disconnected in SQL.
hey there, I was wondering if sql is for storing and managing data in a sturctured query, doesn’t this makes it backend programing language. This might be dummy question but I am in Front-End develpment course and I was kinda congused. But nevermind read everything wait I just got it the topic of syllabus is Overview of Web Development…
Quick question, the information generated by SQL… is it the information stored on a web site when a person inputting their personal info into a form or login, you know like login into Google for the first time but the second time base on what is being typed in it remembers similar context ?
Holy crap I was so spooked when all that info was just there, supplied, after the user entry thing. I’m sure to get that information the site is set up a specific way/probably needs log in information or something, but still. That was so easy!
) below!
) to up-vote the contribution!