I just started using MySQL and I keep getting a syntax error and I can't figure out why. Here is the syntax I'm using:
mysql>CREATE TABLE tablename(column1 VARCHAR(20), column2
-> VARCHAR(20))
This is the way it says to do it in the manual but I keep gettin this syntax error can someone tell me what I am doing wrong.Can you tell me what the error says??? Also, are you using a DOS consol or is it in a language like php or asp???
I may be able to help you, but I need to know a little more. Im still a beginner when it comes to database stuff, but Ive got the MySQL syntax down.Thanx for tryin dude but I figured it out. I was just leaving a space out before the comma.spce before the comma didn't fix it. those don't matter.Scoutt, sorry to disagree with you but thats what made it work..but maybe you are right I dunno all I know is that I got it working now.I am glad you got it working but if the space matters than why does this work
CREATE TABLE emails (
id int(11) NOT NULL auto_increment,
section varchar(200),
message text NOT NULL,
PRIMARY KEY (id)
);
notice the commas, no space before them.
mysql>CREATE TABLE tablename(column1 VARCHAR(20), column2
-> VARCHAR(20))
This is the way it says to do it in the manual but I keep gettin this syntax error can someone tell me what I am doing wrong.Can you tell me what the error says??? Also, are you using a DOS consol or is it in a language like php or asp???
I may be able to help you, but I need to know a little more. Im still a beginner when it comes to database stuff, but Ive got the MySQL syntax down.Thanx for tryin dude but I figured it out. I was just leaving a space out before the comma.spce before the comma didn't fix it. those don't matter.Scoutt, sorry to disagree with you but thats what made it work..but maybe you are right I dunno all I know is that I got it working now.I am glad you got it working but if the space matters than why does this work
CREATE TABLE emails (
id int(11) NOT NULL auto_increment,
section varchar(200),
message text NOT NULL,
PRIMARY KEY (id)
);
notice the commas, no space before them.