Database Related Commands
Rasika Priyadarshini
Created on November 1, 2023
Over 30 million people create interactive content in Genially.
Check out what others have designed:
SANTIAGOVR_EN
Presentation
WWII TIMELINE WITH REVIEW
Presentation
BLENDED LEARNING
Presentation
TAKING A DEEPER DIVE
Presentation
WWII JUNE NEWSPAPER
Presentation
AUSSTELLUNG STORYTELLING
Presentation
HISTORY OF THE EARTH
Presentation
Transcript
DATABASE RELATED COMMANDS
go!
The CREATE DATABASE statement is used to create a new SQL database. Syntax CREATE DATABASE databasename;
The SQL CREATE DATABASE Statement
VIEW YOUR DATABASEOnce a database is created, you can check it in the list of databases with the following SQL command: Syntax SHOW DATABASES;
The SQL DROP DATABASE StatementThe DROP DATABASE statement is used to drop an existing SQL database. Syntax DROP DATABASE databasename;
The USE statement This tells MySQL to use the named database as the default (current) database for subsequent statements. SyntaxUSE db_name