import pymysql
conn = pymysql.connect(host='localhost',port=3306, user='root',passwd='', db='python', charset='utf8mb4')#声明mysql连接对象
cursor = conn.cursor()
sql_createTb = """CREATE TABLE jython (
name_id INT NOT NULL AUTO_INCREMENT,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1),
PRIMARY KEY(name_id))
"""
sql_insert = "insert into money(LAST_NAME,AGE,SEX) values('de2',18,'0')"
cursor.execute(sql_createTb)
cursor.execute(sql_insert)
print("您的表已经创建成功!")
conn.close()
cursor.close()
连接数据库并且创建数据表
最新推荐文章于 2023-06-27 00:11:19 发布