python连接mysql

最新推荐文章于 2023-05-17 20:09:30 发布

原创最新推荐文章于 2023-05-17 20:09:30 发布 · 490 阅读

0 ·

CC 4.0 BY-SA版权

python 专栏收录该内容

4 篇文章

订阅专栏

本文详细介绍了使用Python连接MySQL数据库，执行SQL语句插入数据，并通过执行查询获取数据的操作流程。包括创建连接、执行SQL语句、数据插入、数据查询等步骤。

# -*- encoding: utf-8-*- 
import MySQLdb
print "开始建立连接"
conn = MySQLdb.connect(host="127.0.0.1", user="root", passwd="fang", port=3306)
cur = conn.cursor()
sql = "use python "
cur.execute(sql)
for i in range(1, 20):
    id = i
    name = 'user_' + str(i)
    pwd = 'passwd_' + str(i)
    sql = "insert into user(id,name,password) values('" + str(id) + "','"+ name + "','" + pwd + "')"
    print sql
    cur.execute(sql)




conn.commit()
cur.close()
conn.close()
print "执行sql语句完毕"

mysql> desc user;
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| id       | int(10)  | NO   | PRI | NULL    |       |
| name     | char(30) | YES  | UNI | NULL    |       |
| password | char(30) | YES  |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
3 rows in set (0.01 sec)


mysql> select * from user;
+----+---------+-----------+
| id | name    | password  |
+----+---------+-----------+
|  1 | user_1  | passwd_1  |
|  2 | user_2  | passwd_2  |
|  3 | user_3  | passwd_3  |
|  4 | user_4  | passwd_4  |
|  5 | user_5  | passwd_5  |
|  6 | user_6  | passwd_6  |
|  7 | user_7  | passwd_7  |
|  8 | user_8  | passwd_8  |
|  9 | user_9  | passwd_9  |
| 10 | user_10 | passwd_10 |
| 11 | user_11 | passwd_11 |
| 12 | user_12 | passwd_12 |
| 13 | user_13 | passwd_13 |
| 14 | user_14 | passwd_14 |
| 15 | user_15 | passwd_15 |
| 16 | user_16 | passwd_16 |
| 17 | user_17 | passwd_17 |
| 18 | user_18 | passwd_18 |
| 19 | user_19 | passwd_19 |
+----+---------+-----------+
19 rows in set (0.00 sec)

import MySQLdb  
conn = MySQLdb.connect(host="127.0.0.1", user="root", passwd="fang",db="python",port=3306)  
cur = conn.cursor()  
#sql = "select * from user"   
#sql = "select * from user where id=2"   
#sql = "select name,password from user where id<12 and id>5"  
sql = "select name,password from user where id in (3,5,7)"  
cur.execute(sql)  
rows = cur.fetchall()  
for i in rows :  
    print i  
conn.commit()  
cur.close()  
conn.close()