请问mysql的有关问题

WBOY

Release： 2016-06-13 13:35:15

Original

834 people have browsed it

请教mysql的问题
想只用sql而不用php代码实现如下功能：如果一条记录存在返回其id,如果不存在，插入并返回其id,可以实现吗？如何实现？望各位大侠详细指教

------解决方案--------------------
执行insert into table () values () on duplicate key update ……

那么mysql_insert_id() 返回就是自增id

不过mysql_insert_id可是php函数哦
------解决方案--------------------

SQL code

INSERT IGNORE INTO table () VALUES (); <div class="clear">
                 
              
              
        
            </div>

Copy after login

Related labels：

insert mysql table

source：php.cn

Previous article：关于PHP重定向解决方法 Next article：关于一个博客的功能代码,该如何处理

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn