ENUM and php admin

[wolf73]

Hi, Creating database in mysql using php admin, if I pick the datatype Enum and the if I have values for enum 'view' and 'url'
. Where do i put these values. I mean would it be in Length/Values colum or attributes? Thanks

 

[synikal0]

Hi, I assume you're talking about phpMyAdmin.

For Enum column types, you put them in the following format in the Length/Values field: 'one','two'

-------------
Derek F.

http://www.convolutedtheory.com/

 

[wolf73]

thanks a lot, is it possible to create foreighn key primary key constraints (relation) using phpMYadmin?