python_操作MySQL 初解

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了python_操作MySQL 初解，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1539字，纯文字阅读大概需要3分钟。

内容图文

# -*- coding: utf-8 -*-
# __author__ = "Allen"

import pymysql
con=pymysql.connect(
    host="localhost",
    user="root",
    port=3306,
    passwd="123",
    charset="utf8",
    db="test"
)
cur=con.cursor()
sql={
    "create":'create table if not  exists shu(name char(15)not null,sex char(10),age int,score int)default charset="utf8"',
    "insert":[
        'insert into shu values("小王","男",26,97)',
        'insert into shu values("小白","女",34,89)',
        'insert into shu values("小黄","女",22,95)',
        'insert into shu values("小黑","女",27,58)',
        'insert into shu values("小刘","男",24,76)',
        'insert into shu values("小讲","男",34,65)',
        'insert into shu values("小班","男",42,79)'
    ],
    "select":'select * from shu where sex="男";',
    "select1":'select * from shu where sex="女";',
    "select2":'select * from shu where score>80;',
    "update":'update shu set age=age+2;',
    "select3":'select * from shu;',
    "delete":'delete from shu where name="小讲";',
    "select4":'select * from shu order by age desc;',
    "select5":'select * from shu order by age asc;',
    "drop":'drop table if exists shu',
}
def for_out(cur):
    for i in cur:
        print(i)
    print( )
try:
    print("初始化数据库")
    print(sql["create"])
    cur.execute(sql["create"])

    for j in sql["insert"]:
        print(j)
        cur.execute(j)
    cur.execute(sql["select"])
    for_out(cur)

    cur.execute(sql["select1"])
    for_out(cur)

    cur.execute(sql["select2"])
    for_out(cur)

    cur.execute(sql["update"])
    for_out(cur)
    cur.execute(sql["select3"])
    for_out(cur)
    cur.execute(sql["delete"])
    for_out(cur)
    cur.execute(sql["select4"])
    for_out(cur)
    cur.execute(sql["select5"])
    for_out(cur)
    cur.execute(sql["drop"])
    for_out(cur)
except Exception as f:
    print(f)
    con.rollback()
con.close()
cur.close()

内容总结

以上是互联网集市为您收集整理的python_操作MySQL 初解全部内容，希望文章能够帮你解决python_操作MySQL 初解所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端