IF EXISTS UPDATE ELSE INSERT的语法错误 [英] Syntax error with IF EXISTS UPDATE ELSE INSERT

问题描述

我正在使用由ISP托管的MySQL 5.1.这是我的查询

I'm using MySQL 5.1 hosted at my ISP. This is my query

mysql_query("
IF EXISTS(SELECT * FROM licensing_active WHERE title_1='$title_1') THEN
    BEGIN
        UPDATE licensing_active SET time='$time' WHERE title_1='$title_1')
    END ELSE BEGIN
        INSERT INTO licensing_active(title_1) VALUES('$title_1')
    END   
") or die(mysql_error());  

错误是

... check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS(SELECT * FROM licensing_active WHERE title_1='Title1') THEN ' at line 1

我的实际任务涉及

WHERE title_1='$title_1' AND title_2='$title_2' AND version='$version' ...ETC...

但我已将其简化以简化解决问题的过程

but I have reduced it down to make things simpler for my problem solving

在对此进行搜索时，我不断看到对"ON DUPLICATE KEY UPDATE"的引用，但不知道该怎么做.

In my searches on this, I keep seeing references to 'ON DUPLICATE KEY UPDATE', but don't know what to do with that.

推荐答案

这是一个简单易用的解决方案，请尝试一下.

Here is a simple and easy solution, try it.

$result = mysql_query("SELECT * FROM licensing_active WHERE title_1 ='$title_1' ");

if( mysql_num_rows($result) > 0) {
    mysql_query("UPDATE licensing_active SET time = '$time' WHERE title_1 = '$title_1' ");
}
else
{
    mysql_query("INSERT INTO licensing_active (title_1) VALUES ('$title_1') ");
}

注意:尽管此问题来自2012年，但请记住，自PHP 7起， mysql _ * 函数不再可用.

Note: Though this question is from 2012, keep in mind that mysql_* functions are no longer available since PHP 7.

这篇关于IF EXISTS UPDATE ELSE INSERT的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！