models.py
from django.db import models

Create your models here.

class Book(models.Model):
# name = models.CharField(max_length=50)
# pub_date = models.DateField()
id = models.AutoField(primary_key=True)
name = models.CharField(max_length=100,null=False)
author = models.CharField(max_length=100,null=False)
price = models.FloatField(null=False,default=0)

class Publisher(models.Model):
name = models.CharField(max_length=100,null=False)
address = models.CharField(max_length=100,null=False)

DATABASES = {
‘default’: {
# ‘ENGINE’: ‘django.db.backends.sqlite3’,
# ‘NAME’: os.path.join(BASE_DIR, ‘db.sqlite3’),
# ‘ENGINE’: ‘C:\ProgramData\MySQL\MySQL Server 5.7\Data\db1’,
‘ENGINE’: ‘django.db.backends.mysql’,
‘NAME’: ‘orm_intro’,
# ‘NAME’: ‘db1’,
‘USER’: ‘root’,
‘PASSWORD’: ‘xxxxxx’,
‘HOST’: ‘localhost’,
‘PORT’: ‘3306’
}
}

cmd下
python manage.py makemigrations
python manage.py migrate
会生成如下表