Hello there people, I'm sorry if this is a noob question.
I've recently installed Xampp 1.7.3a (on Ubuntu 10.04 64bit) and configured it. Everything was fine, I even went into MySQL root to set the privileges for other user.
After that, I re-logged in with the other user and created a database which was fine BUT when I tried to create table within it, I can't seem to do it so.
Following is my query statement and for the life of me, I can't figure out what's wrong with it
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''hits' ('id' int, 'song' varchar(255), 'artist' varchar(255), 'year' (int), 'gen' at line 1
It's really doing my head in and I don't know how to sort it out.
I mean in Oracle, this query statement would've worked!
So, please help me out.
I would greatly appreciate it.