在使用django链接数据库的时候,报错如下
(base) D:\python\django_test>python manage.py migrate
Operations to perform:
Apply all migrations: accounts, admin, auth, contenttypes, sessions
Running migrations:
Traceback (most recent call last):
File "D:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\utils.py", line 82, in _execute
return self.cursor.execute(sql)
File "D:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\mysql\base.py", line 73, in execute
return self.cursor.execute(query, args)
File "D:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\cursors.py", line 206, in execute
res = self._query(query)
File "D:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\cursors.py", line 319, in _query
db.query(q)
File "D:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\connections.py", line 259, in query
_mysql.connection.query(self, query)
MySQLdb._exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(6) NOT NULL)' at line 1")
原因
Django2.1不再支持MySQL5.5,必须5.6版本以上
我的版本为Django 3.1.6
解决
django降级
pip install Django==2.0.0 -i https://pypi.douban.com/simple
或者 mysql升级