MkyTaP - 開發筆記
主要工具: Linux, Python, SQL
Friday, November 9, 2018
Error: ERROR 1406 (22001) at line 4950: Data too long for column 'xx' at row 1
因為舊DB導入新版本的mysql中所導致,執行下面設定就可以解決︰
SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Reference:
“Data too long for column” - why?
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment