MySQL

pip install mysqlclient  

settings.py

DATABASES = {

    'default': {

        'ENGINE': 'django.db.backends.mysql',

        'NAME': 'pus',

        'USER': 'root',

        'PASSWORD': 'root',

        'HOST': 'localhost',

        'PORT': '3306',

    }

}

python manage.py runserver

python manage.py makemigrations

python manage.py migrate 

MySQL Shell

\sql

\connect root@localhost:3306

 

Show All Database table:

show databases;

 

Create database:

create database [databasename];

 

Used database:

use [db name];

 

Show Table:

show tables;

 

Show Particular table data:

SELECT * FROM [table name];

 

Show All Important Database Commands:

http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm