Timeline for Having both a integer Primary Key and a GUID/UUID column on same table-is this bad
Current License: CC BY-SA 3.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 18, 2017 at 2:11 | history | tweeted | twitter.com/StackDBAs/status/876261170319163392 | ||
| May 23, 2017 at 11:49 | history | edited | marc_s | CC BY-SA 3.0 |
added 1 character in body; edited title
|
| Apr 4, 2017 at 20:41 | history | edited | marc_s | CC BY-SA 3.0 |
deleted 1 character in body
|
| Dec 12, 2015 at 5:56 | answer | added | Rick James | timeline score: 1 | |
| Dec 12, 2015 at 5:49 | comment | added | Rick James | Migration has many problems. You are prematurely trying to solve a problem that might be insignificant in the big picture. | |
| Dec 12, 2015 at 5:44 | comment | added | Rick James |
Not if you keep the original values in the AUTO_INCREMENT column.
|
|
| Dec 8, 2015 at 8:03 | answer | added | Sir Swears-a-lot | timeline score: 0 | |
| Dec 3, 2015 at 19:27 | comment | added | jordan koskei | How does GUID make migration easier?-because GUID is unique and not autoincrementing. What migration? For example, if you split a table into two-if your primary key was some autoincrementing field, then there will be a problem with other tables that reference this field | |
| Dec 3, 2015 at 19:18 | comment | added | jordan koskei | I have the sql server tag because while I am using mySql, the same issue would arise in a SQL server environment | |
| Dec 3, 2015 at 19:14 | comment | added | Hannah Vernon♦ | How does a GUID make migration easier? And what kind of migration? | |
| Dec 3, 2015 at 19:12 | comment | added | Hannah Vernon♦ | So you have a MySQL Database, not a SQL Server database? Why is this question tagged sql-server ? SQL Server is not MySQL. | |
| Dec 3, 2015 at 19:07 | answer | added | Mr.Brownstone | timeline score: 2 | |
| Dec 3, 2015 at 19:05 | comment | added | ypercubeᵀᴹ | Chwck this article that has some tests: percona.com/blog/2014/12/19/store-uuid-optimized-way | |
| Dec 3, 2015 at 18:53 | review | First posts | |||
| Dec 3, 2015 at 19:20 | |||||
| Dec 3, 2015 at 18:53 | history | asked | jordan koskei | CC BY-SA 3.0 |