on this site http://sqlfiddle.com/#!9/c6bc3 first message i press button build schema.It says "ready schema" after i press "run sql" and nothing happens.I go the other site http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all and nothing happens..Tim Moores wrote:What does "I failed to do it" mean? What, exactly, did you do, and what, exactly, were the results? Post all system messages or errors you may have got in full.
prepopulated query : you mean that it work the codes i gave it ?(because i tested i again the codes in w3school but nothing for me).Tim Moores wrote:I see, the question isn't so much about SQL as it is about those sites. Sqlfiddle doesn't work for me either in a quick test, but w3schools returns results when I click the "Run SQL" button with the prepopulated query.
The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.
You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.
In SQL the standard is single quotes.
i am very thankful about your help you give meTim Moores wrote:
In SQL the standard is single quotes.
Good point, although that SQL editor does actually allow the use of double quotes. But best not to get into the habit.
Tim Moores wrote:
In SQL the standard is single quotes.
Good point, although that SQL editor does actually allow the use of double quotes. But best not to get into the habit.
https://kripken.github.io/sql.js/GUI/ i did it on this site .I think its much better and it worked fineTim Moores wrote:Not sure what you mean by "on mozilla", but as I said, the editor apparently can handle single statements only. So try that instead of multiple statements at a time.
The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.
You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.
akol ompen wrote:
I try this code from a video https://www.youtube.com/watch?v=7Vtl2WggqOg but i failed to do it .I use http://sqlfiddle.com/#!9 and after this site http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all but i failed to do it like she does on the video.I cant find my mistake or she is doing it wrong?or this online sites isnt good?