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