Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Anyway, I tried
Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Anyway,
Bingo. Yeah, that works very well.
Really appreciated.
BTW, still curious about the reason of duplicate.:)
Any thoughts?
Monet
--- Jim Grill [EMAIL PROTECTED] wrote:
Hello there,
I tried REPAIR TABLE to recovery the crushed
temp
table and that works. Thanks a lot.
But, after
Monet wrote:
Hello there,
I tried REPAIR TABLE to recovery the crushed temp
table and that works. Thanks a lot.
But, after reparation, there are some duplicated
records generated. Is that because the temp table has
no primary key? Or is because the table was crushed in
the middle of query?
Bingo. Yeah, that works very well.
Really appreciated.
BTW, still curious about the reason of duplicate.:)
Any thoughts?
Monet
Several thoughts; one of which is Thank my lucky stars! I have my data
back! :-)
Other, less significant thoughts include the possibility that some esoteric