import pymysql
#1.鏈接mysql
conn = pymysql.connect(host='127.0.0.1',port = 2206,user = 'root',passwd = 'root123',charset = 'utf8',db = 'unicom')
cursor = conn.cursor(cursor = pymysql.cursors.DictCursor)
#2.發(fā)送指令
cursor.execute('insert into admin(username,password,mobile)values('yulin','123456','13888888888')')
conn.commit()
#3.關閉
cursor.close()
conn.close()

pip install mysqlclient

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'pymysql',#數(shù)據(jù)庫名字
        'USER':'root',#數(shù)據(jù)庫user
        'PASSWORD':'123456',#數(shù)據(jù)庫密碼
        'HOST':'127.0.0.1',#本地服務器可以是遠程數(shù)據(jù)庫
        'PORT':'3306'#數(shù)據(jù)庫端口號
    }
}

from django.db import models
# Create your models here.
class UserInfo(models.Model):
    name = models.CharField(max_length=10)
    password = models.CharField(max_length = 40)
    age = models.IntegerField(max_length = 3)

python manage.py makemigrations
python manage.py migrate

name = models.CharField(null = True,blank = True)

name = models.CharField(null = True,blank = True)