Home >Database >Mysql Tutorial >ERROR 1406 : Data too long for column 解决办法
ERROR 1406 : Data too long for column 解决办法
- WBOYOriginal
- 2016-06-07 18:03:253744browse
导入数据的时候，mysql报错 ERROR 1406 : Data too long for column Data too long for column
解决办法:在my.ini里找到
sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_Create_USER,NO_ENGINE_SUBSTITUTION”
把其中的STRICT_TRANS_TABLES,去掉,
或者把sql-mode=STRICT_TRANS_TABLES,NO_AUTO_Create_USER,NO_ENGINE_SUBSTITUTION
注释掉，然后重启mysql就ok了
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：不使用MySQL数据库的五个给力理由解析Next article：mysql数据库备份及恢复命令 mysqldump,source的用法