MySQL使用有感小记
- WBOYOriginal
- 2016-06-07 16:53:07912browse
ERROR 1406 (22001): Data too long for column 解决方法导入数据的时候，MySQL报错:Data too long for column解决办法:在my.ini
ERROR 1406 (22001): Data too long for column 解决方法
导入数据的时候，，MySQL报错: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
注释掉，然后重启MySQLl就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：关于Oracle 10g scott用户解锁的方法两则Next article：Ubuntu下修改MySQL默认数据库编码