The latest from the MySQL community

In this blog post, we are going to show you how to fix corrupted tables in MySQL. MySQL is an ...

Read More

The post How To Fix Corrupted Tables in MySQL appeared first on RoseHosting.

Relational databases, such as MySQL, give you the ability to organize data into separate tables, but link the tables together to form relationships when necessary.

MySQL joins give you the ability to link data together in a MySQL database. A join is a way to get columns from more than one table into a single set of results. This is usually much more efficient than trying to perform multiple queries and combining them later.

This article looks at the different types of joins that can be performed in MySQL and goes over the different options you have to combine data from multiple tables: inner joins, left and right joins, and full outer joins.

A base example of MySQL joins

To further our understanding of joins, we’ll create a simple database of grocery items, each item having a category. Categories …

Learn how and when to use inner joins outer joins left joins and right joins.

Overview

One of the best things the DevOps movement has ushered in is the concept of Infrastructure as Code. IaC lets you define your infrastructure in specially formatted files, and allows you to use automation tools to create or modify your infrastructure based on those files. But did you know that you can also manage your database schemas in a similar approach?

Atlas CLI is a command line tool that helps manage the structure of your database by keeping a representation of the schema in a file. It can be used by itself to manage your schema changes, or as part of a CI/CD pipeline to automate the process of updating your schema based on the definition file. In this article, we’ll cover the basics of using Atlas CLI to generate a schema definition file, as well as updating …

Connect a Python app to MySQL database with mysqlclient mysql-connector-python PyMySQL and aiomysql.

In this tutorial, you’ll learn how to build a mood tracker application with Laravel 9, connect it to a PlanetScale MySQL database, make database schema changes, and deploy your database branch to production. You’ll use PlanetScale for the database, which gives you a fully managed MySQL-compatible database, unlimited scalability, a Git-like development workflow, zero downtime schema changes, and more.

Warning

This blog post is over a year old and may be out of date.

Here are some of the highlights of what you’ll create:

• A production-ready MySQL database in PlanetScale
• 2 database branches: main for production and dev for development
• 2 tables, moods and entries, to store your daily entries and mood options
• Database migrations and a seeder to run on your …

Learn how to build a Harry Potter API using Node.js Express and PlanetScale

In this tutorial, we are going to show you how to install MySQL on your Ubuntu 20.04 and how to ...

Read More

The post How to Install and Use MySQL on Ubuntu 20.04 appeared first on RoseHosting.

MySQL is an open-source relational database management system (RDBMS), it’s widely used and part of the popular LAMP/LEMP stacks. The ...

Read More

The post How to Install MySQL Database on Ubuntu 20.04 appeared first on RoseHosting.

Today we are going to guide you on how to show all users in the MySQL users Database. A common ...

Read More

The post MySQL SHOW USERS: List All Users in a MySQL Database appeared first on RoseHosting.