Re: tmp tables

[Baron Schwartz]

Victor,

> That strikes me as messy. Each tmp table has as many rows as necessary for
> the products that are to be bough. To do as you say I would have to create a
> table with a zillion rows to accommodate however many products I *predict*
> buyers would buy. Therefore, I guess I should probably create a new database
> so as to not make a mess of the main database.

You fundamentally misunderstand relational database design.  I suggest
reading this book:
http://www.xaprb.com/blog/2009/08/22/a-review-of-beginning-database-design-by-clare-churcher/

Regards,
Baron

-- 
Baron Schwartz
Percona Inc: Services and Support for MySQL
http://www.percona.com/