Wang,
select * from t1 where ordno>=' '
gets wrong result 2 rows
I doubt you'll get many helpful responses till you post the INSERTs.
PB
-
wang shuming wrote:
Oh,
If any char fields add to index key ,then the >=' ' gets wrong .
ordno, qty ,mem
1
3
Oh,
If any char fields add to index key ,then the >=' ' gets wrong .
ordno, qty ,mem
1
3
5
aaa18
b 20
1. CREATE TABLE `t1` (
`mid` int(11) NOT NULL,
`qty` decimal(12,2) NOT NULL DEFAULT '0.00',
`ordno` char(8) NOT NULL DEFA
In the last episode (Mar 04), wang shuming said:
> select * from t1
>
> ordno qty
> 1
> 3
> 5
> 'aaa' 18
> 'b' 20
Are your first three rows really blank, or are there nonprintable characters
in 'ordno' that aren't showing up here?
You need to provi
Hi,
select * from t1
ordno qty
1
3
5
'aaa' 18
'b' 20
select * from t1 where ordno=' ' or ordno>' '
ordno qty
1
3
5
'aaa' 18
'b' 20
select * from t1 where ordno>=' '
ordno qty
'aaa' 18
'b'
