SQLize Online / PHPize Online  /  SQLtest Online

-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE abonents ( id serial, last_name varchar(64), address varchar(64), phone varchar(64) ); CREATE OR REPLACE RULE name_rule_update AS ON UPDATE TO abonents WHERE NEW.last_name <> OLD.last_name AND NEW.last_name NOT LIKE '[А-я]%' DO INSTEAD SELECT 'S'; INSERT INTO abonents (last_name, address, phone) VALUES ('Petrov', 'Pobeda 9, 1', '8909999231'); SELECT * FROM abonents; UPDATE abonents SET last_name = 'Sidorov' WHERE last_name = 'Petrov'; SELECT * FROM abonents; UPDATE abonents SET last_name = 'Сидоров' WHERE last_name = 'Petrov'; SELECT * FROM abonents;