Re: Enum Type...

[Nick Scholtz]

I don't know if you're having specific issues with java/JDBC relating to
the ENUM type but I can try to explain the basics.

Sample table:

create table test_enum (column1 ENUM('string1','string2'));

Using the ENUM:

insert into test_enum(column1) values(null);

insert into test_enum(column1) values('string1');

insert into test_enum(column1) values('string2');

select * from test_enum;

should get you this:


mysql> select * from test_enum;
+---------+
| column1 |
+---------+
| NULL    |
| string1 |
| string2 |
+---------+
3 rows in set (0.00 sec)


You can also insert an empty string, and if you insert a value that is not allowed it
will be stored as an empty string:

insert into test_enum(column1) values('string3');

mysql> select * from test_enum;
+---------+
| column1 |
+---------+
| NULL    |
| string1 |
| string2 |
|         |
+---------+
4 rows in set (0.00 sec)


You can also try and get fancy and enter a number that corresponds to the string.

In this case

NUMBER -- Column Value
NULL --> NULL
   0 --> ''
   1 --> 'string1'
   2 --> 'string2'

so you could do the following:

delete from test_enum;  (to clear the table)

insert into test_enum(column1) values(0);
insert into test_enum(column1) values(1);
insert into test_enum(column1) values(2);

mysql> select * from test_enum;
+---------+
| column1 |
+---------+
|         |
| string1 |
| string2 |
+---------+
3 rows in set (0.00 sec)

Does that make it clear?


harsh wrote:
> 
> Hi i need some help in how to store and retrieve data
> from the ENUM type of mysql,i.e i want to keep an
> array of strings in ENUM type,i didn't understand the
> mysql ENUM quite clearly(lack of proper documentation)
> will someone make it clear ??
> 
> thanks
> with regards
> ------------------------------------------------------------------------------
> harsh
> http://www.cse.iitb.ac.in/~harsh
> ------------------------------------------------------------------------------
> 
> --
> MySQL Java Mailing List
> For list archives: http://lists.mysql.com/java
> To unsubscribe:    http://lists.mysql.com/java?unsub=1

-- 
Nick Scholtz
Planetary Data Systems