《MysqL教程Python MysqL进行数据库表变更和查询》要点:
本文介绍了MysqL教程Python MysqL进行数据库表变更和查询,希望对您有用。如果有疑问,可以联系我们。
Python连接MysqL,进行数据库表变更和查询:
python MysqL insert delete query:
#!/usr/bin/python
import MysqLdb
def doInsert(cursor,db):
#insert
# Prepare sql query to INSERT a record into the database.
sql = "UPDATE EMPLOYEE SET AGE = AGE+1 WHERE SEX = '%c'" %('M')
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
def do_query(cursor,db):
sql = "SELECT * FROM EMPLOYEE \
WHERE INCOME > '%d'" % (1000)
try:
# Execute the sql command
cursor.execute(sql)
# Fetch all the rows in a list of lists.
results = cursor.fetchall()
print 'resuts',cursor.rowcount
for row in results:
fname = row[0]
lname = row[1]
age = row[2]
sex = row[3]
income = row[4]
# Now print fetched result
print "fname=%s,lname=%s,age=%d,sex=%s,income=%d" % \
(fname,lname,age,sex,income )
except:
print "Error: unable to fecth data"
def do_delete(cursor,db):
sql = 'DELETE FROM EMPLOYEE WHERE AGE > {}'.format(20)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
def do_insert(cursor,db,firstname,lastname,income):
sql = "INSERT INTO EMPLOYEE(FIRST_NAME,\
LAST_NAME,AGE,SEX,INCOME) \
VALUES ('%s','%s','%d','%c','%d' )" % \
(firstname,income)
try:
cursor.execute(sql)
db.commit()
except:
db.rollback()
# Open database connection
# change this to your MysqL account
#connect(server,username,password,db_name)
db = MysqLdb.connect("localhost","root","pydb" )
# prepare a cursor object using cursor() method
cursor = db.cursor()
do_query(cursor,db)
doInsert(cursor,db)
do_query(cursor,db)
do_delete(cursor,db)
do_insert(cursor,'hunter','xue',22,'M',2000)
do_insert(cursor,'mary','yang','f',5555)
do_insert(cursor,'zhang',32,5000)
do_insert(cursor,333)
do_query(cursor,db)
# disconnect from server
db.close()
之后可以在此基础上根据需要进行封装.
感谢阅读,希望能赞助到大家,谢谢大家对本站的支持!
编程之家PHP培训学院每天发布《MysqL教程Python MysqL进行数据库表变更和查询》等实战技能,PHP、MysqL、LINUX、APP、JS,CSS全面培养人才。
总结
如果觉得编程之家网站内容还不错,欢迎将编程之家网站推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您喜欢交流学习经验,点击链接加入交流1群:1065694478(已满)交流2群:163560250