I really don't know what is going on here. I have a database table that looks like this:
![enter image description here](https://i.stack.imgur.com/MaPWP.png)
With this data:
![enter image description here](https://i.stack.imgur.com/ZJ7Bl.png)
When I run this query SELECT * FROM game WHERE id = 4
in phpmyadmin I get back this result as expected:
![enter image description here](https://i.stack.imgur.com/AnAZb.png)
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](https://i.stack.imgur.com/Blu7A.png)
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
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…