MySQL-MariaDB

In the article, I will explain What is Transaction in MySQL. Also, article contains information about the use of Transaction, which is frequently used in systems such as SQL Server, …

In the article, the use of partition in MySQL is explained with various examples. What is Partition in MySQL? We can translate the partition word used in MySQL and advanced …

In the article, the use of triggers in MySQL Systems is explained with examples. What is Trigger? Triggers in MySQL are a special type of MySQL Stored Procedures. The most …

The article contains information about the while loop  in MySQL and its usage. While Loop in MySQL The while loop, which is one of the loops used in programming languages, …

The article contains information about CASE WHEN Statement in MySQL as an alternative to the if condition. With the CASE statement used in MySQL as an alternative to the if …

The article contains information about MYSQL IF Statement, ELSEIF Statement and ELSE STATEMENT used to direct the command flow by condition in the MySQL VTY system. MySQL IF() Function We …

The article provides information about MySQL stored procedures. Creating a stored procedure and stored procedure types are explained with examples. What is MySQL Stored Procedures? Stored procedures are compiled SQL …

The article contains information about LOCK TABLES in MySQL VTY system. Features added to the database during database design or later (INDEX, Foreign Key, UNIQUE …) can provide performance improvements. …

The article contains information about the MySQL Temporary Tables used to create a temporary table in MySQL VTY system. What is Temporary Tables in MySQL? The Temporary Table feature in …

The article contains information about declaring variable in MySQL VTY system to store temporary data. Variables can be used to pass values from one MySQL query to another MySQL query. …