Video Tutorial: How to create a database in MySQL using Command prompt?

Ads
 

Video Tutorial: How to create a database in MySQL using Command prompt?

In this video you will learn to create a database in MySQL using Command prompt.

In this video you will learn to create a database in MySQL using Command prompt.

How to create a database in MySQL using Command prompt

MySQL is an Operation support system for database management. The originator of MySQL is Michael Widenius and the software was entitled after his name where SQL stands for structured query language. The updating project of MySQL has got its source code with the conditions of the GNU General Public License and also with a wide range of non free software. My SQL was possessed and promoted by MySQL AB. Many paid versions are obtainable and they provide a supplementary practicality.

Here is the video tutorial of "How to create database in MySQL using command prompt?":

In this tutorial we will learn how to create a database in MySQL using command prompt.

  1. To create a database we need to use 'create database name'.

  2. Initially we get linked to MySQL followed by the client option and the password is entered and we are connected to My SQL database.

  3. Thus to create a database type 'create database text dbit. We have successfully created a a database. There are other SQL as well to create a database for example “create database if not exists employee”. This query will create a database if an employee database does not exist.

  4. To check the database we use the query “show databases” which shows the list of databases and the database “my text dbi” could be found here.

  5. We are now connected to MySQL database. As there were no tables present it shows “empty sets”.

  6. Now we use a query to create a table. It was copied and pasted in notepad and then after a few modifications again it was pasted in My SQL. Thus it displays the existing table called “emp”.

  7. Then we check the structure of the newly created table by typing “describe emp”. Thus we can observe the structure of the table as well.

Ads

Ads