I understand the consciousness of buying this sentence
ALTER TABLE goods ADD UNIQUE (`goods`,`price`,`spec`,`location`,`purchaseTime`,`comments`); the following statement comes from
CREATETABLE`secure_vulnerability_warning`(
`id`int(10)NOTNULLauto_increment,
`date`dateNOTNULL,
`type`varchar(100)NOTNULL,
`sub_type`varchar(100)NOTNULL,
`domain_name`varchar(128)NOTNULL,
`url`textNOTNULL,
`parameters`textNOTNULL,
`hash`varchar(100)NOTNULL,
`deal`int(1)NOTNULL,
`deal_date`datedefaultNULL,
`remark`text,
`last_push_time`datetimedefaultNULL,
`push_times`int(11)default"1",
`first_set_ok_time`datetimedefaultNULL,
`last_set_ok_time`datetimedefaultNULL,
PRIMARYKEY(`id`),
UNIQUEKEY`date`(`date`,`hash`)
)ENGINE=InnoDBDEFAULTCHARSET=utf8 where the sentence UNIQUE KEY date ( date , hash ), I don"t understand why
is not
UNIQUEKEY(`date`,`hash`)