On Wednesday 21 February 2007 17:01, Rolando Edwards wrote: > SHOW CREATE TABLE providers\G Hi Rolando: That doesn't do it on my machine (linux, ver 4.0.2) Here's what I see mysql> SHOW CREATE TABLE providers\G *************************** 1. row *************************** Table: providers Create Table: CREATE TABLE `providers` ( `ID` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '**', `nick_name` varchar(10) NOT NULL default '**', `email_address` varchar(80) NOT NULL default '**', `start_date` date NOT NULL default '0000-00-00', `company_ID` int(11) NOT NULL default '0', `status` int(6) default NULL, `modified` timestamp(10) NOT NULL, UNIQUE KEY `ID` (`ID`) ) TYPE=MyISAM 1 row in set (0.00 sec)
As you can see there is no reference info for column `status` thanks tim -- Tim Johnson <[EMAIL PROTECTED]> Palmer, Alaska, USA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]