/SQL/Python connect to mysql in settings.py

Python connect to mysql in settings.py

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'website',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
        'OPTION': {'init_command':"SET sql_mode='STRICT_TRANS_TABLE',"},
    }
}

Source: stackoverflow.com

Similar codes

5 votes247 views1 answer
Alter table default value mysql
SQL
6 votes326 views1 answer
Oracle trigger after logon on database
SQL
0 vote291 views1 answer
Executescalar in sql server
SQL
0 vote278 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote331 views1 answer
Sql server set variable if exists
SQL
6 votes296 views1 answer
Oracle list primary key
SQL
0 vote319 views3 answers
Select top 10 rows in sql
SQL
4 votes289 views2 answers
Postgre sql create table
SQL
1 vote318 views1 answer
Postgres left join
SQL
4 votes277 views1 answer
Restart for pg_hba.conf file
SQL