Hi
i have no real knowledge of databases but am trying to make a simple table but keep getting a syntax error with the following code:
mysql> create table enterprise_programming(Submitter VARCHAR(20) , URL
VARCHAR(20) , Date submitted VARCHAR(12) , Version INT , Task-ref-no IN
T , Page number INT , Status VARCHAR(10) , Approval/Rejection Date VARC
HAR(12) , Chief-Developer Ref INT);
the not so helpfull error message i get is:
You have an error in your SQL syntax near 'submitted VARCHAR(12) , Version INT , Task-ref-no INT , Page number INT , Status' at line 1
If anyone has any ideas they would be appreciated.
many thanks
i have no real knowledge of databases but am trying to make a simple table but keep getting a syntax error with the following code:
mysql> create table enterprise_programming(Submitter VARCHAR(20) , URL
VARCHAR(20) , Date submitted VARCHAR(12) , Version INT , Task-ref-no IN
T , Page number INT , Status VARCHAR(10) , Approval/Rejection Date VARC
HAR(12) , Chief-Developer Ref INT);
the not so helpfull error message i get is:
You have an error in your SQL syntax near 'submitted VARCHAR(12) , Version INT , Task-ref-no INT , Page number INT , Status' at line 1
If anyone has any ideas they would be appreciated.
many thanks