python操作mysql

標籤：

1.安裝mysql拓展

yum install python-develpip install MySQL-python

　　

2.在mysql中建立庫

create database reboot10 default character set utf8;

　　

3.建立表

create table users(id int AUTO_INCREMENT primary key,name varchar(20) not null comment ‘使用者名稱‘,name_cn varchar(50) not null comment ‘中文名‘,password varchar(50) not null comment ‘使用者密碼‘,email varchar(50) comment ‘電子郵件‘,mobile varchar(11) not null comment ‘手機號碼‘,role varchar(10) not null comment ‘1:sa;2:php;3:ios;4:test‘,status tinyint,create_time datetime comment ‘建立時間‘,last_time datetime comment ‘最後登入時間‘,unique key name(name))engine=innodb comment=‘使用者表‘;

　　

4.在python中操作mysql

>>> import MySQLdb as mysql>>> db=mysql.connect(user=‘root‘,passwd=‘www.123‘,db=‘reboot10‘,charset=‘utf8‘) >>> cur=db.cursor()>>> cur.execute(‘select * from users‘)0L>>> sql= ‘insert into users (name,name_cn,password,email,mobile,role,status,create_time,last_time) values ("wd","pcss","123456","[email protected]","12121212","sa",0,"20160806","20160806")‘>>> cur.execute(sql)1L>>> cur.execute(‘select * from users‘)1L>>> cur.fetchall()                    ((3L, u‘wd‘, u‘pcss‘, u‘123456‘, u‘[email protected]‘, u‘12121212‘, u‘sa‘, 0, datetime.datetime(2016, 8, 6, 0, 0), datetime.datetime(2016, 8, 6, 0, 0)),)>>> db.commit()  #提交>>> cur.close() >>> db.close()

　　

mysql> select * from users;+----+------+---------+----------+-----------------+----------+------+--------+---------------------+---------------------+| id | name | name_cn | password | email           | mobile   | role | status | create_time         | last_time           |+----+------+---------+----------+-----------------+----------+------+--------+---------------------+---------------------+|  3 | wd   | pcss    | 123456   | [email protected] | 12121212 | sa   |      0 | 2016-08-06 00:00:00 | 2016-08-06 00:00:00 |+----+------+---------+----------+-----------------+----------+------+--------+---------------------+---------------------+1 row in set (0.00 sec)

　　

 

python操作mysql