• TestingDocs
TestingDocs.com
Software Testing website
  • Automation
    • Selenium
    • JBehave Framework
  • Tutorials
    • MySQL Tutorials
    • Testlink
    • Maven
    • Git
  • IDEs
    • IntelliJ IDEA
    • Eclipse
  • Flowcharts
    • Flowgorithm
    • Raptor
  • About

MySQL

Setup MySQL world Database

Overview

This tutorial is a step-to-step guide to setup the MySQL world Database and the tables in the schema. The world sample sample database is an example database from MySQL team.

Download world Database

Download the MySQL script file that contains the SQL statements. To download the database navigate to the following URL:

https://dev.mysql.com/doc/index-other.html

In the Example Databases section, click on world database download links. The download is available in two formats.

On Windows Operating system click on the Zip download link.

OnĀ  Linux distributions click on the TGZ download link.

 

MySQL World Database Download

 

Extract Contents

Extract the contents of the world-db zip file. Copy the world.sql file to a suitable location.

Connect to the MySQL server using the mysql command-line client::

$> mysql -u root -p

Enter the root password. We can also use a non-root user account. The user account should have privileges to create new database. To know more about the MySQL command line client:

https://www.testingdocs.com/mysql-command-line-client/

Install Database

Execute the world.sql SQL script file to create the database structure and insert the data. In this example, the world.sql file is located at following location :

C:/TestingDocs/world.sql

Issue the following command at the MySQL command prompt.

mysql> SOURCE C:/TestingDocs/world.sql;

Press the Enter button to execute the command.

 

Install MySQL world Database

 

The database and the tables would be installed. To confirm we can use the following command to know the tables:

mysql> SHOW TABLES;

MySQL world tables

https://www.testingdocs.com/mysql-world-database-tables/

—

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

For more information on MySQL Database:

https://www.mysql.com/

Related Posts

MySQL /

How to secure your SQL Database: Tips and Tricks

DataGrip Desktop Shortcut

MySQL /

Launch DataGrip on Windows

DataGrip Download

MySQL /

Install DataGrip IDE on Windows 11

MySQL Workbench Windows 11

MySQL /

New MySQL Connection in Workbench

MySQL Command-line Client

MySQL /

Command-Line MySQL Client

‹ MySQL Community vs Enterprise Edition› MySQL world Database Tables

Recent Posts

  • How to secure your SQL Database: Tips and Tricks
  • Shaping the Future of Development: Exploring Key Trends in Software Engineering
  • Improving Java Performance with Multithreading
  • Difference between PHP and JavaScript?
  • Bing Conversation Styles
  • ChatGPT Introduction
  • Open Source AI Frameworks
  • Artificial Intelligence Tools
  • Top AI Music Applications
  • Top AI Website Design Tools

Back to Top

Links

  • Contact
  • Privacy Policy
  • Cookie Policy

www.TestingDocs.com