How to write an SQL script that needs to be executed on many databases?

Question

I got this:

SET @databasename = (SELECT DATABASE());

USE @databasename;

...SQL Querys...

But this don`t works for me :(

Answer 1

Try this:

SELECT DATABASE() INTO databasename;