Friday, 15 May 2015

mysql - SQL Syntax Error 42X01 -


I am trying to create a website with a backend database. However, when I'm trying to input the commands to make tables, I keep getting an error that I do not understand. I tried the commands on the second platform (mysql oracle online) and there is no problem how can I get this?

Command

  Make Team Team (Team_name INT (1), Team_Name VARCHAR (20), Area VARCHAR (10), League VARCHAR ( 30), Manager VARCHAR (20), Contract PK_Team Primary Key (Team_id)); Error code-1, SQL state 42X01: Syntax error: "(" at row 2, column) " 

error

14 Line1, column1

It should look like this: < Pre> Team Team Team (Team_ID INT, TeamName VARCHAR (20), Regions VARCHAR (10), League VARCHAR (30), Manager VARCHAR (20), Contract PK_Team Primary Key (Team_id));


No comments:

Post a Comment