MySql Where-Subquery syntax error -


This code works in SQL, in which I have more experience. I can not understand what is wrong here. If it is posted with section 1, where body = 'a'; I do not give a syntax error, but it selects

  1, where is not the first (post from selection 1 where body = 'A');  

Code:

  Enter in the 'post' (`name`, ... 'date') @ 0, ... @ 6's Select WHERE does not exist (Choose where body is selected = 7 @)  

error

  does not exist (from where to post 1 Select body body = 'text' 15 'on line 15  
"post-text" itemprop = "text">

Dual use as dummy table in your selection Try it (see).

  Select INSERT @ post, ('name', ... 'date') @ 0, ... @ two from where, Not present Only (from which to select the post from 1 where from the referenced link: 

You are allowed to specify the dual as a dummy table name, where no table is referenced :

mysql> Select 1 + 1 from Dual; -> 2


Comments