The topic of the day, we will megajarkan to you how to create or delete a database and view the database that is in mysql. By typing the command function then ends with the symbol ';'.
to see all databases in MySQL can use the command 'Show databases;' ,Then MYSQL will bring up a list of all the databases you have.
ScreenShot: Show database [Click Here]
while to create the database we will use the 'create database database_name;', for example, we will create a database with the name 'becoding' then we write the command 'create database becoding;' and then press enter.
to check whether the database has been properly made with the command 'show databases;'
okay database has been created, now we will attempt to delete database 'becoding' is. to command delete databases can use the command 'drop database database_name;', so now we would type 'drop database becoding;' to remove becoding database.
check again whether the database is actually already erased or not.
ScreenShot: Drop database [Click Here]
That's how to view, create or delete a database in MySQL. we will learn more mysql command on the next topic. Thank you for visiting and reading this topic until the completion of this topic may be useful and beneficial for you all.
Tidak ada komentar:
Posting Komentar