Re: accessing enum
"Christopher G. Stach II" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.java |
|---|---|
| Message-ID | <[email protected]> |
Jon Drukman wrote:
>
> CREATE TABLE `file_sha1` (
> `id` int(10) unsigned NOT NULL default '0',
> `type` enum('dl','wm','qt','psp','hd','mp4') NOT NULL default 'dl',
> `sha1` char(40) NOT NULL default '',
> `path` char(100) NOT NULL default '',
> `size` int(10) unsigned NOT NULL default '0',
> PRIMARY KEY (`id`,`type`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
>
>
>
> mysql> select distinct(type) from file_sha1;
> +------+
> | type |
> +------+
> | dl |
> | wm |
> | qt |
> | psp |
> | hd |
> +------+
> 5 rows in set (0.21 sec)
>
>
> What else can I tell you?
>
> -jsd-
>
>
How is it being retrieved? :)
--
Christopher G. Stach II
--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe: http://lists.mysql.com/[email protected]