|
#2
炎天2017-11-06 20:22
好吧,问题解决了,还是要谢谢广大水友, 那个警告不是主要问题，是我在另一个源代码中敲错了几个字符
 做到有头有尾，依次附上另一个源代码-------旨在插入两条数据  程序代码：#coding=utf-8 import MySQLdb db = MySQLdb.connect("localhost","root","q199604171","bigdata") cursor = db.cursor() try: sql = """INSERT INTO EMPLOYEE(FIRST_NAME, LAST_NAME,AGE,SEX,INCOME) VALUES('Mac','Mohan',20,'M',2000)""" cursor.execute(sql) sql="INSERT INTO EMPLOYEE(FIRST_NAME, \ LAST_NAME,AGE,SEX,INCOME) \ VALUES('%s','%s','%d','%c','%d')" % \ ('Mac','Mohan',20,'M',2000) cursor.execute(sql) () except: db.rollback() db.close() [此贴子已经被作者于2017-11-6 20:26编辑过] |
显示源代码
程序代码：#coding=utf-8
import MySQLdb
db = MySQLdb.connect("localhost","root","q199604171","bigdata")
cursor = db.cursor()
cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")
sql = """CREATE TABLE EMPLOYEE(
FIRST_NAME CHAR(20) NOT NULL,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1),
INCOME FLOAT )"""
cursor.execute(sql)
db.close()
import MySQLdb
db = MySQLdb.connect("localhost","root","q199604171","bigdata")
cursor = db.cursor()
cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")
sql = """CREATE TABLE EMPLOYEE(
FIRST_NAME CHAR(20) NOT NULL,
LAST_NAME CHAR(20),
AGE INT,
SEX CHAR(1),
INCOME FLOAT )"""
cursor.execute(sql)
db.close()
代码应该没毛病，照着PPT上敲的, 请大家看看编译警告该怎么解决,下面上图
只有本站会员才能查看附件，请 登录
