Duplicate records in mysql why?

Question

MySQL

Good afternoon, there is a base

Structure of its

Request

INSERT INTO s_products (url,name,brand_id,meta_title,meta_keywords,meta_description)
VALUES ((SELECT max(product_id) FROM s_products_categories),'%Название%','0','%Название%','%Название%','%Название%')
ON DUPLICATE KEY UPDATE `url` = (SELECT product_id FROM s_products_categories),

`name` = '%Название%',

`brand_id` = '0',

`meta_title` = '%Название%',

`meta_keywords` = '%Название%',

`meta_description` = '%Название%'

How to make sure that when adding a record, the name is not duplicated.??

Answer 1

Make the 'name' field unique.