MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftDatabase Cookbook

Checking size of databases Accessing tables in other databases Removing databases Showing current database Selecting databases Creating a database Showing all databases Importing an SQL file using the command line

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

Selecting databases in MySQL

schedule Aug 11, 2023

Last updated

local_offer

MySQL

Tags

tocTable of Contents

expand_more

Example

mode_heat

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

We can select a database to use using the below syntax in MySQL:


        
        
            
                
                
                    USE database_name;

Example

To select a database called people:


        
        
            
                
                
                    USE people;
                
            
            Database changed

In MySQL jargon, we say that the database people is now our default database (i.e. a database that is currently in use).

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!