I tried to add a column to my table where the integer needs to be in between 01067 and 99998. But The problem is that I don't know how to specify the range of an integer in SQL, so I tried it with the BETWEEN Operator, but I still didn't work. I'm using MariaDB 10.4 and PhpMyAdmin, just for your knowledge.
This is the error: #1064 - you have an error in your SQL syntax
This is my code:
ALTER TABLE p_infos ADD plz SMALLINT (plz BETWEEN 01067 AND 99998);