Question

python怎么判断mysql库中某个表是否已创建

Answer 1

 import MySQLdb 
        conn=MySQLdb.connect(host=connparas[0],
                            port=connparas[1],
                            db=connparas[2],
                            user=connparas[3],
                            passwd=connparas[4],
                            charset=charset)
        cursor=conn.cursor()
 
        cursor.execute(sqlselect)
        tablerows=cursor.fetchall()

Answer 2

sqlselect = "SELECT count(*) FROM information_schema.tables WHERE table_schema = <schema-or-db-name> AND able_name = <table-or-view-name>"

1
2
3
4
5
6
7
8
9
10
11
12
13

import MySQLdb

conn=MySQLdb.connect(host=connparas[0],
port=connparas[1],
db=connparas[2],
user=connparas[3],
passwd=connparas[4],
charset=charset)

cursor=conn.cursor()

cursor.execute(sqlselect)
tablerows=cursor.fetchall()