The value 3172978990 is greater than 2147483647 – the maximum value for INT
– hence the error. MySQL integer types and their ranges are listed here.
Also note that the (10)
in INT(10)
does not define the “size” of an integer. It specifies the display width of the column. This information is advisory only.
To fix the error, change your datatype to VARCHAR
. Phone and Fax numbers should be stored as strings. See this discussion.
Related Posts:
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Unknown column in ‘field list’ error on MySQL Update query
- Unknown column in ‘field list’ error on MySQL Update query
- MySQL – Operand should contain 1 column(s)
- MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL create table if not exists and insert record only if table was created
- How do I use properly CASE..WHEN in MySQL
- How can I do a FULL OUTER JOIN in MySQL?
- MySQL query String contains
- What’s the difference between VARCHAR and CHAR?
- Case statement in MySQL
- How to declare a variable in MySQL?
- MySQL Cannot Add Foreign Key Constraint
- How to split the name string in mysql?
- How do I import an SQL file using the command line in MySQL?
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- mysql Foreign key constraint is incorrectly formed error
- MySQL: Invalid use of group function
- How can I return pivot table output in MySQL?
- Compare dates in MySQL
- MySQL “WITH” clause
- MySQL Multiple Joins in one query?
- Error Code: 2013. Lost connection to MySQL server during query
- MySQL syntax for Join Update
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- how to drop partition without dropping data in MySQL?
- MySQL combine two columns into one column
- Simple way to calculate median with MySQL
- Error 1046 No database Selected, how to resolve?
- Remove duplicate rows in MySQL
- How to SUM and SUBTRACT using SQL?
- Cast from VARCHAR to INT – MySQL
- SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
- How do you force mysql LIKE to be case sensitive?
- MySQL – UPDATE multiple rows with different values in one query
- How to create a MySQL hierarchical recursive query?
- ERROR 1148: The used command is not allowed with this MySQL version
- Insert into a MySQL table or update if exists
- How to round down to nearest integer in MySQL?
- MySQL starts with searching issue
- Query to convert from datetime to date mysql
- Is it possible to GROUP BY multiple columns using MySQL?
- MySQL error: key specification without a key length
- Best way to test if a row exists in a MySQL table
- Check if MySQL table exists without using “select from” syntax?
- MySQL equivalent of DECODE function in Oracle
- mysql update column with value from another table
- The used SELECT statements have a different number of columns
- How to delete from multiple tables in MySQL?
- MySQL: Can’t create table (errno: 150)
- Join vs. sub-query
- Alternative to except in MySQL
- Equivalent of explode() to work with strings in MySQL
- How to do a batch insert in MySQL
- ROW_NUMBER() in MySQ
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- Solutions for INSERT OR UPDATE on SQL Server
- MySQL OPTIMIZE all tables?
- MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
- MySQL – Get row number on select
- MySQL error: Unknown column in ‘where clause’
- How to truncate the text returned for a column in a MySQL query
- Using union and order by clause in mysql
- MySQL LIKE IN()?
- What is the difference between UNION and UNION ALL?
- Selecting COUNT(*) with DISTINCT
- ORA-00904: invalid identifier
- The wait operation timed out. ASP
- Cannot delete or update a parent row: a foreign key constraint fails
- How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
- Inserting data into a temporary table
- How to Select Top 100 rows in Oracle?
- Oracle Apex column link from LOV values
- When to use “ON UPDATE CASCADE”
- Insert text with single quotes in PostgreSQL
- SQL Server IF NOT EXISTS Usage?
- How to insert date values into table
- How to join two tables by multiple columns in SQL?
- Generating a random & unique 8 character string using MySQL
- how to remove time from datetime
- what is the difference between triggers, assertions and checks (in database)
- Cannot create an instance of OLE DB provider Microsoft.Jet.OLEDB.4.0 for linked server null
- ORDER BY items must appear in the select list if SELECT DISTINCT is specified
- Foreign key references invalid table
- Varchar invalid for Sum operator
- SQL: How to properly check if a record exists
- SQL select of users by metadata
- Getting wrong relationship value in $args in wp_Query?
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- WordPress database error: You have an error in your SQL syntax
- SQL to migrate post types to taxonomy
- Why line returns are not reapply after doing esc_sql?
- Search results sort order failing: set by date only
- An SQL query to find orphaned image attachments and their meta
- Bulk Change WordPress category Slug
- Get all the related data from WordPress DB
- why you don’t Implement PDO for access every thing to database
- Possible SQL injection. How to locate and fix?