Bug query

[MsBug]

When I run this in the bug database...

CREATE TABLE `dungeon_finder` (`id` INT(8) AUTO_INCREMENT PRIMARY KEY, `player_id` INT(255))


Error:
Error while executing query: near "AUTO_INCREMENT": syntax error

 

[Deleted member 92788]

same here help pls rep++

 

[Ninja]

Your SQL query has been executed successfully ( Query took 0.0959 sec )
CREATE  TABLE  `dungeon_finder` ( `id` INT( 8  )  AUTO_INCREMENT  PRIMARY  KEY ,
 `player_id` INT( 255  ) 
)

Works fine here

 

[MsBug]

Look...

 

[Zisly]

Sqlite?
try

CREATE TABLE `dungeon_finder` ( `id` INTEGER PRIMARY KEY AUTOINCREMENT ,
`player_id` INT( 255 )
)

or

CREATE TABLE `dungeon_finder` ( `id` INTEGER PRIMARY KEY ,
`player_id` INT( 255 )
)