[SOLVED] Table

[june_c21]

hi, i need help to solve this problem. Please help. thanks

 

SQL query:

 

CREATE TABLE type_of_title(

 

type_of_title INT CHECK (

type_of_title <6

) PRIMARY KEY ,

t_o_t_desc TEXT NOT NULL

);

 

 

 

MySQL said:  

 

#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 'PRIMARY KEY,

    t_o_t_desc TEXT NOT NULL

    )' at line 2

 

 

[fenway]

That's not valid syntax... what's CHECK?  And what's the PK?