import pymysql
cursor = conn.cursor()
sql_delete = "drop table sqls;"
sql_create = """
create table sqls(
sid INT NOT NULL primary key,
Spri varchar(20) not null);
"""
sql_insert1 = "insert into sqls(sid,Spri)values('1','select');"
sql_insert2 = "insert into sqls(sid,Spri)values('2', 'insert');"
sql_insert3 = "insert into sqls(sid,Spri)values('3', 'update');"
sql_insert4 = "insert into sqls(sid,Spri)values('4', 'delete');"
sql_insert5 = "insert into sqls(sid,Spri)values('5', 'all');"
cursor.execute(sql_delete)
cursor.execute(sql_create)
cursor.execute(sql_insert1)
cursor.execute(sql_insert2)
cursor.execute(sql_insert3)
cursor.execute(sql_insert4)
cursor.execute(sql_insert5)
conn.commit()
conn.close()
print "Success"
cursor.close()
python 创建数据库表方法
最新推荐文章于 2024-07-07 16:33:06 发布