Timeline for Fastest way to add a field to a large table
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 17, 2016 at 20:42 | comment | added | Martin Smith | @dfundako nope. The online default values was only introduced in 2012. It wasn't mentioned in that other question until srutzky gave an answer just now. | |
| Aug 17, 2016 at 20:40 | comment | added | dfundako | @johnmcp So the answer to this question was the same answer to the question that was 9 years old? | |
| Aug 17, 2016 at 19:52 | history | edited | Martin Smith | CC BY-SA 3.0 |
deleted 12 characters in body
|
| Aug 17, 2016 at 19:49 | comment | added | Solomon Rutzky |
@johnmcp and Martin: The WITH VALUES clause is not needed here. That is only for adding a NULLable column that has a default and you want the initial value to be the default instead of NULL. For this particular case, only the DEFAULT is needed (and set to 0 instead of 1 ;).
|
|
| Aug 17, 2016 at 19:48 | vote | accept | johnmcp | ||
| Aug 17, 2016 at 19:48 | comment | added | johnmcp | Excellent, this is exactly what I need. Thanks a lot. | |
| Aug 17, 2016 at 17:41 | history | answered | Martin Smith | CC BY-SA 3.0 |