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

最新推荐文章于 2025-05-22 08:08:34 发布

Gabriel_wei

最新推荐文章于 2025-05-22 08:08:34 发布

阅读量450

点赞数 1

CC 4.0 BY-SA版权

分类专栏： Django

本文链接：https://blog.csdn.net/Gabriel_wei/article/details/113836372

Django 专栏收录该内容

2 篇文章

订阅专栏

在尝试使用Django3.1.6进行数据库迁移时遇到错误，错误信息提示MySQL语法错误，可能由于Django2.1以后不再支持MySQL5.5，而我的MySQL版本过低。解决方法包括将Django版本降级到2.0.0或升级MySQL到5.6及以上版本。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在使用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")