.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 February 03 2009 21:18 | |
|
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
 Administrator God of the Winds  Advanced Analyst Joined: 04.04.2008 Last Seen: 71 year(s) ago Experience: 148.13 Points: 615 |
|
| #2 God of the Winds on February 03 2009 21:41 | |
|
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: 04.11.2007 Last Seen: 10 year(s) ago Experience: 1074.3 Points: 1100 |
|
| #3 on February 04 2009 01:22 | |
|
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: 09.02.2009 Last Seen: 10 year(s) ago Experience: 80.6 Points: 450 |
|
| #4 on February 15 2009 23:15 | |
|
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: 31.05.2008 Last Seen: 10 year(s) ago Experience: 150.8 Points: 640 |
|
| #5 on March 21 2009 22:39 | |
|
EDIT BY SWIFTNOMAD. PLEASE DONT GIVE OUT ANY ANSWERS.
|
|
|
mundisum
 Member Starting Analyst Joined: 23.03.2009 Last Seen: 10 year(s) ago Experience: 4 Points: 675 |
|
| #6 on March 27 2009 06:19 | |
|
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 April 09 2009 11:35 | |
|
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
Administrator God of the Winds Advanced Analyst Joined: 04.04.2008 Last Seen: 71 year(s) ago Experience: 148.13 Points: 615 |
|
| #8 on April 09 2009 12:55 | |
|
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 April 10 2009 03:30 | |
|
Ok, thanks, I know you will find it :)
|
|
Who is watching forums
| Users viewing this page: | Guests (1) |
| Users viewing the forum: | 0 |