import pymysql
import re
def table_exists(con,table_name): #这个函数用来判断表是否存在
sql = "show tables;"
con.execute(sql)
tables = [con.fetchall()]
table_list = re.findall('(\'.*?\')',str(tables))
table_list = [re.sub("'",'',each) for each in table_list]
if table_name in table_list:
return 1 #存在返回1
else:
return 0 #不存在返回0
connect = pymysql.connect(
user = 'root',
password = 'password',
db = 'MYSQL',
host = '127.0.0.1',
port = 3306,
charset = 'utf8'
)
con = connect.cursor()
con.execute('use database')
table_name = 'animal'
if(table_exists(con,table_name) != 1):
print("表不存在,可以添加一张")
con.close()
connect.close()