Timeline for CREATE INDEX vs ALTER TABLE ADD INDEX - MySQLism, or SQL Standard?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 23, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Jul 19, 2013 at 6:31 | comment | added | Mike Purcell | @a_horse_with_no_name: Duly noted. I don't understand why MySQL forces us to pass an index_name, when clearly it can handle no name underneath. It's a PITA to be forced to do an alter simply to avoid naming indices. | |
| Jul 18, 2013 at 21:25 | comment | added | user1822 |
MySQL is the only DBMS I know which allows adding an explicit index using ALTER TABLE (there are certain cases where implicit indexes will be created by various DBMS to support constraints, but that's not what I mean).
|
|
| Jul 18, 2013 at 19:50 | vote | accept | Mike Purcell | ||
| Jul 18, 2013 at 19:25 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
add more sources.
|
| Jul 18, 2013 at 19:14 | history | answered | Erwin Brandstetter | CC BY-SA 3.0 |