mysql5 sql-mode 引起的错误解决办法
- WBOYOriginal
- 2016-06-07 17:52:301261browse
mysql5.0新加的sql-mode有关系,因为前一阵子刚刚看过手册.果然,作了如下更改后就不再提示了.
修改 my.ini 文件.
# Set the SQL mode to strict
| 代码如下 | 复制代码 |
| sql-mode=”STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” | |
改为:
# Set the SQL mode to strict
| 代码如下 | 复制代码 |
| sql-mode=”NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION” | |
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数据库密码