How to limit the number of records in a table with a specific field?

Question

MySQL

Hello. Is it possible to somehow limit the number of records with a certain field in the database without triggers and procedures?
For example, there is a table in which there is a user_id field, is it possible to make a user with a user_id, for example 5, be able to make only 10 entries.

Answer 1

start transaction
select count(*) from ... where user_id = ... for update

and then we look at the YaP - you can insert it or not.

Answer 2

Do COUNT(*) before INSERT for example