Execute SQL in all databases

query.py

import MySQLdb

connection = MySQLdb.connect(
                host = 'localhost',
                user = 'root',
                passwd = 'secret')  # create the connection

cursor = connection.cursor()     # get the cursor
cursor.execute("SHOW DATABASES")    # execute 'SHOW TABLES' (but data is not returned)
tables = cursor.fetchall()

#UPDATE %d.table SET col='value' WHERE id=1;
query = input("SQL: (%d for database name)>> ")
array_databases = []
for (table_name,) in cursor:
  tmp_query = query.replace("%d",table_name)
  print(tmp_query)