Shulou(Shulou.com)06/02 Report--

Django how to connect to the MySQL database, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Django configuration connection database

Django uses SQLite database by default. If you want to use other databases, you need to modify the settings.py file in the project directory.

DATABASES = {'default': {' ENGINE': 'django.db.backends.mysql', # type of connection to the database' NAME': 'mysite', # database name' HOST': '192.168.4.108, # database host address' PORT': 3306, # database port 'USER':' root' 'PASSWORD': 'abc123',' TIME_ZONE': 'Asia/Shanghai',}}

Note: when using other databases, you need to install the relevant module to connect to the database (mysqlclient...)

Manipulate data queries using ORM

Class name .objects.all (): query all and return a list

Class name .objects.all () .order_by ('field name'): sort by a field

Class name .objects.filter (): conditional query that returns a list

Class name .objects.get (): returns a single object

Increase

Class name .objects.create (field name = value,...): create an object

Delete

Class name .objects.filter (id=...) .delete (): deleted according to ID

Modify

Class name .objects.filter (id=...) .class (field name = new value): modified according to ID

Or

Obj = class name. Objects.get (id='') obj. Field name = value obj.save ()

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.