quick question

--0016e6da7ae36d5113049d528ebe
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e6da7ae36d5113049d528ebe--

Re: quick question

----- Original Message -----
> From: "Hervey Liu"
>
> 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=gcdmg-mysql-2@m.gmane.org