I have multiple MySQL tables with names of the form
"Shard_0", "Shard_1", "Shard_2" ... "Shard_n" All of them have identical table structure. They all live in the same database.
Say I want to add a column to all those tables. Is there a way to do that programmatically?
# pseudo code for i in range(n): tablename = "shard_"+str(i) ALTER TABLE tablename ...
Is it possible to do something like that? If so what language and/or library do I need?