.png)
Zero Identity Forums - General - Rules / Announcements / Suggestions - Skills Center: Lesson #1 - SQL - problems
Are you bored? Check out the unaswered threads!
| #1 Skills Center: Lesson #1 - SQL - problems on 01/01/1970 00:00 | |
|
Hello, i've been testing out the challenge system and to be honest i cant understand WHY it`s not working.
Having around 7 years of MySQL Experience this kind of bummed me up since my answers did not work in your tests opposed to a real live db test. EDIT BY AQUILO: I understand that you are trying to make a point, but the evidence you used was the answer to some of the earlier questions in the test. We don't want to spoil this for our other users Neither sql statements worked and i gave up trying. Please specify WHY they did not since they are valid in any current MySQL version ( at least ver 3.0 to 5.1 ). Or if these sql statement questions are based on another Database Server / Database Technology please specify it in the lesson`s description! Thank you for taking the time to read my post. Micky. P.S. I realize this is my first post but take a look anyway. |
|
|
Aquilo
 Member God of the Winds  Advanced Analyst Joined: 04/04/2008 Last Seen: 0000-00-00 Experience: 148.13 Points: 615 |
|
| #2 God of the Winds on 01/01/1970 00:00 | |
|
The SQL test is on an actual MySQL database. It is not simulated in anyway. Please check your answers again.
We cannot specify why your answers are not working because that would essentially be giving you the answer. May the Winds be with you. |
|
|
Grindordie
Administrator Software Engineer  ZI Guru Joined: 11/04/2007 Last Seen: 0000-00-00 Experience: 1207.57 Points: 1100 |
|
| #3 on 01/01/1970 00:00 | |
|
A correcting to Aquilo's post, we use SQLite databases for the challenges.
The syntax for SQLite as far as my knowledge goes is the standard SQL syntax. The only problem I can imagine is if you are not entering the correct table or field names. |
|
|
Psiber_Syn
Member alert(HIGH)  Starting Analyst Joined: 02/09/2009 Last Seen: 0000-00-00 Experience: 80.6 Points: 450 |
|
| #4 on 01/01/1970 00:00 | |
|
i too have problems with the skillz center sql test 6 7 and 9 my formate is correct and my fields are also yet it doesnt work :-(
  
|
|
|
oofki
 Member Advanced Analyst Joined: 05/31/2008 Last Seen: 0000-00-00 Experience: 150.8 Points: 640 |
|
| #5 on 01/01/1970 00:00 | |
|
EDIT BY SWIFTNOMAD. PLEASE DONT GIVE OUT ANY ANSWERS.
|
|
| #6 on 01/01/1970 00:00 | |
|
I'm having problems with the insert, update and delete... can't get them to work and I know I'm entering valid SQL-syntax.
|
|
| #7 on 01/01/1970 00:00 | |
|
There are indeed problems, I'm quit sure,
maybe the 'designer' from the chall, had something else in mind, but my method works fine too! Can I PM someone, to say what I think also is possible but doesn't work? Thanks! |
|
|
Aquilo
Member God of the Winds Advanced Analyst Joined: 04/04/2008 Last Seen: 0000-00-00 Experience: 148.13 Points: 615 |
|
| #8 on 01/01/1970 00:00 | |
|
Yes we know it is broken, and we openly admit this...and we are trying to fix it, but we can't find why it doesn't work. Trust me, we are working on it...thank you for your concern though.
May the Winds be with you. |
|
| #9 on 01/01/1970 00:00 | |
|
Ok, thanks, I know you will find it :)
|
|
Who is watching forums
| Users viewing this page: | Guests (1) |
| Users viewing the forum: | 1 |