how to use mysql database table in django code example

Example 1: configure mysql database django

You need to make changes in project settings.py. 
Provide USER and PASSWORD for your database
If your database isn't mysql change ENGINE

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'myproject',
        'USER': 'root',
        'PASSWORD': 'rootpassword',
        'HOST': 'localhost',
        'PORT': '',
    }
}

Example 2: link django to mysql

$ brew reinstall openssl
	#run two commands under "For compilers to find [email protected] you may need to set:"
$ pip install mysqlclient

Tags:

Sql Example