Well, we can’t argue that Windows is the key platform for database development and management software—but what if you are a Mac user? Who said you can’t have equal opportunities to set up easy daily work with, for instance, MySQL databases? Simply take a closer look and you’ll see an abundance of top-tier MySQL tools […]
7 Older Entries »
Unfortunately, I only have macOS running on i7 and i9 Intel Processors. It would be great to hear back how it goes for somebody one of the new Apple M1 chip.
I typically install the workstation version because it meets my needs to run MySQL and other native Linux development tools. However, the server version is also available. Fedora is a wonderful option, as a small footprint for testing things on my MacBookPro.
It’s a problem for my students who purchased the new Apple hardware that uses Apple Silicon because they can’t install a Docker MySQL instance. However, there is Homebrew formula that works on macOS Big Sur and the new Apple silicon. It supports:
- Intel Silicon: macOS Big Sur, Catalina, and Mojave
- Apple Silicon: macOS Big Sur
The Homebrew Formula does have conflicts that you may need to avoid. It is a solution for those with the new Apple silicon.
As always, I hope this helps those looking for a solution.
MySQL membership conditions are in the MySQL 8 Documentation.
They’re found in the 126.96.36.199 Subqueries with
=ANY operators both
perform equality matches with one twist. The
operator works with a set of values or a subquery but the
=ANY operator only works with a subquery.
I created the
words tables for this example. They hold the
following values respectively:
numberstable holds the values of
letterstable holds the values of
wordstable holds the values of
While you can download MySQL as a DMG package, a number of users would prefer to install it as a Docker instance. You won’t find the macOS downloads on the same web site as other downloads. You can use the following macOS download site.
After installing Docker on your macOS, you can pull a copy of the current MySQL Server with the following command:
docker pull mysql/mysql-server
You should create a
mysql directory inside your
~/Documents directory with this command:
Then, you should use the
cd command to change into
~/Documents/mysql directory and run this
It should return the following directory: …[Read more]
I’m switching to MySQL and leveraging Alan Beaulieu’s Learning SQL as a supporting reference for my Database Design and Development course. While reviewing Alan’s Chapter 5: Querying Multiple Tables, I found his coverage of using self-joins minimal.
In fact, he adds a
prequel_film_id column to the
film table in the
sakila database and
then a single row to demonstrate a minimal self-join query. I
wanted to show them how to view a series of rows interconnected
by a self-join, like the following:
SELECT f.title AS film , fp.title AS prequel FROM film f LEFT JOIN film fp ON f.prequel_id = fp.film_id WHERE f.series_name = 'Harry Potter' AND fp.series_name = 'Harry Potter' ORDER BY f.series_number;
It returns the following result set:
Many database professionals use Mac for their daily work. Devart is going to develop its software products for Mac platform in future. But for now, our users owing macOS devices can face some issues with procuring high-quality and comfortable work. One of the best solutions to resolve such issues is a software called Parallels Desktop. This is […]
Unfortunately there are no packages for Mac OS. In this post I will describe how to build XtraBackup for Mac OS.
To build and use XtraBackup on Mac OS you need to install some additional packages. I will use MacPorts to install the dependencies.
# port install cmake p5.16-dbd-mysql
Building XtraBackup for Mac OS
Download the source code from …[Read more]
Installing MySQL Database on Ubuntu or CentOS is a trivial operation as long as they have nice package managers as Aptitute and YUM. Otherwise, in Mac OS X is a hard operation from downloading the correct package, apllying with several steps and it can break the whole install, if you But, with Homebrew, the install... Read More
When I came from Linux world to Mac OS, I’ve got frustrated in not having a package management system as there are in Ubuntu (with Apt-get) or in CentOS ( YUM ). The world was so fantastic, if I need to install MySQL Database on Ubuntu, I’d just type: $ sudo apt-get install mysql-server On Mac, the […]
7 Older Entries »