List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:February 1 2000 7:11am
Subject:Re: Update wierdness
View as plain text  
Hi,

Running isamchk -r did not help. Any other ideas, anybody ?

Tonu Samuel wrote:
> 
> Mogens Melander wrote:
> 
> > Could it be a bug in the 3.23.5 client ???
> > mysql> update transfer set yymmdd=(yy*10000)+(mm*100)+dd where yymmdd=0;
> > Query OK, 0 rows affected (48.76 sec)
> > Rows matched: 0  Changed: 0  Warnings: 0
> > mysql> select count(*) from transfer where yymmdd=0;
> > +----------+
> > | count(*) |
> > +----------+
> > |  1167765 |
> > +----------+
> > 1 row in set (15.69 sec)
> 
> Try to recheck your tables with isamchk -r. This seems like something is
> broken.
> 
> --
> +----------------------------------------------------------------+
> | TcX  ____  __     _____   _____  ___                           |
> |     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Tõnu Samuel           |
> |    /*/ /*/ /*/   \*\_   |*|   |*||*|     tonu@stripped        |
> |   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Tallinn, Estonia      |
> |  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                       |
> |  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                      |
> |             /*/             \*\                Developers Team |
> +----------------------------------------------------------------+
> 
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread26030@stripped
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-mogens=fumlersoft.dk@stripped>

-- 
Later
      Mogens Melander              mailto:mogens@stripped
      http://www.fumlersoft.dk     http://www.trader.dk
      http://www.birkerod.dk       http://tux.trader.dk
Thread
Update wierdnessMogens Melander1 Feb
  • Re: Update wierdnessTonu Samuel1 Feb
  • Re: Update wierdnessMogens Melander1 Feb
  • Re: Update wierdnesssasha1 Feb
  • Re: Update wierdnessMogens Melander2 Feb