how to define new dataypes

#1 (**permalink**) 02-28-2008, 08:58 AM

Hello,

I would like to define a new datatype, the datatype gender should only
include either m or f. how can i do this?

thank you very much,

dennis

#2 (**permalink**) 02-28-2008, 08:58 AM

On Mon, 24 Jul 2006 11:10:11 +0800, Dennis Kuntzemann wrote:
> Hello,
>
> I would like to define a new datatype, the datatype gender should only
> include either m or f. how can i do this?

See "Enumerated Type" http://dev.mysql.com/doc/refman/5.0/en/enum.html
for information as to how to do this.

--
Whenever you look at a beautiful woman,
always remember that somewhere, someone is tired of her.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode