"chris_huh" <chris.huh@gmail.com> wrote:

> Is it possible to have 'folders' within a mysql database that holds
> separate tables. I want to be able to have several sites from
> subdomains to access a single database but each site will need to
> access tables of the same name.

MySQL uses the term "database" (nowadays "schema") in an unusual way.
But in fact MySQLs databases are exactly what you're looking for.

> Is the only way to do this to have a different database for each, as
> that would start to get expensive.

Why?


XL
--
Axel Schwenke, Senior Software Developer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/