3 ms·
This is excellent. My only gripes have nothing to do with the execution of the training, only the terminology co-opted by MySQL. In MySQL, "schema" means the s
by ttfkam 4y ago
This is excellent. My only gripes have nothing to do with the execution of the training, only the terminology co-opted by MySQL.
In MySQL, "schema" means the structure of the whole database. In other RDBMSes, "schema" means a namespace within the database.
With its cross-database queries, MySQL puts no distinction between a database and a schema.
Once again, not a fault of the training here, but a common source of confusion I've run into between MySQL devs and folks working on other systems.
- berkle4455 4y agoIt's far easier if you view it this way: * Schema means the same thing on all RDBMS: a namespace for tables * MySQL doesn't support the notion of multiple databases per server installation
- ttfkam 4y agoThat's a more charitable way of viewing it. Thank you.