A Gentle Introduction to

SQL

GISQ: How To: Use other databases/schemas

Please "Tidy up" after you have finished.

A particular server may support a number of different sets of tables. In Oracle these are schemas in MySQL they are databases. In both cases each user normally has their own set of tables, other users tables may be accessed using a dot notation.

Read tables from another schema/database
We use a dot notation.

oracle
access
mysql
Change the default schema/database.

oracle
access
mysql