sql insert wrong value in database

Question

here is my request,

INSERT INTO user(name,user_id,url,email,created,updated,phone,organisationID,role) VALUES ('Bastien Frey', '2196898165', 'https://cubber.zendesk.com/api/v2/users/2196898165.json', '[email protected]', '2016-01-19T16:21:07Z', '2016-01-19T16:21:07Z', '', '30567951','end-user'),('mathilde zimmer', '2297486669', 'https://cubber.zendesk.com/api/v2/users/2297486669.json', '[email protected]', '2016-01-26T12:04:20Z', '2016-01-26T12:04:20Z', '', '36094152','end-user')

But it insert the wrong user_id in my table, do you think this is a code or a database problem ? In my database i have something like that:

Shadow · Accepted Answer · 2016-06-29 09:17:07Z

1

You have defined user_id column as signed integer and you attempted to insert a value greater than the upper limit of this data type (2147483647). MySQL truncated the value to the maximum allowed by the data type (you do not have strict sql mode enabled, otherwise you would have received an error). Check out the warnings with show warnings command.

Change the field's data type to unsigned int or to (unsigned) bigint.

answered Jun 29, 2016 at 9:17

Shadow

34.5k10 gold badges67 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql insert wrong value in database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related