#coding=utf-8 # file='c:/employee.txt' # fo=open('c:/employee.txt','w+') # # re=fo.read() # # print re # # fo.close() # # fo.write('good') # # #print fo.read() # fo.close() # import os # def dirList(path): # filelist=os.listdir(path) # fpath=os.getcwd(); # allfile=[] # for filename in filelist: # allfile.append(fpath+filename) # return allfile # # list=dirList('c://') # print list import MySQLdb # conn=MySQLdb.connect(user='root',passwd='',host='127.0.0.1') # # conn.select_db('test') # curn=conn.cursor() # # curn.execute("insert into news(title,content) value('ddd01','content')") conn= MySQLdb.connect( host='localhost', port = 3306, user='root', passwd='', db ='test', ) cur = conn.cursor() #创建数据表 #cur.execute("create table student(id int ,name varchar(20),class varchar(30),age varchar(10))") #插入一条数据 inset=cur.execute("insert into news(title,content,filename) values('ddd01','content','123')") #修改查询条件的数据 #cur.execute("update student set class='3 year 1 class' where name = 'Tom'") #删除查询条件的数据 #cur.execute("delete from student where age='9'") print inset cur.close() conn.commit() conn.close()
python MySQLdb mysql 数据库连接
最新推荐文章于 2021-03-17 04:54:31 发布