Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > ERROR 1406 : Data too long for column 解决办法

ERROR 1406 : Data too long for column 解决办法

WBOY
Release： 2016-06-07 18:03:25
Original
3727 people have browsed it

导入数据的时候，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了
Related labels：
data long
source：php.cn
Previous article：不使用MySQL数据库的五个给力理由解析 Next article：mysql数据库备份及恢复命令 mysqldump,source的用法
Statement of this Website
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
Latest Articles by Author
Latest Issues
Compare Imagick, Adobe Photoshop and Windows - Detect resolution (pixels per centimeter or pixels per inch) This is not a question but an attempt to improve my understanding of how DPI is stored in ...
From 2024-04-06 16:01:27
0
1
397
Open calculation documents using window.open() and data: scheme I have a web page that runs in a browser that generates a calculated HTML document that I ...
From 2024-04-06 15:06:34
0
1
378
Align tooltip to relative parent I spent two days trying to solve this problem but I realized I couldn't do it alone. I'm t...
From 2024-04-06 13:16:59
0
2
394
How can I match the text width to the width of a dynamically sized image/title? See this codepen: https://codepen.io/allen-houng/pen/XGMjMr?editors=1100#0<div><i...
From 2024-04-06 10:04:43
0
2
386
PHP HTTP request ignores parameters Before I start asking questions, I should mention that I am re-learning PHP after a long t...
From 2024-04-05 10:54:48
0
1
3536
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template