You can call this procedure from your application code where needed
delimiter // create procedure insert_customer(IN a INT) begin insert into customer (id) values (a); end // delimiter ;