Got it, use SELECT RAISE(FAIL, 'msg');

I have the same question After looking up online, it should be something like CREATE TRIGGER abort delete from my tbl BEFORE DELETE ON my tbl BEGIN SELECT RAISE(ABORT, 'You can''t delete records from my tbl'); END; However, my output runs perfectly, b...

Maybe because the city and phone condition arrears in the WHERE clause? (Since city and phone are column names only, not aggregate functions). As far as I understand, if there are column names in the HAVING clause, they must be in the GROUP BY clause,...