From: Jeff Smelser
Date: February 8 2005 9:44pm
Subject: Re: default values
List-Archive: http://lists.mysql.com/mysql/179594
Message-Id: <200502081544.06011.tradergt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed;
  boundary="nextPart3436006.XDKJbO4xoG";
  protocol="application/pgp-signature";
  micalg=pgp-sha1
Content-Transfer-Encoding: 7bit

--nextPart3436006.XDKJbO4xoG
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:

> is it possible to force a field to be NOT NULL but not
> have any default value (I.E the insert statement must
> explicitly provide data for the field in question)?

of course: col1 int not null

Jeff

--nextPart3436006.XDKJbO4xoG
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQBCCTKloOk9EvUvEtgRAsRjAKDdLoFiQ9ka4qcqvFXrjgVrl1lTxACgjNGV
FN/otk2hXhX5/0qZr65LaO4=
=ZF5d
-----END PGP SIGNATURE-----

--nextPart3436006.XDKJbO4xoG--