php mysql bigint,PHP mysql bigint问题

I have two tables with bigint:

table1

id bigint(20) PK autoincrement

name varchar(40),

text

table2

id bigint(20) PK autoincrement

created datetime

text_field

id_table1_ref bigint(20)

After inserting data into table1 and trying to insert table1.id into table2.id_table1_ref,

the number is different, i.e.:

Number 1552545662588 from table1.t1 becomes 1552545662, or even worse, a negative number.

I know this is an issue with settings, but I can't figure out how to manage this.

I tried to set up signed/unasigned values for the fields, but it doesn't work.

This is happening on my UNIX local computer, on the server all is working ok, at least for now.

Any help would be much appreciated.

解决方案

You need to CONVERT it to a string in SQL before getting it into PHP. In PHP, you can use GMP to handle the number.