Re: How to define a required field in a table?

[bluejack]

On Tue, 28 Oct 2003 14:00:02 -0800, Kevin Fries <[EMAIL PROTECTED]> wrote:

That's not how it works.  The following demonstrates the feature I think
you want.
mysql test
test> create table testnull ( X varchar(10) not null );
Query OK, 0 rows affected (0.11 sec)
test> insert into testnull values ( null );
ERROR 1048: Column 'X' cannot be null
test>
One other case: If there is a default value on the column,
the default will be inserted instead of NULL.
-bluejack

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]