| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> or rather, that's what you're doing; every single row will be moved on disk
<1> I'm not really *changing* the PK, since it didn't have one when I loaded the data. But you're saying I should set the primary key constraint and the load the database?
<0> yes you did
<0> you cannot not have a PK in InnoDB
<2> if you don't have one, innodb creates a hidden one
<3> innodb has a pk automagically
<0> it was auto created with hidden auto-inc bigint
<0> so, now you have two of those :)
<1> Nice.
<1> OK this has been enlightening. I'll drop my table and start over with the right PK in place.
Return to
#mysql
or
Go to some related
logs:
#python
noia hax
#web
smartmovies ed2k
css no opacity
#debian
#css
irc_332
ubuntu dvr-ms
#bash
|
|