From: Steffan A. Cline (steffanhldns.com)
Date: Sat Jul 14 2007 - 21:18:05 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Mogens ,

forum_id is a primary auto increment key therefore it's unlikely that there
would be a dupe. I can see there being an error if there is a dupe but in
this case there is not.

Is it really necessary to do this:

set x = (select forum_subject from forums where forum_id=3 );

insert into forums
(project_id, forum_reply_id, forum_dev_id, forum_subject, forum_message)
values
(42, 6, 1, x, "I figured this one needed a reply too.");

?

Thanks

Steffan

---------------------------------------------------------------
T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
SteffanExecuChoice.net Phoenix, Az
http://www.ExecuChoice.net USA
AIM : SteffanC ICQ : 57234309
                                  Lasso Partner Alliance Member
---------------------------------------------------------------

> From: Mogens Melander <mogensfumlersoft.dk>
> Date: Sun, 15 Jul 2007 04:02:18 +0200 (CEST)
> To: "Steffan A. Cline" <steffanhldns.com>
> Cc: <mysqllists.mysql.com>
> Subject: Re: New error to me...
>
>
> On Sun, July 15, 2007 03:53, Steffan A. Cline wrote:
>> I was trying to reduce a set of queries and ran into this:
>>
>>
>> insert into forums (forum_reply_id, forum_dev_id, forum_subject,
>> forum_message) values (0, 1, (select forum_subject from forums where
>> forum_id=3 ), "I figured this one needed a reply too.")
>
> Your subselect "could" return more than one row, and because of that,
> can't be used in a direct insert/update.
>
>>
>> yields:
>>
>> error: You can't specify target table from 'forums' for update in from
>> clause
>>
>> I read somewhere online when they referenced 4.x that said you cannot do
>> subqueries in an update. Is this true of 5.x ?
>>
>> Thanks
>>
>> Steffan
>>
>> ---------------------------------------------------------------
>> T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7 1 . 1 6 9 4
>> Steffan A. Cline
>> SteffanExecuChoice.net Phoenix, Az
>> http://www.ExecuChoice.net USA
>> AIM : SteffanC ICQ : 57234309
>> Lasso Partner Alliance Member
>> ---------------------------------------------------------------
>>
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=mogensfumlersoft.dk
>>
>>
>> --
>> This message has been scanned for viruses and
>> dangerous content by MailScanner, and is
>> believed to be clean.
>>
>
>
> --
> Later
>
> Mogens Melander
> +45 40 85 71 38
> +66 870 133 224
>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=steffanhldns.com
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]