<div>
&quot;DUAL is purely for the convenience of people who require that all SELECT statements should have FROM and possibly other clauses. MySQL may ignore the clauses. MySQL does not require FROM DUAL if no tables are referenced&quot;<br />
taken from dev.mysql.com<br />
<br />
whats your opinion on this?<br />
note that i cannot access that db right now or i would just try it - sorry.
</div>


"DUAL is purely for the convenience of people who require that all SELECT statements should have FROM and possibly other clauses. MySQL may ignore the clauses. MySQL does not require FROM DUAL if no tables are referenced"
taken from dev.mysql.com

whats your opinion on this?
note that i cannot access that db right now or i would just try it - sorry.

<div>
<div class="content wysiwyg-content">
don't work on mysql much but here goes:<br />
<br />
I'm trying to <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;insert into tbl<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(col1,col2)<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;select 'hello','world'<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;where not exists (select 1 from tbl where col1 = 'hello')<br />
<br />
get an error<br />
i know that on oracle (which i don't work on much either) one needs to select FROM DUAL<br />
is there a requirement like that on mysql or ???<br />
<br />
thanks
</div>
</div>


don't work on mysql much but here goes:

I'm trying to 
	insert into tbl
	(col1,col2)
	select 'hello','world'
	where not exists (select 1 from tbl where col1 = 'hello')

get an error
i know that on oracle (which i don't work on much either) one needs to select FROM DUAL
is there a requirement like that on mysql or ???

thanks

syntax problem i guess

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.