Re: insert using subquery

From: Luuk <luuk_at_invalid.lan>
Date: Sun, 14 Aug 2016 16:58:33 +0200
Message-ID: <57b08711$0$832$e4fe514c_at_news.xs4all.nl>

On 14-08-16 12:41, bill wrote:

> 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
>

not really, because when you start your browser, and go to 'google.com'
and type 'inert into mysql'
(because you are doing 'INSERT INTO', and you use 'MYSQL'

google will even comlains that you forgot to type the 's' of 'insert' :) and, in my case, the first link found is the one mentioned above. Received on Sun Aug 14 2016 - 16:58:33 CEST