This is excellent. My only gripes have nothing to do with the execution of the t... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

ttfkam on March 21, 2023 | parent | context | favorite | on: MySQL for Developers

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 on March 21, 2023 [–]

It'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 on March 22, 2023 | [–]

That's a more charitable way of viewing it. Thank you.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact