O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Working with Databases

In the previous chapter, we saw how to set up different types of connections to a MySQL server from Navicat. Now that we’re ready to get connected to a server, it’s time to work with databases. In this chapter you’ll learn how to:

  • Create a database from scratch
  • Create tables and views using Navicat’s visual design tools
  • Create foreign key constraints and triggers
  • Define stored procedures and functions
  • Create scheduled events
  • Work with database queries

Managing database objects with Navicat

What do we mean by database objects? Basically tables, views, functions, and events are what we refer to as objects. For each of them, there is a toolbar icon in Navicat’s main window and they also appear on the tree view list on the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required