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

Working with queries in Navicat

Designing a query in Navicat is much like designing a view except that views are limited to SELECT statements whereas the queries can perform any CRUD (create, read, update, and delete) operation.

Just like the View Builder, Navicat’s visual query builder allows you to graphically represent tables and fields as well as relationships between them (JOINS) and by leaving the SQL generation to Navicat, however, this approach only works with SELECT queries. You still have to handcode the SQL for create, update, and delete queries.

In this section, we’ll go through an imaginary scenario regarding the fictional company Acme.com, where the CEO is unhappy with the financial results from the past fiscal year and believes that ...

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