MySQL Examples and Tutorials
MySQL is the most popular database only after Oracle due to its features and versatility. It provides us with every single feature that we need to create, maintain and scale the database. It allows us to create and manage users with appropriate privileges to manage the databases. In this tutorial, we will learn how to …
MySQL User Creation, Display, Delete – Complete Guide Read More »
In this tutorial, we will learn about the Views in MySQL. We will see the database view, how to create it, and how to do operations on it. We are going to learn about views with some simple as well as complex examples. We can also insert, update and delete the data using the views. …
MySQL provides us with a wide range of aggregate functions that make our life easier. The MySQL GROUP_CONCAT() is one of those aggregate functions pretty similar to MySQL CONCAT() aggregate function. Jowever, it is built for a slightly different purpose. In this tutorial, we will study the MySQL GROUP_CONCAT() function and learn how to use …
In this tutorial, we will study an easy yet powerful statement- INSERT INTO SELECT. In official MySQL documentation, it is described as INSERT … SELECT; however, people prefer calling it INSERT INTO SELECT. We will also be looking at its syntax, examples, and points that you should avoid getting successful results from the given statement. …
In this article, let’s discuss the differences between MariaDB vs MySQL. MySQL, without a doubt, is one of the most famous and in-demand database management systems. However, different forks of original MySQL have been created due to uncertainties and distrust in the MySQL community after acquiring MySQL by SUN and later SUN by Oracle. MariaDB …
ACID properties are one of the most important rules that everyone should know before diving into any complex database project or becoming a good programmer. In this tutorial, we will learn the ACID properties in DBMS with some excellent and easy real-time examples. But before that, understand the concept-“transaction” in DBMS. A database transaction is …
ACID properties in DBMS – Atomicity, Consistency, Isolation, and Durability Read More »
In this tutorial, we will learn how to connect the MySQL database with the Python program and write different queries. We will start with a basic introduction, go through MySQL set up in Python, and then execute further queries for creating, reading, deleting, and updating the data. Let’s start with an introduction. Using MySQL with …
Python MySQL – Connect a MySQL Database with Python Read More »
The MySQL LAST_INSERT_ID() function of MySQL does exactly as it reads. It will return the latest ID of the AUTO_INCREMENT column. This can be a useful little function to find out the latest ID of the AUTO_INCREMENT column. The LAST_INSERT_ID() function can be used without an expression and also with an expression. This function when …
In this tutorial, we will learn what is ON DELETE CASCADE, how to use it, and some more concepts related to it. Did you ever fall into a situation where you wanted to delete all the matching records in the child table when one of the records in the parent table gets deleted? If yes, …
In this tutorial, we will learn the MySQL data type BOOL and BOOLEAN. We will also be learning how to implement boolean in the queries and some exceptions you must know. We will also go through some simple and practical examples to understand the BOOL and BOOLEAN data types. What is BOOLEAN data type in …