Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Rename values in one column, depending on the value in other column

I have two tables with orders and parcels in MariaDB:

Avoid the use of alias in query with nested SELECT clause

I have this table:

Avoid the use of alias in query with nested SELECT clause

I have this table:

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