mysql 枚举错误 : 1067 what is the mistake?

Question

Errore
query SQL:

CREATE TABLE  `hospital_jqm`.`users` (

`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 80 ) NOT NULL ,
`surname` VARCHAR( 80 ) NOT NULL ,
`address` VARCHAR( 80 ) NOT NULL ,
`birth_place` VARCHAR( 50 ) NOT NULL ,
`province` VARCHAR( 5 ) NOT NULL ,
`birth_date` DATE NOT NULL ,
`sex` ENUM(  'male',  'female' ) NOT NULL DEFAULT  '''male''',
`case` ENUM(  'politrauma',  'cardiologico',  'neurologico' ) NOT NULL DEFAULT      '''politrauma'''
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

 Messaggio di MySQL: 

 #1067 - Invalid default value for 'sex' 

我尝试创建此表但收到此错误。为什么？错误在哪里？

Answer 1

'''male''' 应该是 'male'。