Connection of Database

This process is very helpful for beginners . It create Sample DataBase in My SQL.

Requirement :-  SampleDB  (Downloaded From Download Area).

Follow these simple steps very carefully

1.  Open My SQL
2. Enter your password
+--------------------------------------------------------------------------------------------------------+
   Note:- Save SampleDB in C:/                                                                                                         
               As files in SampleDB contain directory as C:/SampleDB                                                       
+--------------------------------------------------------------------------------------------------------+
3.  Type SOURCE C:/SampleDB/MENA.sql  in command line
     
   

4.  Hit Enter

5.   Now type     SOURCE C:/SampleDB/crEmpDep.sql      and    Press Enter.
      and then  type     SOURCE C:/SampleDB/crStudent.sql      and    Press Enter.
6.  Now type   use menagerie;    & then press Enter  (Type all in blue color including ';').
                       Show tables;  
        If you are watching screen like this     then you have Done.  (Notice dept,empl,event,pet,student)

        IF Not then try it again carefully this time.
  These process just join the database to your My SQL which we will need in learning queries .