“You have an error in your SQL syntax； check the manual that corresponds to your MySQL server versi

在使用django链接数据库的时候，报错如下

(base) D:\python\django_test>python manage.py migrateOperations to perform:Apply all migrations: accounts, admin, auth, contenttypes, sessionsRunning migrations:Traceback (most recent call last):File "D:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\utils.py", line 82, in _executereturn self.cursor.execute(sql)File "D:\ProgramData\Anaconda3\lib\site-packages\django\db\backends\mysql\base.py", line 73, in executereturn self.cursor.execute(query, args)File "D:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\cursors.py", line 206, in executeres = self._query(query)File "D:\ProgramData\Anaconda3\lib\site-packages\MySQLdb\cursors.py", line 319, in _querydb.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 /simple

或者 mysql升级