import pymysql mydb=pymysql.connect("192.168.0.0","xxx","xxx","mydb") mycursor=mydb.cursor() sql=""" CREATE TABLE student ( student_id int, student_name varchar(100), class_id int, gender varchar(10), birth_day date, primary key(student_id) )ENGINE=MyISAM CHARSET=gbk; """ mycursor.execute(sql) mycursor.close() mydb.close()
python操作数据库
最新推荐文章于 2024-09-10 15:45:22 发布