3 ms·
I've seen MySQL clients/docs also use "schema" to refer to "this collection of tables", basically what SQLite would call "a database". The words get really fuz
by ubertaco 3y ago
I've seen MySQL clients/docs also use "schema" to refer to "this collection of tables", basically what SQLite would call "a database".
The words get really fuzzy here when you try to get a concrete and ubiquitous definition, though.
Best I can do is to say, in these queries:
use foo;
select id, name from foo.people where id < 10;
..."foo" is the schema in MySQL and, apparently, Postgres parlance.