Thread: Check values
View Single Post
  #1 (permalink)  
Old March 14th, 2006, 09:37 AM
Dj Kat Dj Kat is offline
Friend of Wrox
 
Join Date: Nov 2005
Location: Rotterdam, , Netherlands.
Posts: 223
Thanks: 0
Thanked 0 Times in 0 Posts
Default Check values

Hi,

I need to a contraint for a field,
I tried this line in a create table command
Code:
 project_klasse              char(5) NOT NULL default ''CHECK IN('A','B','C','D'),
This would only allow values a,b,c and d for project_klasse

does anyone know if this is possible in mysql if so what is the right synstax

__________________________________________________ ________
This is my junk I'm gona eat it
Reply With Quote