A note to the MySQL beginning programmers...
 

Always put a space after the table name!

CREATE TABLE tablename(c1 INT);

WILL NOT WORK because it thinks that the table name is "tablename(c1 INT);", not "tablename".

Sorry, that's just a little problem that has been bugging me for around a month now, thought i'd share that.

What WOULD work;
CREATE TABLE tablename (c1 INT);

You don't realize how much confusion and anger has been induced over the past month because I simply didn't realize this..