hello
i am a noob in general
i just want to double check
can someone perhaps send me a screen shot of how the following data will
look in a mysql table
;
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,
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)
thank you
hervey
Comments
Re: quick question
By Johan De Meersman at 03/01/2011 - 03:29For 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 :-)