SQL SELECT Database

Hi guys,
      Today we will discuss about select a database from your pc.The SQL USE statement is used to select any existing database in SQL schema. 

(01).  Open MySQL console
(02). Type showdatabases to view databases witch you already have.          
(03).  eg :- To use 'buddy' database in my computer,Type Command,

       USE buddy ;

Then you can see as below...

Now you can use 'buddy' database to your process...

How to DROP or DELETE Database

Hi guys,
      Today session is delete or drop database on your computer which use to your own software development.Please follow the steps as below.

(01).  Open MySQL console
(02).  Type Command,

       DROP DATABASE new_database ;

If you delete database properly, you can see massage as this.

** Make sure that,you can view databases using show databases command which i taught the previous lesson.

How To Create New Database

Hi guys,
      In this session, I'm going to teach create a new database on your computer which use to your own software development.Please follow the steps as below.

(01).  Open MySQL console
(02).  Type Command,

      CREATE DATABASE new_database ;

** new_database is the database name.you can use database name as your choice.

** you can not create database using existing database name.Make sure that,you can view databases using show databases command which i taught the last lesson.

If you create properly, you can see massage as this.

View All Databases

                You can check available databases with sql command.Open MySQL console. Type Command as follows.

mysql > show databases ;

--Please be careful to insert semi colon after the command.--

How To Get Start With MySQL Console

Hi,

          Today i am going to discuss how to work with MySQL console.If the installation went well, you should have an new icon in the bottom right, where the clock is.

click wamp icon =>  MySQL =>  MySQL console.

Enter password which you input installing wizard

Now you will get console as follows,

How to install MySQL in your PC

Hi guys,

In the very first,you have to install the MySQL into PC. This will be very simple task.So I will not discuss very deeply in this installation topic.You can download  the installer package, unzip it anywhere, and run setup.exe

How to install - This video will be help to install MySQL in your PC.

Click here to Download MySQL

Easy Way to install MySQL server

when you installing the wamp server,  MySQL + Apache + PHP will be automatically install in your pc. It will be very helpful your future sessions.

click here -   This video will be help to install Wamp server in your PC.

click here  -  Click to download wamp server.

Welcome

Hi All...

I'm trying to teach you guys about how to use MySQL to create and maintain databases. Keep in touch more post are coming on the way. see you soon...!