Re: insert using subquery

[Quoted] 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
[Quoted] as in RTFM (Read the *free* manual)

(see:https://en.wikipedia.org/wiki/RTFM ) Received on Sat Aug 13 2016 - 17:20:51 CEST