问题多多,纯粹为记录,今天晚上纯粹就是找BUG了,已经解决3个问题了!
这个问题第一次遇到,在此记录下,下次有可能还要用到!
在网上找了下,第一种方法就解决了!再记录下,别的方法!
解决方法一: 打开my.ini,查找 sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" 修改为 sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" 然后重启MYSQL
解决方法二:
MySQL 5 uses a strict mode which needs to be disabled. In Windows, Goto Start-->Programs-->MySQL->MySQL Instance Config Wizard. Follow through the Reconfigure Instance option-->Detailed Configuration-->Continue Next a few screens. At the bottom under Enable TCP/IP option there is 'Enable Strict Mode'. Deslect this option (no tick). Save changes and MySQL will restart.
问题解决了吧!其实也就是这么简单!有互联网真方便!