[Resolved] help creating table in mySQL

[bhola]

i've never done this before and i'm working with an existing mySQL dB. i need to add a new table to store data from an HTML form. i keep on getting the following error:

SQL-query :  

CREATE TABLE `wbt_courseevals` (

`cid` INT( 11 ) AUTO_INCREMENT ,
`date` DATETIME,
`login` VARCHAR,
`course_title` VARCHAR,
`content1` VARCHAR( 17 ) ,
`content2` VARCHAR( 17 ) ,
`content3` VARCHAR( 17 ) ,
`content4` VARCHAR( 17 ) ,
`content_comments` VARCHAR NOT NULL ,
`interface1` VARCHAR( 17 ) ,
`interface2` VARCHAR( 17 ) ,
`interface3` VARCHAR( 17 ) ,
`interface_comments` VARCHAR NOT NULL ,
`overall1` VARCHAR( 17 ) ,
`overall_comments` VARCHAR NOT NULL ,
FULLTEXT (
`date` ,
`login` ,
`course_title` ,
`content1` ,
`content2` ,
`content3` ,
`content4` ,
`content_comments` ,
`interface1` ,
`interface2` ,
`interface3` ,
`interface_comments` ,
`overall1` ,
`overall_comments` 
)
) TYPE = MYISAM 

MySQL said: 


You have an error in your SQL syntax near ' `course_title` VARCHAR, `content1` VARCHAR(17), `content2` VARCHAR(17), `conten' at line 1

i'm readint the mySQL documentation but could use some help in the meantime. any ideas what i'm doing wrong?
thanks.

[bastien]

the answer is in front of you...

login VARCHAR,
course_title VARCHAR,
content1 VARCHAR( 17 ) ,
content2 VARCHAR( 17 ) ,
content3 VARCHAR( 17 )

what is with the bottom two fields that is not in the top ones...the length of the data field

ie (17)
so change the above to this:

login VARCHAR( 17 ) ,
course_title VARCHAR( 17 ) ,
content1 VARCHAR( 17 ) ,
content2 VARCHAR( 17 ) ,
content3 VARCHAR( 17 )

and bob's your uncle

😃

[bhola]

bob WAS my uncle cause i used to have length of data fields set for both login(12) and course_title(255) but i got this error:

SQL-query :  

CREATE TABLE `wbt_courseevals` (

`cid` INT( 11 ) AUTO_INCREMENT ,
`date` DATETIME,
`login` VARCHAR( 12 ) ,
`course_title` VARCHAR( 255 ) ,
`content1` VARCHAR( 17 ) ,
`content2` VARCHAR( 17 ) ,
`content3` VARCHAR( 17 ) ,
`content4` VARCHAR( 17 ) ,
`content_comments` VARCHAR NOT NULL ,
`interface1` VARCHAR( 17 ) ,
`interface2` VARCHAR( 17 ) ,
`interface3` VARCHAR( 17 ) ,
`interface_comments` VARCHAR NOT NULL ,
`overall1` VARCHAR( 17 ) ,
`overall_comments` VARCHAR NOT NULL ,
FULLTEXT (
`date` ,
`login` ,
`course_title` ,
`content1` ,
`content2` ,
`content3` ,
`content4` ,
`content_comments` ,
`interface1` ,
`interface2` ,
`interface3` ,
`interface_comments` ,
`overall1` ,
`overall_comments` 
)
) TYPE = MYISAM 

MySQL said: 


You have an error in your SQL syntax near 'NOT NULL, `interface1` VARCHAR(17), `interface2` VARCHAR(17), `interface3` VARCH' at line 1

😕

[bastien]

stop letting uncle bob drink...he keeps missing the point

CREATE TABLE wbt_courseevals (

cid INT( 11 ) AUTO_INCREMENT ,
date DATETIME,
login VARCHAR( 12 ) ,
course_title VARCHAR( 255 ) ,
content1 VARCHAR( 17 ) ,
content2 VARCHAR( 17 ) ,
content3 VARCHAR( 17 ) ,
content4 VARCHAR( 17 ) ,
content_comments VARCHAR NOT NULL //length????,
interface1 VARCHAR( 17 ) ,
interface2 VARCHAR( 17 ) ,
interface3 VARCHAR( 17 ) ,
interface_comments VARCHAR NOT NULL ,
overall1 VARCHAR( 17 ) ,
overall_comments VARCHAR NOT NULL ,
FULLTEXT (
date ,
login ,
course_title ,
content1 ,
content2 ,
content3 ,
content4 ,
content_comments ,
interface1 ,
interface2 ,
interface3 ,
interface_comments ,
overall1 ,
overall_comments
)
) TYPE = MYISAM

[bhola]

sweet! 😃 after a few more errors i was able to create my first table... and a rhyme to go with it 😉 thanks for all the help bastien.