Unknown syntax error in MySQL statement

Question

I am using below CREATE TABLE statement

CREATE TABLE IF NOT EXISTS users (
`uuid` varchar(36) NOT NULL,
`json` varchar(MAX) NOT NULL,
PRIMARY KEY (`uuid`)
);

However I keep getting this error.

ERROR 1064 (42000): 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) NOT NULL, PRIMARY KEY (uuid) )' at line 3

Makes no sense to me.

max is a reserved word. how about theMax...no how about a number — Drew
– Drew, Commented Jun 7, 2015 at 0:10
that worked, however is converting the row json from varchar to text. — ThatGuy343
– ThatGuy343, Commented Jun 7, 2015 at 0:13
sorry i was messing with 60000 once on a dif server to check max but that high i would Text for purposes mainly FULLTEXT search. typically it is like 100 or 255 (<1001) — Drew
– Drew, Commented Jun 7, 2015 at 0:56

Community · Accepted Answer · 2017-05-23 11:54:40Z

3

MAX is not suported for this use, it is reserved for the MAX function. Use the equivalent number instead, check this out: Equivalent of varchar(max) in MySQL?

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Jun 7, 2015 at 0:12

jotadepicas

2,5113 gold badges29 silver badges49 bronze badges

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

Comments

HaveNoDisplayName · Accepted Answer · 2015-06-07 00:15:05Z

1

This will work for you. MAX is reserved keyword. Specify exact number of varchar instead of max. However, varchar(MAX) will work in SQL SERVER 2005+.

CREATE TABLE IF NOT EXISTS users (
  uuid varchar(36) NOT NULL,
  json varchar(21808) NOT NULL,
  PRIMARY KEY (uuid)
);

FIDDLE

answered Jun 7, 2015 at 0:15

HaveNoDisplayName

8,537106 gold badges41 silver badges50 bronze badges

Comments

Ashish Bhavsar · Accepted Answer · 2016-11-10 09:06:23Z

1

MAX() is a function in MySql,So if you want to declare the size to the max.please refer the below example.

CREATE TABLE IF NOT EXISTS users (
`uuid` varchar(36) NOT NULL,
`json` varchar(65535) NOT NULL,
PRIMARY KEY (`uuid`)
);

and if you calculate that 21845*3 = 65535, which wouldn't have worked anyway.
Whereas 21844*3 = 65532, which does work.

mysql> CREATE TABLE foo ( v VARCHAR(21844) ) CHARSET=utf8;
Query OK, 0 rows affected (0.32 sec)

answered Nov 10, 2016 at 9:06

Ashish Bhavsar

2364 silver badges18 bronze badges

Collectives™ on Stack Overflow

Unknown syntax error in MySQL statement

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