How to add a column to a table in a MySQL query with a check for the presence of this column?

Question

MySQL

Dear Gurus and experts please give advice.
There is a narrow framework for creating a package.
-All queries must be packed into files with the SQL extension -Many queries are
stored in the SQL file
-In one of the queries, you need to add a column to the table, but you need to check for the absence of this column.

ALTER TABLE jshopping_orders ADD bonus varchar(24) NOT NULL DEFAULT '';

Answer 1

MariaDB allows the syntax:

ALTER TABLE jshopping_orders ADD COLUMN IF NOT EXISTS bonus varchar(24) NOT NULL DEFAULT '';

View MariaDB fiddle