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, Aug 11 '13 at 23:57
possible duplicate of [Syntax error in SQL create table](http://stackoverflow.com/questions/12951921/syntax-error-in-sql-create-table) — Ken White, Aug 12 '13 at 00:05
@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, Aug 12 '13 at 00:45
`Varchar(MAX)` is a SQL Server specific extension. You'll have to put a number in there... — Curt, Aug 12 '13 at 04:25

score 2 · Answer 1 · answered Aug 12 '13 at 00:03

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 '13 at 00:03

David MacCrimmon

966
1
6
19

score 0 · Answer 2 · answered Aug 11 '13 at 23:59

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 '13 at 23:59

Ed Heal

57,599
16
82
120

score 0 · Answer 3 · edited May 23 '17 at 11:49

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 '17 at 11:49

Community

1
1

answered Aug 12 '13 at 00:04

chucknelson

2,290
3
24
30

Incorrect syntax with VARCHAR(MAX) when creating table

3 Answers3