:01 PM
To: whiskyworld.de
Cc: MySql Lists Geral (E-mail); MyODBC
Subject: Re: Tables in MySQL
Don't do it this way. Do something like the following:
Assume two tables, "transaction" and "itemlist".
transaction
---
transaction_id
customer_id
purchase_da
Putting the efficiency issues aside to the extent we already have, I don't
see why you can't just use a simple join table for this purpose. You do have
the minor complication of symmetry, but with a simple ordering operation
against your original insertion join even this can be overcome.
Let's wri
Don't do it this way. Do something like the following:
Assume two tables, "transaction" and "itemlist".
transaction
---
transaction_id
customer_id
purchase_date
whatever other junk is relevant to a given transaction...
itemlist
transaction_id
item
