"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
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