Re: how to select only NOT NULL fields ?

2001-12-26 Thread gaouzief
"is NOT NULL" in the whare close 26/12/2001 16:46:44, Gilles Missonnier <[EMAIL PROTECTED]> wrote: >Hi ! > >I need a help on the syntax. > >My table has over 100 different fields: I want to display only the >"NOT NULL" fields and also the names of these "NOT NULL" fields. > >so the simple mysql

how to select only NOT NULL fields ?

2001-12-26 Thread Gilles Missonnier
Hi ! I need a help on the syntax. My table has over 100 different fields: I want to display only the "NOT NULL" fields and also the names of these "NOT NULL" fields. so the simple mysql command : mysql> select * from tabID where tabID.login='john'; returns a long ... long line, with many item