Friday, 24 June 2016

Using example sql databases for exercises

->
Extract sql zip file into C folder

C;/myproject/mysql/bin


1) http://dev.mysql.com/doc/index-other.html

2) download   world.sql file

3) place it in the folder   C:/myproject

4) open cmd

 Run SQL server

      C:\myproject\mysql\bin\mysqld --console


5) open another cmd

    Run SQL client

 
C:\myproject\mysql\bin\mysql  -u sree -p
Enter password: 1234



6) Now run the  world.sql file in client cmd

mysql> source C:/myproject\world.sql


7) It will create new database with name World


8)



  

No comments:

Post a Comment