<div>
the uniqueness is determined by a combo of userid and testname<br />
<br />
i need the syntax<br />
the code i would use on sql server is appearing to fail<br />
<br />
what i'd normally use is something like<br />
INSERT INTO sometbl<br />
(x,y)<br />
SELECT 'x','y'<br />
WHERE NOT EXISTS (Select 1 from sometbl where x='x' and y='y')<br />
<br />
thanks
</div>


the uniqueness is determined by a combo of userid and testname

i need the syntax
the code i would use on sql server is appearing to fail

what i'd normally use is something like
INSERT INTO sometbl
(x,y)
SELECT 'x','y'
WHERE NOT EXISTS (Select 1 from sometbl where x='x' and y='y')

thanks

<div>
ok - thanks a lot guys<br />
i will test it later - i cant right now
</div>


ok - thanks a lot guys
i will test it later - i cant right now

<div>
<div class="content wysiwyg-content">
what is the syntax to insert a record only if the record doesn't already exist?<br />
say its based on a column named 'testname'
</div>
</div>


what is the syntax to insert a record only if the record doesn't already exist?
say its based on a column named 'testname'

insert to mysql table

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.