Well, the obvious question is, why are you inserting data into your database you don't want? It makes more sense to just not do the insert.
But, assuming perhaps you have no control over the client, you can create a BEFORE INSERT trigger that rejects the inserts that don't match your condition:
On Fri, Mar 15, 2019 at 10:55 AM basti <mailinglist@xxxxxxxxxxxxxxxx> wrote:
Hello,
I want to insert data into table only if condition is true.
For example:
INSERT into mytable (domainid, hostname, txtdata)
VALUES (100,'_acme.challenge.example', 'somedata');
The insert should only be done if Hostname like %_acme.challenge%.
How can it be done? I dont want that the user/script can insert any value.
Best regards.
