MariaDB not fetching value of enum, but only fetching the order of enum
in MariaDB sql:
Trigger to get a column value from tableA to tableB by select statement
Table1
concat two column in mysql , one of them is an auto-increments, using trigger
Dears, please below is my first trigger to make a column as a concat a two column .. but it is not working ?! can i know where is the error
SQL – Display 0 on a count with months where there is no data [closed]
Closed yesterday.
SQL – Display 0 on a count with months where there is no data [closed]
Closed yesterday.
MariaDB – Delete where rows match, there’s more than 2 and the date is over a year
I have a table where I want to purge some old entries matched by the same “history_id” (so you could have 100 rows with the same history_id).
Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_unicode_ci,COERCIBLE) for operation ‘=’
This is an SQL code I used. It works fine until I introduct this line:
Get all french departement codes including Corsica
I want to get all departement in France. They can be count from 1 to 97, except for Corsica which is 2A and 2B.
MariaDB: alias in projection possible?
SELECT name AS n, CONCAT(name,’X’) FROM mytab; n concat ———— tim timX sue sueX When using the alias (n) in the projection it is not working. SELECT name AS n, CONCAT(n,’X’) FROM mytab; > Unknown column ‘n’ in ‘field list’ Is this generally not allowed or do I need to set it different to AS? […]
MariaDB self join with ORDER BY and LIMIT
I’m having problems writing an SQL query to run on the following system: