django中使用mysql数据库

1.需要在setting文件中修改数据库配置

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mydatabase',
        'USER': 'myuser',
        'PASSWORD': 'mypassword',
        'HOST': '127.0.0.1',
        'PORT': '3306',
    }
# 'default': {
#         'ENGINE': 'django.db.backends.sqlite3',
#         'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
#     }
}

2.需要在setting文件中注册models所在app

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'app01.apps.App01Config',#注册models所在app
]

3.在models所在app下的__init__.py文件中导入pymysql

import pymysql
pymysql.install_as_MySQLdb()

4.在models.py中创建模型

from django.db import models

# Create your models here.
class Classmethod(models.Model):
    name = models.CharField('教室名称', max_length=64)

class Student(models.Model):
    name = models.CharField('学生姓名', max_length=64)
    email = models.CharField('学生邮箱', max_length=64)
    classes = models.ForeignKey('Classmethod',on_delete=models.CASCADE)

class Teacher(models.Model):
    name = models.CharField('教师姓名', max_length=64)
    email = models.CharField('教师邮箱', max_length=64)
    classes = models.ManyToManyField('Classmethod')

class User(models.Model):
    name = models.CharField('用户姓名', max_length=64)
    pwd = models.CharField('用户密码', max_length=64)