MySQL Querying Multiple Databases

Question

I have multiple databases and I need to search for a value in a table and set it to NULL in all instances across all databases.

I know how to query individual databases after "USE 'DBName'" is called to select a particular database.

How do I loop all databases?

Shira · Accepted Answer · 2016-05-24 13:59:34Z

2

Use the SHOW DATABASES query to list all databases.

You don't need to USE the database to query its tables:

SELECT something FROM databasename.sometable

answered May 24, 2016 at 13:59

Shira

6,5892 gold badges27 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1