MySQL Lists: mysql: NOT EMPTY, like NOT NULL

List:	General Discussion	« Previous Message Next Message »
From:	js	Date:	February 12 2007 2:48pm
Subject:	NOT EMPTY, like NOT NULL
View as plain text

Hi list,

A silly question.
Is it possible to prevent empty value('') from appearing in a field?

I can solve this by using subquery or trigger,
but it's a little bit painful.
The simpler the better :)

Thanks.

Thread
• NOT EMPTY, like NOT NULL	js	12 Feb
• Re: NOT EMPTY, like NOT NULL	Rolando Edwards	12 Feb
• Re: NOT EMPTY, like NOT NULL	js	12 Feb
• RE: NOT EMPTY, like NOT NULL	Jerry Schwartz	12 Feb
• Re: NOT EMPTY, like NOT NULL	Nils Meyer	12 Feb
• Re: NOT EMPTY, like NOT NULL	js	13 Feb
• Re: NOT EMPTY, like NOT NULL	C.R.Vegelin	12 Feb