import re str1 = 'my naaaame is iu' #从开始位置去进行匹配 # print(re.match('my', str1).group(0)) # #search()是从整个字符串中查找和正则表达式匹配的字符串 # print(re.search('iu', str...

import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() zwy.commit() delete_sql = 'delete from student where sna...

import pymysql #需求：在world数据库中，创建一张student表 #1.连接数据库 db=pymysql.connect(host='localhost',user='root',passwd='123456789',db='world') #创建一个游标对象 cursor=db.cu...

import re #1.re.findall()函数：查找字符串中所有匹配的子串，返回值类型是列表,如果未匹配到，则返回一个空列表而不是none # str1='qwertyuioppoiu0516q' # a=re.findall('i',str1) # print(a...

import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() create_sql = '''create table student ( sid char(10), sna...

import pymysql zwy = pymysql.connect(host='localhost', user='root', password='123456789', db='world') cursor = zwy.cursor() insert_many_sql = [('01', 'zwy', 'n'), ('02', 'yxj', 'n'...