Am 10.10.2015 um 16:28 schrieb Richard Reina:
If I were keeping tract of high school sports statistics and thus designed the following tables:sports, rules, statistical definitions and players, teams, games Would it be a good or bad idea to put the first set of tables in a separate database called "library" since they are used for reference and rarely change? What would be the pros and cons of using two different databases?
it makes zero sense since you can use different users for the same database down to table and even column permissions
with default (crap) settings innodb anyways stores all in the same big file, and file_per_table is, well, per table
signature.asc
Description: OpenPGP digital signature
