New answers tagged alter-table
It depends, could be an hour or so. Perhaps you may like to give percona toolkit a try; pt-online-schema-change. pt-online-schema-change alters a table’s structure without blocking reads or writes. Specify the database and table in the DSN. Do not use this tool before reading its documentation and checking your backups carefully. Source: ...
You can't embed DDL in a stored procedure like this. Either use execute immediate and your DDL statement passed to it as a string, or, better, remove the stored procedure entirely an execute the DDL directly.
In my previous response I have not taken into account CONVERT TO behavior, so I have tried your test, first using the mysql native client and all works fine, column are automatically converted, and then using a jdbc connector and actually I got the same error... but after some test and some research I have found the solution. You have to add in your jdbc ...
from your question i understand that you have a "One to many" relationship between The Division to the Regions, the best way with this kind of relational data from my experience is to create a Division table and a Region table that holds the DivisionID. that will also use less storage space because you won't need to write the division name in string, you ...
Top 50 recent answers are included