Ipctrd (A Computer Learning Blogs)

MySQL SELECT Database SELECT Database is used in MySQL to select a particular database to work with. This query is used when multiple databases are available with MySQL Server. You can use SQL command USE to select a particular database. Syntax: USE database_name; Example: Let's take an example to use a database name "customers". USE customers; MySQL Drop Database You can drop/delete/remove a MySQL database easily with the MySQL command. You should be careful while deleting any database because you will lose your all the data available in your database. Syntax: DROP DATABASE database_name; Example: Let's take an example to drop a database name "employees" Subscribe channel on  YouTube Read this post on  Blogger Like page on  Facebook Tweet about video on  twitter Let's chat on  whatsapp See you at  Instagram Google +

MySQL Create Database You can create a MySQL database by using MySQL Command Line Client. Open the MySQL console and write down password, if you set one while installation. Now you are ready to create database. Syntax: CREATE DATABASE database_name;  Example: Let's take an example to create a database name "employees" CREATE DATABASE employees;  You can check the created database by the following query: SHOW DATABASES;  By this, you can see the all created databases. Subscribe channel on  YouTube Read this post on  Blogger Like page on  Facebook Tweet about video on  twitter Let's chat on  whatsapp See you at  Instagram Google +