Re: insert using subquery

From: bill <william_at_TechServSys.com>
Date: Sun, 14 Aug 2016 06:41:21 -0400
Message-ID: <nophsl$460$1_at_gioia.aioe.org>

On 8/13/2016 11:20 AM, Luuk wrote:
> On 13-08-16 13:49, bill wrote:

>>
>>>> Try:
>>>> INSERT INTO `pendingInsBillings`(`transNum`)
>>>> (SELECT `transNum` FROM `transactions`
>>>> where
>>>> `description` LIKE 'Quality Reporting%')
>>>>
>>>>
>>>
>>> Because the keyword VAULES is not used in the third form that is
>>> shown here:
>>> http://dev.mysql.com/doc/refman/5.7/en/insert.html
>>>
>>>
>> That worked, sorta like magic.
>> Thanks Wizard Luuk
>>
>> bill
>

> It has a name,
> It's called documentation
> or, as some others name it, manual
> as in RTFM (Read the *free* manual)
>
> (see:https://en.wikipedia.org/wiki/RTFM )

Ah yes, but the magic in this case is knowing what part of the documentation to use.

bill Received on Sun Aug 14 2016 - 12:41:21 CEST