In the last episode (Mar 04), wang shuming said:
> select * from t1
>
> ordno qty
> 1
> 3
> 5
> 'aaa' 18
> 'bbbbb' 20
Are your first three rows really blank, or are there nonprintable characters
in 'ordno' that aren't showing up here?
You need to provide us with the table definition and the insert statements
needed to create the t1 table and its data. Can you attach the output of
"mysqldump --skip-opt mydb t1" ?
> select * from t1 where ordno=' ' or ordno>' '
> ordno qty
> 1
> 3
> 5
> 'aaa' 18
> 'bbbbb' 20
>
> select * from t1 where ordno>=' '
> ordno qty
> 'aaa' 18
> 'bbbbb' 20
>
> mysql version 5.1.44 still with the bug
>
> Best regards!
> Shuming Wang
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
