[Step 01] How to view, create or delete a mysql database

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;'

ScreenShot: Create database [Click Here]

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. 

CONTENTS OF LEARNING MYSQL

What is MySQL?
MySQL is an open-source relational database management system (RDBMS) that is most widely used in the world, and the most widely used open source client-server RDBMS. MySQL name is a combination of "My" is the name of the daughter of the founder Michael Widenius, and "SQL", stands for Structured Query Language. MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.

Why use MySQL?
There are several reasons why MySQL is widely used in the world of learning and programming, that is:
1. it is open source or free so it can be used legally in all activities. 
2. can work on a variety of platforms, such as Linux, Windows, Mac OS and so on. 
3. have a variety of types of data that can support data storage more accurate. 
4. supports query to help in processing data. 
5. Can be used in various types of programming such as VB6, VB.Net, Delphi 7, C, C ++, Java, Perl, PHP and Python 
6. The use of the database can be used for more than one user at the same time (sharing database). 
7. Secure the data storage for user access rights can be restricted. 

What applications are used in learning MySQL?

to learn mysql can use MySQL client or Xampp which can be obtained via the link below, for how to install to your search on www.google.com.
Mysql client : http://dev.mysql.com/downloads/
Xampp        : https://www.apachefriends.org/index.html

then the following is an index of learning MySql BeCoding Blog:
Step 01: How to view,create, or delete a mysql database
Step 02: How to use database & create a table in MySQL database
Step 03: modify a table with the command 'alter table'  
Step 04: Create table relationships using the 'alter table' command
Step 05: How to enter and display data from the table mysql
Step 06: How to display the data in a database table mysql
Step 07: How to update the data in the table
Step 08: How do I delete existing data in the table mysql
Step 09: Learn to command the query "sum,min,max,avg, and count" in MySQL
Step 10: COMING SOON

other references
01.DATA TYPE IN MYSQL