Radicore Forum: How To » Enum MySQL datatype

Home » RADICORE » How To » Enum MySQL datatype

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Enum MySQL datatype [message #30 is a reply to message #29]

Thu, 11 May 2006 07:57

johandewit
Messages: 25
Registered: May 2006
Location: Belgium

Junior Member

I didn't explain it too well I guess.
And it seems this is what you rty to make clear to me:

I have a table users and a table status.

Every user has at least one status. This could be eg

transfered to other site
retired
resigned
fired
working

This states have certain actions bound to them.

active
non-active

An active user has a different processing than non-active.
It is in the status table we have the enum field for action.

In this case we only have enum('active','non-active')
Since we need to write a different piece of code for each action, the use of the enum type in this case seems appropriate.

Report message to a moderator

[Message index]

		Enum MySQL datatype By: johandewit on Thu, 11 May 2006 04:04
		Re: Enum MySQL datatype By: AJM on Thu, 11 May 2006 04:55
		Re: Enum MySQL datatype By: johandewit on Thu, 11 May 2006 07:57
		Re: Enum MySQL datatype By: AJM on Thu, 11 May 2006 08:23

Next Topic:

//DebugBreak();

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue May 05 18:50:43 EDT 2026

Total time taken to generate the page: 0.04337 seconds