A USE statement switches the current database for the session. After switching, queries can refer to tables without repeating the database prefix. section 7.3.1
Switch, then query
After attaching the remote countries database, run `USE countries;`, then query `FROM cities;`. The unqualified table name resolves in the selected database. You can verify the active database with `SELECT current_database();`. section 7.3.1 section 7.3.2
Creating a database does not select it automatically. Switch to the intended database before creating tables or querying data; switch away before dropping it. section 7.3.2
USE countries; #1 FROM cities;
Shows the compact workflow: select countries, then query cities without a database prefix. section 7.3.1
