There are two primary methods to view the tables in MySQL:
- The MYSQL SHOW TABLES command.
- Querying the Information_schema.tables table.
In this article, we are going to explore them both.Read More
MySQL ENUM is a string data type with a value chosen from a list of permitted values. You set these permitted values during table creation as shown below:
CREATE TABLE Product ( id int NOT NULL PRIMARY KEY, productName varchar(30) NOT NULL, color enum('blue','red','yellow','black','white') NOT NULL DEFAULT 'blue' );
SQL Server instances house databases containing the data for the backend stack of a business model, or configuration data for particular applications. Regardless of the use case, an instance has a set of values/settings that should be tuned to follow best practices.
The purpose of the Stored Procedure that I’m showcasing in this article is to present the DBA a set of important settings/values that shouldn’t be overlooked. Moreover, I will share a cool feature that help DBAs keep control of any particular setting/value that has been recently changed/modified.Read More
MySQL is known for being easy to use and highly secure. That’s why it is the number one choice for many organizations, including the biggest brands like Facebook, Google, Uber, and YouTube. Because it’s open-source, it’s free to use and modify even for commercial purposes. But although it can be very secure, the security features are not always utilized properly.
Cybercriminals are good at finding ways to exploit the masses. Ransomware attacks have penetrated everything from cities, schools, and hospitals to large and small businesses. Victims are tricked to allow malicious programs into their systems where those programs lock files until getting ransom. Organizations of all kinds that use MySQL and other database management systems are at risk of attacks.Read More
An SQL Server database can store a variety of data types, such as numbers, text strings, Boolean values, dates, etc. However, storing and handling such data have their specificities. The current article will focus on storing dates in an SQL Server database table and converting different types of dates into the SQL Server format YYYY-MM-DD and vice versa.
Let’s start!Read More
Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn.
We are continuing our journey to MySQL from the SQL Server point of view. It started with MySQL CREATE TABLE, followed by MySQL INSERT, and the most recent piece was about MySQL DELETE. Today, UPDATE is our focal point.Read More
A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential to ensure data recovery at any point in time of the application workflow life cycle. Both MySQL and MariaDB offer solutions for these cases. This article will explore the existing options and procedures of how to backup MySQL Database and MariaDB as well as recovery strategies.Read More
This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a virtual machine using Oracle VM virtual box and set up Ubuntu 18.04 on the virtual box. I’d recommend you referring to the article Creating a Virtual Machine with Oracle VM Virtual Box for a better understanding of the installing process and creating a virtual machine on Oracle VM virtual box. Also, you may turn to the article How to Install Ubuntu 18.04 for more information about installing Ubuntu 18.04 on the virtual machine.Read More
The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool for generating backups in several formats or restoring MySQL databases.Read More
This article describes the step-by-step deployment process of the Azure Database for MySQL Server.
Open the Azure portal and log in using the appropriate credentials. Note: For demonstration purposes, I got a pay-as-you-go subscription to Microsoft Azure. For more information about the Azure MySQL pricing model and various Azure subscriptions, refer to Subscriptions, licenses, accounts, and tenants for Microsoft’s cloud offerings.Read More