import MySQLdb
db = raw_input('请输入数据库名:')
table_name=raw_input("请输入表名:")
conn =MySQLdb.Connect(user='root',passwd='redhat',host='localhost',db=db,port=3306)
cur=conn.cursor()
cur.execute('show tables;')
for i in cur.fetchall():
if i[0] == table_name:
print"%s存在"%table_namebreakelse:
print"%s不存在"%table_name
conn.commit()
cur.close()
conn.close()
数据库封装
import time ###time模块在MySQLdb之前,否则,\__del__方法无法使用
import MySQLdb as mysql
db = {
'user':'root',
'passwd':'redhat',
'host':'localhost',
'port':3306,
'charset':'utf8',
'db':'user',
}
class