Re: alter table .... add constraint

[REMI VERVECKEN]

mysql> show create table os;
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------------------+
| Table | Create Table



|
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------------------+
| os | CREATE TABLE `os` (
`idOS` int(11) NOT NULL,
`OS` varchar(45) NOT NULL,
`createdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TI
MESTAMP COMMENT 'creation date of data',
`modifydate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'modify
date of data',
PRIMARY KEY (`idOS`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Operating system table' |
+-------+-----------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-----------------------------------------------------------------------------+
1 row in set (0.00 sec)

-------------------------------------------------
Computer Technology Support & Consulting
www.ctsc.de