Consider the below example,
1)Create the below table,
2) Execute "SHOW CREATE TABLE `t1`"
3) Copy the result returned by the query executed in Step-2.
4) Execute the copied query in Step-3 after renaming the table name
5) The query execution will fail due to incorrect syntax. The issue is "COMMENT" column_definition comes after the 'CHECK' constraint_definition. Refer the MariaDB create table syntax >> https://mariadb.com/kb/en/library/create-table/