Incorrect syntax with VARCHAR(MAX) when creating table

Question

I'm creating an SQL table using PHP but I'm getting an error and I don't know why. This is the code

CREATE TABLE posts
(
    P_Id int NOT NULL AUTO_INCREMENT,
    Title VARCHAR(200),
    Post VARCHAR(MAX),
    PRIMARY KEY (P_Id)
)

The error that I'm getting is

Error creating table: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX), PRIMARY KEY (P_Id)' at line 5

I think you need to specify a value there (eg. VARCHAR(255)). — disatisfieddinosaur
– disatisfieddinosaur, Commented Aug 11, 2013 at 23:57
@AlexJimenez: Mr. Jimenez, if any of these answers helped you, please see to it that you accept the one that solved your issue. Thank you. — Noob Saibot
– Noob Saibot, Commented Aug 12, 2013 at 0:45
Varchar(MAX) is a SQL Server specific extension. You'll have to put a number in there... — Curt
– Curt, Commented Aug 12, 2013 at 4:25

David MacCrimmon · Accepted Answer · 2013-08-12 00:03:03Z

2

VARCHAR(MAX) is not supported in MySql, I think you need to specify a figure in there. I think 64k is the max.

VARCHAR(65535)

answered Aug 12, 2013 at 0:03

David MacCrimmon

9661 gold badge6 silver badges19 bronze badges

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

Comments

Ed Heal · Accepted Answer · 2013-08-11 23:59:27Z

0

CREATE TABLE posts
(_Id int NOT NULL AUTO_INCREMENT,
Title VARCHAR(200),
Post VARCHAR(MAX),
PRIMARY KEY (P_Id))

What is MAX? Got too many commas! Why are you using PHP to initialize a database?

answered Aug 11, 2013 at 23:59

Ed Heal

60.3k18 gold badges91 silver badges137 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:49:25Z

0

From what I can tell you can't use (MAX) for VARCHAR in mySQL.

See:

I think you want:

...
Post VARCHAR(65535),
...

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Aug 12, 2013 at 0:04

chucknelson

2,3363 gold badges24 silver badges35 bronze badges

Collectives™ on Stack Overflow

Incorrect syntax with VARCHAR(MAX) when creating table

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related