Newer MySQL/MariaDB versions are more strict about type restrictions, and do not like to coerce an empty string to NULL on a numeric column type. Here we make sure that non-numeric user input is dropped, and NULL is stored when a number isn't passed to the input form.
andyp-uk
commented
7 months ago
Newer MySQL/MariaDB versions are more strict about type restrictions, and do not like to coerce an empty string to NULL on a numeric column type. Here we make sure that non-numeric user input is dropped, and NULL is stored when a number isn't passed to the input form.