Skip to content

Instantly share code, notes, and snippets.

@samlambert
Created March 26, 2013 09:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samlambert/5244121 to your computer and use it in GitHub Desktop.
Save samlambert/5244121 to your computer and use it in GitHub Desktop.
MySQL5.5 Data truncated (for blog post)
mysql> INSERT INTO strings (words) VALUE ('This string is too long');
Query OK, 1 row affected, 1 warning (0.05 sec)
mysql> show warnings;
+---------+------+--------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------+
| Warning | 1265 | Data truncated for column 'words' at row 1 |
+---------+------+--------------------------------------------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment