PDA

View Full Version : A note to the MySQL beginning programmers...


Jaiibee
03-09-2009, 09:47 PM
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..