python的基础小程序，数据库的链接

微信公众号是：企鹅电竞宇磊

微信公众号是：企鹅电竞宇磊点击打开链接

微信公众号是：企鹅电竞宇磊

import pymysql
conn = pymysql.connect(
    host = 'localhost',
    port = 3306,
    user = 'root',
    passwd = '1234',
    db = 'user',
    charset = 'utf8'
)
cur = conn.cursor()
user_name = {
    'create':"create table user(id int auto_increment primary key,"
             "name varchar(20) not null,"
             "age int unsigned,"
             "tel varchar(32),"
             "address varchar(200));",
    'insert1':"insert into user VALUES(1,'张三','30','151215','邯郸'),\
      (2,'李四','33','002520','石家庄'),\
      (3,'王五','12','152522','合肥'),\
      (4,'傻逼','12','1228652','北京'),\
      (5,'八位','0','15852552','北京'),\
      (6,'绿豆饼','25','125852','寒素'),\
      (7,'七仙女','100','87965','天宫'),\
      (8,'北京','12','849613','看是哦'),\
      (9,'赵武','12','12356895','北京'),\
      (10,'招兵','16','164961','北京');",
    'select':"select * from uesr;",
    'select1':"select * from user where age>30;",
    'insert2':"insert into user values(11,'照应为','23','12356','邯郸');",
    'delect':"delete from user where id=1;",
    'update':"update user set age=age+2;",
    'select2':"select * from user where address like'%北京%';",
    'delete2':"delete from user where name='张三';",
    'update2':"update user set tel = ' ' where name ='李四';",
}

# cur.execute(user_name['create'])

cur.execute(user_name['insert1'])
conn.commit()
cur.execute(user_name['select1'])
conn.commit()

import pymysqlconn = pymysql.connect( host = 'localhost',#本地主机地址 port = 3306,#端口号 user = 'root', passwd = '1234', db = 'user', charset = 'utf8')cur = conn.cursor()user_name = { 'create': "create table user(id int auto_increment primary key," "name varchar(20) not null," "age int unsigned," "tel varchar(32)," "address varchar(200));", 'insert1': "insert into user VALUES(1,'张三','30','151215','邯郸'),\ (2,'李四','33','002520','石家庄'),\ (3,'王五','12','152522','合肥'),\ (4,'傻逼','12','1228652','北京'),\ (5,'八位','0','15852552','北京'),\ (6,'绿豆饼','25','125852','寒素'),\ (7,'七仙女','100','87965','天宫'),\ (8,'北京','12','849613','看是哦'),\ (9,'赵武','12','12356895','北京'),\ (10,'招兵','16','164961','北京');", 'select': "select * from uesr;", 'select1': "select * from user where age>30;", 'insert2': "insert into user values(11,'照应为','23','12356','邯郸');", 'delect': "delete from user where id=1;", 'update': "update user set age=age+2;", 'select2': "select * from user where address like'%北京%';", 'delete2': "delete from user where name='张三';", 'update2': "update user set tel = ' ' where name ='李四';",} # cur.execute(user_name['create'])cur.execute(user_name[ 'insert1'])conn.commit()cur.execute(user_name[ 'select1'])conn.commit()