Skip to Content
Spring 5.0 Projects
book

Spring 5.0 Projects

by Nilang Patel
February 2019
Intermediate to advanced
442 pages
11h 46m
English
Packt Publishing
Content preview from Spring 5.0 Projects

Understanding the database structure

If you don't have MySQL installed, head over to the MySQL link (https://dev.mysql.com/downloads/installer) to install it and populate it with the world database, if it is not already available. The appendix will also guide you on how to run the queries using MySQL Workbench and MySQL command-line tool. 

The world database schema is depicted in the following diagram:

The database schema is simple, containing three tables as follows:

  • city: List of cities mapped to the three character country coded in the country table.
  • country: List of countries where the primary key is the three character country code. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Spring Boot 2.0 Projects

Spring Boot 2.0 Projects

Mohamed Shazin Sadakath
Spring 5.0 By Example

Spring 5.0 By Example

Claudio Eduardo de Oliveira
Spring 5.0 Cookbook

Spring 5.0 Cookbook

Sherwin John C. Tragura
Pro Spring 5: An In-Depth Guide to the Spring Framework and Its Tools

Pro Spring 5: An In-Depth Guide to the Spring Framework and Its Tools

Iuliana Cosmina, Rob Harrop, Chris Schaefer, Clarence Ho

Publisher Resources

ISBN: 9781788390415Supplemental Content