At 19:44 -0600 3/5/04, Mulugeta Maru wrote:
Table structure:

CREATE TABLE `players` (
  `PLAYERNO` smallint(6) NOT NULL default '0',
  `NAME` char(15) NOT NULL default '',
  `INITIALS` char(3) default NULL,
  `YEAR_OF_BIRTH` smallint(6) default NULL,
  `SEX` char(1) default NULL,
  `YEAR_JOINED` smallint(6) NOT NULL default '0',
  `STREET` char(15) NOT NULL default '',
  `HOUSENO` char(4) default NULL,
  `POSTCODE` char(6) default NULL,
  `TOWN` char(10) NOT NULL default '',
  `PHONENO` char(10) default NULL,
  `LEAGUENO` char(4) default NULL,
  PRIMARY KEY  (`PLAYERNO`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

What is your question?


--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/

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



Reply via email to