It might be easier to see what is happening if you do something like this:
echo "select name from pairings where fid=0 and pid=1 and name != 'One';" |
mysql -u... -p... yourdatabase | hexdump -c
this will show you exactly what data is being returned. Chances are there is
a funky character in there somewhere.
dpk
----- Original Message -----
From: "Philip Mak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 08, 2001 2:18 PM
Subject: Weird table corruption?
> Does anyone know what happened here? Notice the strangely formatted
> output from the second command. I did a "repair table" but it doesn't
> seem to detect any table corruption.
>
> mysql> repair table pairings;
> +-------------------+--------+----------+----------+
> | Table | Op | Msg_type | Msg_text |
> +-------------------+--------+----------+----------+
> | shoujoai.pairings | repair | status | OK |
> +-------------------+--------+----------+----------+
> 1 row in set (0.01 sec)
>
> mysql> select name from pairings where fid=0 and pid=1 and name !=
> 'One';
> +------+
> | name |
> +------+
> |Two
> +------+
> 1 row in set (0.01 sec)
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
