MariaDB [test]> CREATE TABLE candidates (

    ->     candidate_id NUMBER,

    ->     first_name VARCHAR2(50) NOT NULL,

    ->     last_name VARCHAR2(50) NOT NULL,

    ->     job_title VARCHAR2(255) NOT NULL,

    ->     year_of_experience INTERVAL YEAR TO MONTH,

    ->     PRIMARY KEY (candidate_id)

    -> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INTERVAL YEAR TO MONTH,

    PRIMARY KEY (candidate_id)

)' at line 6