SQL1

Creating a Database, Using it & Droping Database

MySQL

mq> create database felight;+

In the above query felight is the database name. After creating the database suppose if want to create table in it then you should be inside it. Which we can do by executing below query.+

mq> use felight;+

Below query is used to drop (or delete) database execute below query. WARNING: Beware the once you drop a database you can revert from it or you can not recover.+

mq> drop felight;

I expect you to have MySQL installed in your laptop or in you system and make use of console only for our further practice session.+

The reason I am using console is because+

1. Irrespective of any UI is available or not, we can always log into SQL Console.+

2. If you practice using console then you will understand the concepts more clearly then you would do by using the softwares like Apex, phpmyadmin, sqldeveloper etc. These tools you should start using to once you master the subject to save time.+

 +

Here is the series of queries related to this lesson :+

+

Log into your SQL Console and execute the queries which I executed in above experiment.+

At the end of the subject you will have option to upload all your assignments in one shot which will be evaluated and then you become eligible for exam and your score in exam will written in Certificate.