How to create an insert Trigger

Question

I need to assemble a trigger so that every time you insert a data into a table usuario, automatically insert the same data into another table bkuser. How can I do this? PHP Usage. And how do you invoke trigger?

Answer 1

Trigger is related to the database and not the language.

A Rigger is created just to be automatically invoked before or after something.

For example, I can create a log for audit, always after updating some record in the table that has Trigger. Example:

create table usuarios (
    id int primary key auto_increment,
    nome varchar (45) not null
);

create table usuarios_alteracoes_historico (
    id_usuario int not null,
    nome varchar (45) not null,
    constraint fk_usuario_historico_alteracao foreign key (id_usuario) references usuarios (id)
);

CREATE TRIGGER usuarios_salva_historico
AFTER UPDATE ON usuarios
FOR EACH ROW BEGIN
INSERT INTO usuarios_alteracoes_historico (id_usuario, nome) VALUES
(NEW.id, OLD.nome); END//

insert into usuarios (nome) values
('william'), ('roberto');

update usuarios set nome = 'william okano' where nome = 'william';

select * from usuarios;
select * from usuarios_alteracoes_historico;

In the case to "activate the Trigger" you just have to make an Insert in the table users that will be "transparent" for you to insert in the history table.

It’s up to you now to adapt to what you need, as your question is poorly elaborated and confused.