django连接mysql

在创建好app的基础之上

1settings.py / 修改如下

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'db4',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'OPTIONS':{
            'autocommit':True,
        }
    }
}

2init.py / 初始化

import pymysql
pymysql.install_as_MySQLdb()

3 app下model.py

#书目信息
class book_name(models.Model):
    id = models.AutoField(max_length=11, primary_key=True)
    name = models.CharField(max_length=30, verbose_name='书名')
    author = models.CharField(max_length=30, verbose_name='作者')
    time = models.CharField(max_length=30, verbose_name='时间')

    class Meta:
        verbose_name = "书名"
        verbose_name_plural = "作者"

    # 一大坑
    def __str__(self):
        return self.name
#标签云
class book_tags(models.Model):
    id = models.AutoField(max_length=11, primary_key=True)
    book_id = models.IntegerField(verbose_name='书目id')
    text = models.TextField(max_length=140,verbose_name="标签")

4 创建数据表

python manage.py makemigrations  (pycharm 运行 makemigrations)
python manage.py migrate    (pycharm 运行 migrate)

至此可