|
Posted by google on 09/21/05 23:13
Thanks for the reply.
>> I am using MySQL to keep a database containing tables 'merchants' and
>> 'products'.
> >My 'products' table has an auto-incrementing id for each record, other
> >fields, and a 'merchant' field.
>In other words, you decided not to use merchant's product numbering
>system? Is this wise?
do I not run the risk of having duplicate numbers as product_id ? It is
a primary key.
Is there a way of using the value of one field in a table to generate
the contents of another field in a seperate table ? Like in Excel ? Or
would this have to be scripted ?
Navigation:
[Reply to this message]
|