Zymic Webmaster Forums > Sql Syntax Error

Zymic Webmaster Forums > Zymic Free Web Hosting > Databases & MySQL

cenarius

Jul 23 2009, 08:03 PM

I can't create a table...I always get syntax error. WHat is wrong?

Btw, how to run a php script instead of sql query?

I don't want to create table with UI.

CREATE TABLE Players
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
Player varchar(15),
Points int(4),
)

Efusjon

Jul 26 2009, 08:04 AM

Can you cut & past the error?

Jul 26 2009, 11:13 AM

This was sorted on live chat, the issue was the trailing ',' after 'int(4)':

Corrected query:

SQL

CREATE TABLE Players
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
Player varchar(15),
Points int(4)
)

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.