Long integer is transformed when inserted in shorter column, not truncated. Why? What is the formula?

by

http://dev.mysql.com/doc/refman/5.0/en/integer-types.html

The integer overflow will set the max allowed number in the DB as 

2147483647

So you need bigint datatype for storing bigger integer

More Related Contents:

  1. php+mysql Fatal error: Call to undefined function mysql_connect()
  2. Using PHP data in MySQL [closed]
  3. Checking the availability of rooms
  4. How to sort user data by id
  5. Select those record only from table 1 where city exist against state id in table 2 in PHP
  6. PHP PDO prepared statements
  7. Example of how to use bind_result vs get_result
  8. mysqli::query(): Couldn’t fetch mysqli
  9. select count(*) from table of mysql in php
  10. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  11. Loading .sql files from within PHP
  12. Incorrect Integer (2147483647) is inserted into MySQL?
  13. I need my PHP page to show my BLOB image from mysql database
  14. jQuery UI Sortable, then write order into a database
  15. Converting an integer to a string in PHP
  16. Cannot connect to MySQL 4.1+ using old authentication
  17. Delete multiple rows by selecting checkboxes using PHP
  18. Object of class DateTime could not be converted to string
  19. PHP Commands Out of Sync error
  20. PHP MYSQL UPDATE if Exist or INSERT if not?
  21. how to check and set max_allowed_packet mysql variable [duplicate]
  22. mysql_real_escape_string VS addslashes
  23. PHP: multiple SQL queries in one mysql_query statement
  24. MySql Error: 1364 Field ‘display_name’ doesn’t have default value
  25. Understanding pdo mysql transactions
  26. “No such file or directory” or “No such host is known” when running migrations
  27. How to join two tables with ssp.class.php
  28. How to convert IPv6 from binary for storage in MySQL
  29. Eloquent many-to-many-to-many – how to load distant relation easily
  30. Convert a big integer to a full string in PHP

Leave a Comment