Tagged Questions
0
votes
1answer
167 views
Possible to programmatically ALTER multiple MySQL tables?
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 ...
2
votes
2answers
456 views
How do you handle the task of changing the schema of a production MySQL database?
One of the biggest complaints I have heard about MySQL is that it locks up a table if you try to change its schema like adding a column or adding an index.
By "locking up the table" does it mean I ...
2
votes
4answers
152 views
Autogenerate a PDF or image of all the database tables and columns in a MySQL database?
I want to be able to create a PDF or an image of a MySQL database. It should have one box per table and each box should list all the columns in the table. I don't need lines going between various ...
