Python Django連接數(shù)據(jù)庫(kù)
10年積累的成都做網(wǎng)站、成都網(wǎng)站設(shè)計(jì)經(jīng)驗(yàn),可以快速應(yīng)對(duì)客戶對(duì)網(wǎng)站的新想法和需求。提供各種問(wèn)題對(duì)應(yīng)的解決方案。讓選擇我們的客戶得到更好、更有力的網(wǎng)絡(luò)服務(wù)。我雖然不認(rèn)識(shí)你,你也不認(rèn)識(shí)我。但先制作網(wǎng)站后付款的網(wǎng)站建設(shè)流程,更有正安免費(fèi)網(wǎng)站建設(shè)讓你可以放心的選擇與我們合作。
一、安裝數(shù)據(jù)庫(kù)
# yum -y install MySQL mysql-devel mysql-server
二、查看是否安裝了python數(shù)據(jù)庫(kù)組件
# rpm -qa | grep MySQL-python
MySQL-python-1.2.3-0.3.c1.1.el6.x86_64
三、創(chuàng)建數(shù)據(jù)庫(kù)
# mysql -uroot -p
mysql> create database csvt character set utf8;
四、創(chuàng)建工程,應(yīng)用
# django-admin.py startproject csvt03
# cd csvt03
# django-admin.py startapp blog
# vim settings.py (添加應(yīng)用,修改數(shù)據(jù)庫(kù)類(lèi)型連接用戶以及密碼)
...
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'csvt',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '',
'PORT': '',
}
}
............
INSTALLED_APPS = (
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'django.contrib.staticfiles',
'blog',
)
...
五、創(chuàng)建表
# cat blog/models.py
from django.db import models
class Employee(models.Model):
name = models.CharField(max_length=20)
//(會(huì)在數(shù)據(jù)庫(kù)csvt employee表中添加一個(gè)name字段)
六、同步數(shù)據(jù)庫(kù),將數(shù)據(jù)寫(xiě)入數(shù)據(jù)庫(kù)
# python manage.py syncdb
Creating tables ...
Creating table auth_permission
Creating table auth_group_permissions
Creating table auth_group
Creating table auth_user_user_permissions
Creating table auth_user_groups
Creating table auth_user
Creating table auth_message
Creating table django_content_type
Creating table django_session
Creating table django_site
Creating table blog_employee
You just installed Django's auth system, which means you don't have any superusers defined.
Would you like to create one now? (yes/no): yes
Installing custom SQL ...
Installing indexes ...
No fixtures found.
七、查看數(shù)據(jù)庫(kù)
mysql> use csvt;
Database changed
mysql> show tables;
+----------------------------+
| Tables_in_csvt |
+----------------------------+
| auth_group |
| auth_group_permissions |
| auth_message |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| blog_employee |
| django_content_type |
| django_session |
| django_site |
+----------------------------+
11 rows in set (0.00 sec)
mysql> desc blog_employee;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | NO | | NULL | |
+-------+-------------+------+-----+---------+----------------+
新聞標(biāo)題:七、PythonDjango連接數(shù)據(jù)庫(kù)
文章位置:http://muchs.cn/article48/pihoep.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供標(biāo)簽優(yōu)化、域名注冊(cè)、網(wǎng)站營(yíng)銷(xiāo)、網(wǎng)站改版、網(wǎng)頁(yè)設(shè)計(jì)公司、企業(yè)建站
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)