Timeline for Alter table add column query blocking a table or taking so much time
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 20, 2015 at 17:54 | history | edited | Colin 't Hart | CC BY-SA 3.0 |
deleted 29 characters in body
|
| Feb 21, 2014 at 2:17 | answer | added | Zack | timeline score: 1 | |
| Feb 20, 2014 at 16:49 | comment | added | ant | Can you try and a create a new table (table b) which will be empty and contain the new column. And then can you do the inserts with selects from the old table (table a) into the table b? Then delete the the table a. And then rename the table b to table a again. And please before you try anything, create a backup just to be safe. P.S I'm not a database administrator, I described what would I do if that happened to me. I'm also curious about the possible solutions | |
| Feb 20, 2014 at 16:33 | history | asked | Jorge Vega Sánchez | CC BY-SA 3.0 |