Error 1064 SQL in query [closed]

Question

Navigation

#1 by (2 votes)

0

I can not see the error of this statement

create table authority (
id int GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) 
primary key, name varchar(50));

mysql sql

asked by Eduardo 12.03.2018 в 11:41

source

1 answer

score 2 · Accepted Answer

2

the correct syntax in MySQL is:

create table authority (
    id int primary key AUTO_INCREMENT, 
    name varchar(50)
);

answered by 12.03.2018 / 12:02

source