#1064 - You have an error in your SQL syntax; Creating table no obvious errors (mysql)

Asked Jun 06 '17 at 20:28

Active Jun 06 '17 at 20:32

Viewed 23 times

I'm having some issues with MYSQL, and cannot find any solution. I'm new to SQL and so I'm not sure this is right, but someone more experienced said this should work fine?

I'm using PHP version: 7.0.15-0ubuntu0.16.04.4 Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $

CREATE TABLE playerdata('SteamID' VARCHAR NOT NULL, 'Money' INT, PRIMARY KEY('id'));

Thanks. Conn

edited Jun 06 '17 at 20:32

asked Jun 06 '17 at 20:28

Conn B-M

2

MySQL != SQL-Server – Barmar Jun 06 '17 at 20:30
2

Well....you are trying to set your primary key to a column that doesn't exist. – Sean Lange Jun 06 '17 at 20:30
Even so, CREATE TABLE playerdata('id' INT, 'SteamID' VARCHAR NOT NULL, 'Money' INT, PRIMARY KEY('id')); still fires the same error – Conn B-M Jun 06 '17 at 20:31
What kind of SQL are we talking about? Hint: it's *either* MySQL *or* SQL Server. – Christian Specht Jun 06 '17 at 20:31
MySQL, should have put originally. – Conn B-M Jun 06 '17 at 20:33

#1064 - You have an error in your SQL syntax; Creating table no obvious errors (mysql)

0 Answers0