> 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 eso
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?
Anyw
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.
> >
>
> 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?
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
The manual knows all:
http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
Cheers,
--V
Monet wrote:
I was working on a table, doing some simple update on
table, query is like:
Update temp
SET Q1 = 14,
REVIEWCOMMENTS = CASE WHEN REVIEWCOMMENTS='WHO2'
THEN ''
WHEN REVIEWC
I was working on a table, doing some simple update on
table, query is like:
Update temp
SET Q1 = 14,
REVIEWCOMMENTS = CASE WHEN REVIEWCOMMENTS='WHO2'
THEN ''
WHEN REVIEWCOMMENTS LIKE
'%,WHO2' THEN TRIM(TRAILING ',WHO2' FROM
REVIEWCOMMENTS)
WHE
