Error Code: 1406. Data too long for column – MySQL

by

MySQL will truncate any insert value that exceeds the specified column width.

to make this without error try switch your SQL mode to not use STRICT.

Mysql reference manual

EDIT:

To change the mode

This can be done in two ways:

  1. Open your my.ini (Windows) or my.cnf (Unix) file within the MySQL installation directory, and look for the text “sql-mode”.

Find:

Code:

# Set the SQL mode to strict 
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Replace with:

Code:

# Set the SQL mode to strict 
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Or

  1. You can run an SQL query within your database management tool, such as phpMyAdmin:

Code:

SET @@global.sql_mode="";

More Related Contents:

  1. Complex Count in MySQL
  2. Remove duplicate rows in MySQL
  3. Using column alias in WHERE clause of MySQL query produces an error
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  6. Cannot delete or update a parent row: a foreign key constraint fails
  7. Using union and order by clause in mysql
  8. Using an Alias in SQL Calculations
  9. Can a table field contain a hyphen?
  10. How do I select an entire row which has the largest ID in the table?
  11. Determine Rank based on Multiple Columns in MySQL
  12. Checking multiple columns for one value
  13. What is better in MYSQL count(*) or count(1)?
  14. Delete query not working in mysql
  15. Best practices for SQL varchar column length [closed]
  16. ALTER TABLE to add a composite primary key
  17. How to get the count of each distinct value in a column? [duplicate]
  18. How to enable INNODB in mysql
  19. Bash script to insert values in MySQL
  20. What are differences between INSERT and UPDATE in MySQL?
  21. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  22. MySQL GROUP BY DateTime +/- 3 seconds
  23. How do I lag columns in MySQL?
  24. How to get multiple records against one record based on relation?
  25. SQL query to check if a name begins and ends with a vowel
  26. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  27. How to use a user variables in MySQL LIKE clause?
  28. MySql – How get value in previous row and value in next row? [duplicate]
  29. Updating table in trigger after update on the same table
  30. Select from same table as an Insert or Update

Leave a Comment