Field constraints within tables

[rbeech23]

I've a create statement with a field which reads
creat table field1,field2 etc,`Gender` enum('Male','Female') NOT NULL default 'Male'

The problem I have with the Gender field is I can update values and set Gender to '' which I dont want, I thought the enum option would prevent anything other than Male or Female being inserted as a value.

Any help appreciated

Thanks

 

[swampBoogie]

Yes, that would be my opinion as well. As far as I can see there is no way round this.

You can get the rows where gender contains '' by using the query

select * from t where gender = 0

In general, Mysql stinks with regard to data integrity.