Re: QUERY

On Tue, Mar 13, 2012 at 1:26 PM, Rory Campbell-Lange
<rory@campbell-lange.net> wrote:
> On 13/03/12, anderson earley (anderson_earley@yahoo.com) wrote:
>> I need a script that parses a provided users.txt, then it needs to
>> look for users in 'NEW USERS' table and move any to their 'intended'
>> group.
>
> That is not a terribly helpful description of what you want to do, as
> you haven't provided many details.
>
> Do you mean you need to run an SQL statement along the lines of:
>
>    INSERT INTO group_users
>        (person_id, group_id)
>    VALUES
>        (pid, gid);
>
> and you want to work out how to generate that sort of statement from a
> text file containing (presumably) the equivalent of 'pid' and 'gid'?

you are apparently unaware of my 'parse any file into any intended
location' script.

merlin