newbie rasql questions
Carter Bullard
carter at qosient.com
Tue Jun 22 15:56:31 EDT 2010
So what are dups? How would they exist?
Carter
On Jun 22, 2010, at 3:51 PM, George Jones wrote:
> Thanks. That should do it.
>
> Also, is there a prescribed way to avoid dups w/o mucking with the table definition by hand ?
> I.e. define keys (-m ?) and then set to reject dups.
>
> Coming up the curve...
> ---George Jones
>
> On Tue, Jun 22, 2010 at 3:10 PM, Carter Bullard <carter at qosient.com> wrote:
> Hey George,
> rasqlinsert() supports the field "autoid" which should do the do for you. That is described
> in several places. Just put "autoid" in the "-s" command for the run. Once you have the
> schema you like, linking back to the fields is, of course, outside the scope of rasqlinsert().
>
> If you have any problems, holler, and send success or failure back to the list !!!
>
> Carter
>
> On Jun 22, 2010, at 8:41 AM, George Jones wrote:
>
> > Would like to load argus data into mysql, create unique id per record & create a second table with some derived
> > fields linking back to the original records. What's the best way to do this ?
> >
> > Thanks,
> > ---George Jones
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20100622/16520e29/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3815 bytes
Desc: not available
URL: <https://pairlist1.pair.net/pipermail/argus/attachments/20100622/16520e29/attachment.bin>
More information about the argus
mailing list