RE: 'select * where x is null' not working

2001-08-31 Thread Don Read
On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote: > Thanks for your quick response! More below.. > > Plus, all this just started happening yesterday, after everything worked > fine for many days. That leads me to believe there is a problem with a > corrupt table or something. How about t

RE: 'select * where x is null' not working

2001-08-31 Thread Jeremiah T. Folsom-Kovarik
Thanks for your quick response! More below.. > > mysql> select contact_info, expired from orders where order_num = '1'; > > +--+-+ > > | contact_info | expired | > > +--+-+ > > | NULL | NULL| > > +--+-+ > >

RE: 'select * where x is null' not working

2001-08-31 Thread Don Read
On 31-Aug-2001 Jeremiah T. Folsom-Kovarik wrote: > Weird things have just started happening in at least one table of my MySQL > 3.22.32 database. The symptoms are like this: > > mysql> describe orders; > +--+--+--+-+-+---+ >| Field| T

'select * where x is null' not working

2001-08-31 Thread Jeremiah T. Folsom-Kovarik
Weird things have just started happening in at least one table of my MySQL 3.22.32 database. The symptoms are like this: mysql> describe orders; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--