Dynamic Tables

    Date: 09/05/07 (MySQL Communtiy)    Keywords: software, database, shopping

    A friend of mine uses an interesting technique that I'm curious about. In addition to the initial database tables, his software (scripts, program, whatever) adds and deletes additional tables as needed to store other mostly temporary information. For example, with a shopping cart, he adds a temporary table for each user to have their own table with the items they've added.

    I'm really not too keen on doing things this way. Is anything even remotely like this common and/or good practice?

    Source: http://community.livejournal.com/mysql/118152.html

« Simple DB Design Question || Identifying duplicate rows... »


antivirus | apache | asp | blogging | browser | bugtracking | cms | crm | css | database | ebay | ecommerce | google | hosting | html | java | jsp | linux | microsoft | mysql | offshore | offshoring | oscommerce | php | postgresql | programming | rss | security | seo | shopping | software | spam | spyware | sql | technology | templates | tracker | virus | web | xml | yahoo | home