Mysql重複記録回避ソリューション

重複記録の回避

--   ID      
INSERT INTO tu_tags (name) VALUES ("  ") ON DUPLICATE KEY UPDATE num=num+1;

INSERT INTO tu_tags (name) VALUES ("  bbbbbb") ON DUPLICATE KEY UPDATE num=num+1;

--   ID      
insert ignore into tu_tags(name) values('  ccccccccc')

--            
replace into tu_tags(name) values("  ccccccccc")