当前位置：Gxlcms >
数据库问题 >
Install MySQL-python to connect MySQL
Install MySQL-python to connect MySQL
时间：2021-07-01 10:21:17
帮助过：2人阅读
#-*- encoding:UTF-8 -*-
2 import os, sys, string
3 import MySQLdb
4
5 try:
6 conn = MySQLdb.connect(host=
"localhost", user=
"root", passwd=
"123456",db=
"mydatabase")
7 except Exception, e:
8 print e;
9 sys.exit()
10
11 #Get cursor obj to operator database
12 cursor =
conn.cursor()
13 sql =
"create table if not exists test(name varchar(128) primary key, age int(3))"
14 cursor.execute(sql)
15
16 #insert data to db
17 sql =
"insert into test(name, age) values (‘%s‘, %d)" % (
"coode", 25
)
18 sql2 =
"insert into test(name, age) values (‘%s‘, %d)" % (
"Ben", 19
)
19 try:
20 cursor.execute(sql)
21 conn.commit();
22 cursor.execute(sql2)
23 conn.commit()
24 except Exception, e:
25 print e
26
27 #select data from db
28 sql =
"select * from test"
29 cursor.execute(sql)
30 result =
cursor.fetchall()
31 #the result is a list
32 if result:
33 for rs
in result:
34 print rs[0], rs[1
]
35
36 cursor.close()
37 conn.close()
Install MySQL-python to connect MySQL
标签：
