Re: updating many-to-many relationships?

2003-02-20 Thread gerald_clark
I don't have a mailing list, and I don't appreciate your email. You subscribed to the mysql mailing list, or you would not be getting it. The instructions to unsubscribe are at the bottom of every message. Kip McGee wrote: will you please take me off of your mailing list if you dont im gonna

updating many-to-many relationships?

2003-02-19 Thread Paul Chvostek
Hi all. I need some help figuring out how to update a many-to-many relationship from a text file. For the fun of it, let's call the tables 'sku' and 'agent'. Each sku can have multiple agents (usually 10, always 0), and each agent can be associated with an unlimited number of records skus.

Re: updating many-to-many relationships?

2003-02-19 Thread gerald_clark
Looks to my like skuagent should be using the varchar fields instead of the int fields. Then you could just insert ignore each line from your test file. Paul Chvostek wrote: Hi all. I need some help figuring out how to update a many-to-many relationship from a text file. For the fun of it,

Re: updating many-to-many relationships?

2003-02-19 Thread Paul Chvostek
I *really* don't want to have a pair of indexes on 60-character varchars that cover forty million records. That would increase the size of each index from 280MB to 4.8GB. Just for the indexes. I don't think so. Also, I don't see how it would address the issue of updates. The problem is that