Andris Spruds wrote: > > Hello MaxDB list, > > I have problems understanding the correct syntax of a > particular UPDATE > statement. The query, which seems a pretty standard query for > me, does not > work: > > 'update ar_comments c set c.author = (select u.username from > users u where > u.id = c.author_id)'. >
As ansered several times: DO NOT USE a tablename in the SET-clause of an UPDATE-statement, use just the columnname. It does not matter if an alias or view-/tablename is written there, something in front of the columnname will always cause a syntax-error. In the reference manual it is described that only the columnname is allowed there. Elke SAP Labs Berlin > It complains about '-5016 Missing delimiter:='. The query, > however, executes > just fine if 'c.author' is replaced with just 'author'. Is > this a bug or > more likely, it's just my wrong understanding of SQL? > > Best regards, > Andris Spruds > > > > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
