node.js - Mysql returning incorrect bigint result by one, very strange error -

i don't know going on here. have database table looks this:

with data:

when run query select * game id = 4 in phpmyadmin result expected:

but when make query on through rest api (where gameid = 4)

var query = connection.query("select * game id = ? ",[game.gameid],function(err,rows){  

i result

where adminid reason has been subtracted one. haven't clue going on. have tried dropping table , setting up, has experienced before? or know wrong? it's pretty frustrating! thanks

the maximum integer javascript can safely represent number.max_safe_integer, 2^53 - 1. value greater that, causing bits lost.

node-mysql has supportbignumbers , bignumberstrings options parse bigints strings.

var connection = mysql.createconnection({supportbignumbers: true, bignumberstrings: true});