Incorrect Integer (2147483647) is inserted into MySQL?

by

2147483647 is the largest int value for mysql. Just change the type from int to bigint.

More Related Contents:

  1. Using PHP read word in textarea line by line and insert to mySQL
  2. How to insert multiple rows from array using CodeIgniter framework?
  3. PHP mysql insert date format
  4. Escaping single quote in PHP when inserting into MySQL [duplicate]
  5. PHP/MySQL Insert null values
  6. MySQL – ignore insert error: duplicate entry
  7. Object of class DateTime could not be converted to string
  8. php run once and insert twice in mysql database
  9. PHP mySQL – Insert new record into table with auto-increment on primary key
  10. Replacing \r\n with PHP
  11. php+mysql Fatal error: Call to undefined function mysql_connect()
  12. Using PHP data in MySQL [closed]
  13. drop down menu using php and mysql [closed]
  14. php code for multiple search box after connecting to mysql [closed]
  15. Checking the availability of rooms
  16. How to sort user data by id
  17. PHP PDO prepared statements
  18. Example of how to use bind_result vs get_result
  19. mysqli::query(): Couldn’t fetch mysqli
  20. PHP date() format when inserting into datetime in MySQL
  21. Special characters in PHP / MySQL
  22. Fetching single row, single column with PDO
  23. IP address storing in MySQL database using PHP [duplicate]
  24. “No such file or directory” or “No such host is known” when running migrations
  25. How to convert IPv6 from binary for storage in MySQL
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. How does {} affect a MySQL Query in PHP? [duplicate]
  28. When should I close a database connection in PHP?
  29. php connection pooling mysql [duplicate]
  30. Limit pagination page number

Leave a Comment