Timeline for Is index_type ignored on MySQL primary keys in create table?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 18, 2012 at 20:08 | comment | added | ypercubeᵀᴹ | Name of PK, CHECK constraints, inline FKs, order of indexes (ASC, DESC) are a few that come to mind. | |
| Apr 18, 2012 at 20:07 | comment | added | ypercubeᵀᴹ | MySQL has several places where it allows some things (especially in DDL) and simply ignores them. It is supposingly for scripts to be migrated from other DBMS with minimal changes. | |
| Dec 21, 2011 at 17:22 | comment | added | Aaron | Agreed; it should not allow you to add a value that it's not going to use. | |
| Dec 21, 2011 at 16:57 | comment | added | Jaime Soriano | Yes, I saw it, the thing is that in contrast to UNIQUE, PRYMARY keys cannot have a name, but you still can specify the index type. What it doesn't make any sense to me is that it accepts a name where should be a type, and totally ignore it. | |
| Dec 20, 2011 at 16:33 | history | edited | Aaron | CC BY-SA 3.0 |
added 79 characters in body
|
| Dec 20, 2011 at 16:25 | history | answered | Aaron | CC BY-SA 3.0 |