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

Creating a database in MySQL

schedule Aug 12, 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 use the following syntax to create a database with name database_name in MySQL:


        
        
            
                
                
                    CREATE DATABASE database_name;

Example

To create a database called people:


        
        
            
                
                
                    CREATE DATABASE people;
                
            
            Query OK, 1 row affected (0.01 sec)

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!