Python中MySQL插入数据

1 sql = 'INSERT INTO course(class_name, credit, properties, teacher_name, college_given, classroom) ' 
2                   'VALUES ("%s", "%d", "%s", "%s", "%s", "%s")' % 
3                   (class_name, credit, properties, teacher_name, college_given, classroom)
4             cursor.execute(sql)
5             conn.commit()
原文地址:https://www.cnblogs.com/cymwill/p/6501077.html