Create Database in MySQL || MySQL Tutorial For Beginners In Hindi || AppWeb Coders
Create Database in MySQL || MySQL Tutorial For Beginners In Hindi || AppWeb Coders
Today We will learn
-How to Create the database in MySQL
-How to Remame/Alter the database in MySQL
-How to delete the database in MySQL
Commands to Create the database
CREATE DATABASE [DATABASE__NAME]
Commands to Alter the Database
MYSQL- RENAME DATABASE [OLD__DATABASE__NAME] TO [NEW__DATABASE__NAME]
SQL- ALTER DATABASE [OLD__DATABASE__NAME] MODIFY NAME = [NEW__DATABASE__NAME]
Commands to Delete the database
DROP DATABASE [DATABASE__NAME]
PATH OF STORED MYSQL DATABASE FILE
C:\ProgramData\MySQL\MySQL Server 8.0\Data
NOTE:- DO NOT FORGOT TO SHOW HIDDEN FILE, BECAUSE "ProgramData" FOLDER IS HIDE BY DEFAULT
Subscribe our Channel for more content related to programming
/ @appwebcoders
http://www.appwebcoders.com
#mysql #database #createdatabase