dimanche 1 mars 2015

Mysql returning incorrect bigint result by one, very strange error

I really don't know what is going on here. I have a database table that looks like this:


enter image description here


With this data:


enter image description here


When I run this query SELECT * FROM game WHERE id = 4 in phpmyadmin I get back this result as expected:


enter image description here


But when I make this query on it through a rest api (where gameId = 4)



var query = connection.query("SELECT * FROM game WHERE id = ? ",[game.gameId],function(err,rows){


I get this result


enter image description here


Where adminId for some reason has been subtracted by one. I really haven't a clue what is going on. I have tried dropping the table and setting it back up, has anyone experienced this before? Or know what is wrong? It's pretty frustrating! Thanks


Aucun commentaire:

Enregistrer un commentaire