Execute MySQL query in multiple databases at once

Question

I have many MySQL databases that have same tables with the same structure. I am looking for simple way how can I alter table structure in all of the databases at once ( in one query or using one tool).

Community · Accepted Answer · 2017-05-23 11:56:09Z

2

you can see this solution like of alter many tables in the post :

select concat( 'alter table ', a.table_name, ' add index `fields` (`field`);' )
from information_schema.tables a 
where a.table_name like 'table_prefix_%';

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Nov 1, 2010 at 12:00

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

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

Comments

Teson · Accepted Answer · 2010-11-01 12:01:12Z

0

A QND way, but anyhow,

make changes on main-db with prefered tool.
copy successful sql-statement to web-script (php or similar) that executes the sql with loop on defined 'slave' dbs.

//regards

answered Nov 1, 2010 at 12:01

Teson

6,7469 gold badges50 silver badges70 bronze badges

Collectives™ on Stack Overflow

Execute MySQL query in multiple databases at once

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related