Mysql : syntax error after update mysql

Question

please advice whats the error in this statement, this statement was working fine before the last update for mysql

CREATE TABLE `users` (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
                      username VARCHAR(50),
                      password VARCHAR(500) NOT NULL,
                      full_name VARCHAR(50),
                      is_author BOOLEAN DEFAULT  ,
                      UNIQUE INDEX (username));

thanks in advance

Please include waht is the exactt error your getting

Petter Friberg
– Petter Friberg

2015-10-24 11:31:11 +00:00
Commented Oct 24, 2015 at 11:31 — Petter Friberg
– Petter Friberg, Commented Oct 24, 2015 at 11:31

Lukasz Szozda · Accepted Answer · 2015-10-24 10:54:32Z

3

Remove DEFAULT or set to value:

CREATE TABLE `users` (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
                      username VARCHAR(50),
                      `password` VARCHAR(500) NOT NULL,
                      full_name VARCHAR(50),
                      is_author BOOLEAN,  -- here or DEFAULT true/false
                      UNIQUE INDEX (username));

Also qoute password because it is keyword.

SqlFiddleDemo

answered Oct 24, 2015 at 10:54

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

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

Collectives™ on Stack Overflow

Mysql : syntax error after update mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related