If you need one row per state with an order count and a dollar total, MariaDB GROUP BY is the clause: SELECT state, COUNT(*), SUM(amount) FROM orders GROUP BY state; collapses every matching row into one. The hard parts sit around it: HAVING versus WHERE, a DATETIME grouped by month, and a default sql_mode that … Read more >>

In this MariaDB tutorial, we will learn about MariaDB Transaction. Additionally, we will cover the following topics. MariaDB Transaction MariaDB Transaction Rollback Example MariaDB Transaction Log MariaDB Transaction Isolation Level MariaDB Transaction Timeout MariaDB Transaction Rollback On Error MariaDB Transactional DDL MariaDB Transaction Example MariaDB Transaction Alter Table MariaDB Statements That Cause An Implicit Commit … Read more >>

I dumped a small orders database, dropped it, and got all 5 rows and $630.44 back from one file. The MariaDB backup database command was mariadb-dump –single-transaction –routines –events –databases shop –result-file=shop.sql; mariadb < shop.sql restored it. Test setup: a Windows 11 PC, local server 13.0.2-MariaDB on port 3306. Here’s the finished round trip: Before … Read more >>

In this MariaDB tutorial, we will look at various MariaDB Reserved Words and also look at several examples. There are lists of the topic that comes under discussion: MariaDB Reserved Words MariaDB Escape Reserved Words MariaDB 10 Reserved Words MariaDB Reserved Words Exception MariaDB Reserved Words In this section, we will know about reserved words … Read more >>

In this MariaDB tutorial, we will discuss MariaDB Max Connections and look at several examples related to it. There are lists of the topic that comes under discussion: MariaDB Max Connections MariaDB Max Connections Per User MariaDB Max Connections Error MariaDB Max Connections my.cnf MariaDB Max Connections limit MariaDB Max_Connections 214 MariaDB Max Connections 214 … Read more >>

In this MariaDB tutorial, we will discuss using the MariaDB Insert Into Select statement and look at several examples. There are lists of the topic that comes under discussion: MariaDB Insert Into Select MariaDB Insert Into Select Auto_Increment MariaDB Insert Into Select on Duplicate Key Update MariaDB Insert Into Select Example MariaDB Insert Into Select … Read more >>

In this MariaDB tutorial, we will discuss the MariaDB Check Empty String condition and look at several examples related to it. There are lists of the topic that comes under discussion: MariaDB Check Empty String MariaDB Check Empty String But Not Null MariaDB Check Empty String But Not Empty MariaDB Check Empty String Count MariaDB Check Empty … Read more >>

In this MariaDB tutorial, we will discuss the MariaDB Date Greater Than condition and look at several examples. There are lists of the topic that comes under discussion: MariaDB Date Greater Than MariaDB Date Greater Than And Less Than MariaDB Date Greater Than After MariaDB Date Greater Than Current_date MariaDB Date Greater Than Equal MariaDB Date Greater … Read more >>

In this MariaDB tutorial, we will discuss the MariaDB Date Allow Null statement and look at several examples. There are lists of the topic that comes under discussion: MariaDB Date Allow Null MariaDB Date Allow Null Alter Column MariaDB Date Allow Null By DateTime MariaDB Date Allow Null Error MariaDB Date Allow Null Group By MariaDB Date … Read more >>

In this MariaDB tutorial, we will discuss the MariaDB Select Unique keyword and look at several examples. There are lists of the topic that comes under discussion: MariaDB Select Unique MariaDB Select Distinct Count MariaDB Select Unique All Columns Except One MariaDB Select Unique As MariaDB Select Unique Between Two Dates MariaDB Select Unique Dates MariaDB Select … Read more >>