MySQL Create Table Error Syntax

Question

Hello i am having an issue when trying to create a table inside of my database webhostc_MyRadContactForm

When i try to execute the statement below in phpMyAdmin i get this error

CREATE TABLE Contacts (
-> ContactID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> ContactName VARCHAR(100),
-> ContactEmail VARCHAR(100),
-> ContactLeastFavoriteColor VARCHAR(10)
-> ContactDateCreated DATETIME
-> );

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-> ContactID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, -> ContactName VARCHA' at line 2

Also phpMyAdmin flags these lines:

My server is running: 10.0.22-MariaDB

angelcool.net · Accepted Answer · 2015-11-06 01:23:11Z

1

You are missing a comma just after ContactLeastFavoriteColor VARCHAR(10) and those arrows, ->, are not supposed to be there. The following is the correct syntax for creating your table:

CREATE TABLE Contacts (
  ContactID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  ContactName VARCHAR(100),
  ContactEmail VARCHAR(100),
  ContactLeastFavoriteColor VARCHAR(10),
  ContactDateCreated DATETIME
);

Good luck!!

edited Nov 6, 2015 at 1:23

answered Nov 6, 2015 at 1:06

angelcool.net

2,5761 gold badge26 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Barmar Over a year ago

The error message complains about the -> symbols, not the missing comma.

angelcool.net Over a year ago

@Barmar I second that, that's why I didn't add them to my answer.

Barmar Over a year ago

I noticed that, but you could have mentioned that this was the problem.

Barmar · Accepted Answer · 2015-11-06 01:08:03Z

1

There are two problems:

Those -> symbols aren't part of SQL syntax. They're the prompts that the MySQL monitor prints when you enter a multi-line query. You can't copy them into PhpMyAdmin.
You're missing a comma at the end of the ContactLeastFavoriteColor line.

answered Nov 6, 2015 at 1:08

Barmar

789k57 gold badges555 silver badges669 bronze badges

Collectives™ on Stack Overflow

MySQL Create Table Error Syntax

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related