I have the following code:
but for some reason it just won't work if I touch the i
the query self works, cause if I just do .Append(str(i)) without the split strip it returns all the tables..
def mysql_table(self):
self.list_box_3.Set([])
try:
self.cursor.execute("SHOW TABLES;")
self.query = self.cursor.fetchall()
except:
self.log("error")
for i in self.query:
i = str(i).split().strip("'")[1]
self.list_box_3.Append(str(i))