Django+MySQL
linux进入mysql的相关操作
- 进入数据库的命令: root# mysql -h 127.0.0.1 -u root -p
- 创建数据库: create database users;
- 显示数据库: show databases;
Django对mysql的相关配置(settings.py)
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'DB',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3306',
}
}
数据库的相关DML语句 – 定义数据表
create table event(
event_id varchar(20),
topic varchar(100),
post_time date,
topic_word varchar(50),
information varchar(100),
primary key(event_id)
);
- python 连接 mysql 的类MySQLdb
connhost = '127.0.0.1'
user = 'root'
passwd = '5510358'
db = 'jdapiDB'
charset = 'utf8'
conn = MySQLdb.connect(host=AccessDB.connhost, user=AccessDB.user, passwd=AccessDB.passwd, db=AccessDB.db, charset=AccessDB.charset)
conn.select_db(AccessDB.db)
cursor = conn.cursor()
str_sql = "select %s from users;" % username
result = cursor.execute(str_sql)
cursor.close()
conn.close()