Example:
CREATE TABLE rassen (
id smallint(5) unsigned NOT NULL auto_increment,
bezeichnung varchar(50) NOT NULL,
kurz varchar(25) NOT NULL,
total smallint(5) unsigned DEFAULT '0' NOT NULL,
totalDeck tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY id (id, bezeichnung),
KEY kurz (kurz),
KEY totalDeck (totalDeck)
);
[EMAIL PROTECTED] schrieb am Freitag, 27. Juli 2001, 06:47:50:
> I am having trouble setting a column attribute to not null. Below is the
> statement I am using:
> create table table_name (
> Column_Name not null
> );
> If this is not the correct way to do it, can someone please help me...this is
> my first mysql database.
> Thank you.
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
