----- Original Message ----- > From: "Hervey Liu" <herve...@buffalo.edu> > > CREATE TABLE logins ( > success > enum('Y','N[banned]','N[password]','N[panic]','N[activation]','N[authorization]') > DEFAULT 'Y' NOT NULL, > when datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, ^^^^ This is going to be an issue when querying. Avoid using reserved words as column names whenever possible.
> browser varchar(255) NOT NULL, > ipaddress varchar(20) NOT NULL, > activity enum('user','quote','liquidate','manage','finale') DEFAULT > 'quote' NOT NULL, > userid int(10) unsigned NOT NULL, > symbolid int(10) unsigned, > PRIMARY KEY (when, userid) For the rest, that isn't data, so it won't "look" like anything quite so much as an empty table. Just execute the statement and have a look :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org