douliu7929 2014-05-27 19:48
浏览 41
已采纳

PHP:防止Mysql中的重复标记

I have MySql Table For Tags Like This:

| id |   name    |
| 1  |   Linux   |
| 2  |  Windows  |
| 3  |   Unix    |
| 4  |    Dos    |
| 5  |  FreeBSD  |

In News Page User add New Tags Like This:

Linux,OpenBSD,Test 

Now, Linux Previously added, So I need To add ONLY OpenBSD and Test Into Tags Table. My Mean Is: how to INSERT tags if User tags is New?!

  • 写回答

2条回答 默认 最新

  • duanchun1852 2014-05-27 19:54
    关注
    1. Put a UNIQUE constraint on the name column.
    2. Use INSERT IGNORE so that inserting a column where name already exists simply skips that row. eg:

      INSERT IGNORE INTO tags (name) VALUES ('Linux'), ('OpenBSD'), ('Test');
      
    3. Because you have different casings in your data [eg: linux vs Linux] you either need to make sure that you are using a case-insensitive coallation in your database like utf8_latin1_ci [ci stands for case-insensitive] or be sure to use strtolower() on your data prior to inserting it.
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 完成虚拟机环境配置,还有安装kettle
  • ¥15 有人会搭建生鲜配送自营+平台的管理系统吗
  • ¥15 用matlab写代码
  • ¥30 motoradmin系统的多对多配置
  • ¥15 求组态王串口自定义通信配置方法或代码?
  • ¥15 实验 :UML2.0 结构建模
  • ¥20 用vivado写数字逻辑实验报告撰写,FPGA实验
  • ¥15 为什么shp文件会有这种小方块?
  • ¥15 ecplise在连接数据库时显示加载驱动成功但是数据库连接失败
  • ¥15 visionmaster启动失败,提示为“机器不满足授权而被禁用”