1,首先安装python,mysqldb,mysql
以下是连接代码:
#coding=utf-8 import MySQLdb,sqlite3 import time conn= MySQLdb.connect( host='localhost', port = 3306, user='root', passwd='123456', db ='shopweb1.5.5sp5' ) cur = conn.cursor() #创建数据表 #cur.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))") #cur.execute("create table stu(id int,name varchar(20),class varchar(30),age varchar(10))") #插入一条数据 #cur.execute("insert into student values('2','Tom','3 year 2 class','9')") #cur.execute("insert into stu values('2','jone','3 year 3 class','10')") # sqli="insert into student values(%s,%s,%s,%s)" # cur.executemany(sqli,[ # ('3','Tom','1 year 1 class','6'), # ('3','Jack','2 year 1 class','7'), # ('3','Yaheng','2 year 2 class','7'), # ]) #修改查询条件的数据 #cur.execute("update student set class='3 year 1 class' where name = 'Tom'") #删除查询条件的数据 #cur.execute("delete from student where age='9'") #查询表中有多少条数据 a = cur.execute("select * from hs_goods where sku=1002") print a #打印表中的多少数据 info=cur.fetchmany(a) for ii in info: print ii cur.close() conn.commit() conn.close()