#链接数据库
conn = pymysql.connect(host=‘localhost’,user=‘root’,password=‘123456’,database=‘dbmovie_top250’,port=3306,autocommit=False)
#获取游标
cursor = conn.cursor()
#执行sql
sql = “select COLUMN_NAME from INFORMATION_SCHEMA.Columns where table_name=‘t_top250’ ;”
cursor.execute(sql)
import re
sql2 = ‘alter table t_top250 drop actor2’
s = str(cursor.fetchall())
print(s)
actor = re.findall(‘actor2’,s)
print(actor)
if ‘actor2’ in actor:
cursor.execute(sql2)
print(‘actor2 is in’)
else:
print(‘actor2 is not in’)
sql1 = ‘alter table t_top250 add actor2 varchar(45);’
cursor.execute(sql1)
conn.commit()
cursor.close()
conn.close()
