MySQL Performance: MySQL => Table/Column Layout for multiple pricing

Members

Help

Home

Home » Performance » MySQL » Table/Column Layout for multiple pricing

Show: Today's Messages :: Show Polls :: Message Navigator

Table/Column Layout for multiple pricing [message #3184]

Tue, 17 June 2008 00:29

Jeremyreger
Messages: 1
Registered: June 2008

Junior Member

Hello all,
I am wanting to structure a database that will allow for multiple prices per products. I also want to be able to upload an image and enter details about the product.

My initial thought would be to have a product_db and have a price table, a product table, and a description table all linked together with product id's

I am lost...

I would really appreciate your help on the table and column layout for achieving the mulitple pricing...

Report message to a moderator

Previous Topic:	LIMIT starting at high row count very slow
Next Topic:	Date field index not working when using > operator

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 9 20:48:33 EDT 2009

Total time taken to generate the page: 0.00903 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.