<div>
Thanks man. &nbsp;mySQL won't let you do a subquery on the same table, but the FROM DUAL worked like a charm.
</div>


Thanks man.  mySQL won't let you do a subquery on the same table, but the FROM DUAL worked like a charm.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I am trying to do a conditional INSERT based on whether a product # already exists in my table.<br />
Does anyone know how to do this? &nbsp;I have tried several options, including the EXISTS and IF clauses, but it keeps throwing a syntax error. &nbsp;Here's what I've tried so far:<br />
<br />
INSERT INTO products ( productNum, price )<br />
VALUES (12345, 100)<br />
WHERE NOT EXISTS ( SELECT * FROM products WHERE productNum=12345 )<br />
<br />
and...<br />
<br />
IF NOT EXISTS ( &nbsp;SELECT * FROM products WHERE productNum=12345 )<br />
THEN INSERT INTO products ( productNum, price )<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VALUES (12345, 100)<br />
END IF<br />
<br />
<br />
Any ideas?<br />

</div>
</div>


Hello,

I am trying to do a conditional INSERT based on whether a product # already exists in my table.
Does anyone know how to do this?  I have tried several options, including the EXISTS and IF clauses, but it keeps throwing a syntax error.  Here's what I've tried so far:

INSERT INTO products ( productNum, price )
VALUES (12345, 100)
WHERE NOT EXISTS ( SELECT * FROM products WHERE productNum=12345 )

and...

IF NOT EXISTS (  SELECT * FROM products WHERE productNum=12345 )
THEN INSERT INTO products ( productNum, price )
           VALUES (12345, 100)
END IF


Any ideas?


MySQL conditional INSERT

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.