Show
MariaDB Server: The open source relational databaseDownload Sponsor Get Involved Sponsor Platinum sponsorsGold sponsorsOur blogMariaDB 10.11.0 preview release now availableWe are pleased to announce the preview release of the MariaDB 10.11 series, MariaDB 10.11.0. Candidate features for MariaDB 10.11 Preview releases are designed to get features into the hands of users more quickly, and should not be used for production. … Continue reading “MariaDB 10.11.0 preview release now available”MariaDB 10.9.3, 10.8.5, 10.7.6 and 10.6.10 now availableThe MariaDB Foundation is pleased to announce the availability of MariaDB 10.9.3, MariaDB 10.8.5 and MariaDB 10.7.6, the latest Generally Available releases in their respective short-term support series (maintained for one year from their first GA release dates), as well as MariaDB 10.6.10 the latest stable release in the 10.6 long-term support series (maintained for five years). … Continue reading “MariaDB 10.9.3, 10.8.5, 10.7.6 and 10.6.10 now available”Regressions in recent MariaDB Server releasesOur most recent MariaDB Server release introduced some regressions starting with the 10.6 series, affecting 10.7 – 10.9 as well. This blog post is here to explain the problems in hopes that the impact is minimized. … Continue reading “Regressions in recent MariaDB Server releases” (adsbygoogle = window.adsbygoogle || []).push({});Publishing of Contribution StatisticsIn the last meeting, the MariaDB Foundation Board proposed the regular publishing of contribution statistics. This post is an update on our progress and the first report. … Continue reading “Publishing of Contribution Statistics”Generating MariaDB MetricsSomething that is very important to us in the MariaDB Foundation is “Openness”. This is not only in the open source nature of MariaDB, but we are also very transparent in what happens with the MariaDB source code. … Continue reading “Generating MariaDB Metrics”
Planet MariaDBMagma, a new storage engine for Couchbase By Small Datum, 2022-09-29 Storage engines, efficiency and large documents, rows, objects By Small Datum, 2022-09-28 Percona Monthly Bug Report: September 2022 By Percona, 2022-09-28 PMM v2.31: Enhanced Alerting, User-Friendly Main Menu, Prometheus Query Builder, Podman GA, and more! By Percona, 2022-09-28 Give Me Some Latitude… and Longitude By Percona, 2022-09-27 MariaDB 10.11.0 preview release now available By MariaDB Foundation, 2022-09-26
January 3, 2018 by Robert Gravelle Available in Non-Essentials editions of Navicat for MySQL, PostgreSQL, SQLite, MariaDB, and Navicat Premium, the Query Builder allows anyone to create and edit queries with only a cursory knowledge of SQL. In today's blog, we'll use it to write a query to fetch a list of actors that appeared in movies released during a given year. The Source DatabaseThe query that we'll be building will run against the Sakila sample database. A former member of the MySQL AB documentation team named Mike Hillyer created the Sakila database specifically for the purpose of providing a standard schema for use in books, tutorials, and articles just like the one you're reading. The database contains a number of tables themed around the film industry that cover everything from actors and film studios to video rental stores. Please refer to the Generating Reports on MySQL Data tutorial for instructions on downloading and installing the Sakila database. Opening the Query BuilderYou can think of the Query Builder as a tool for building queries visually. It's accessible from the Query Designer screen. Let's bring it up by opening a new query:
Constructing the Actors for Year's Films QueryIt's a good idea to select the tables first, so that the Query Builder knows which fields to present for the field list:
Note how the Query Builder already knows the table relationships. That's because foreign key constraints have already been declared on Table objects: Adding WHERE CriteriaClicking on "<Click here to add conditions>" beside the WHERE keyword adds a default WHERE condition of "<--> = <-->".
SELECT a.first_name, a.last_name, f.title FROM actor AS a INNER JOIN film_actor AS fa ON fa.actor_id = a.actor_id INNER JOIN film AS f ON fa.film_id = f.film_id WHERE f.release_year = 2006 ConclusionWhether you're a novice or experience DBA, Navicat's Query Builder makes writing SELECT queries easier than ever before. In an upcoming blog, we'll get into some of its more advanced features. |