MySQL SQL Syntx Error 1064 -
i want create table this,
create table playerinfo ( uuid varchar(255) not null primary key, nickname varchar(255) not null, firstplayed varchar(255) not null, lastonline varchar(255) not null, playtime bigint not null default 0, unit int not null default 0, kill int not null default 0, death int not null default 0 );
but couldn't create table syntax error 1064, in 'kill int not null default 0, death int not null default 0', can't find error in there. simillar command 'unit int not null default 0' doesn't cause error, should do?
kill reserved sql keyword. you'll have name column of table else.
a list of reserved keywords can found here: https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Comments
Post a Comment