FAQ
Hi,

I've got an error message from MySQL 5.0 that I don't understand.

UPDATE "message_revision" SET "HasData" = 1, "Data" = (SELECT "Data"
FROM "message_revision" WHERE "MessageId" = 7 AND "RevisionNumber" = 5)
WHERE "MessageId" = 7 AND "RevisionNumber" = 6

SQL error: [SQLSTATE:HY000, 1093] You can't specify target table
'message_revision' for update in FROM clause

What went wrong?

--
Yves Goergen "LonelyPixel" <nospam.list@unclassified.de>
Visit my web laboratory at http://beta.unclassified.de

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 8 | next ›
Discussion Overview
groupmysql @
categoriesmysql
postedFeb 5, '08 at 4:26p
activeFeb 7, '08 at 11:06a
posts8
users4
websitemysql.com
irc#mysql

People

Translate

site design / logo © 2021 Grokbase