users and users_info , I would like to use foreign key, so when I create a record in the users table, create a record with the empty fields in the users_info table, only with the id_user completed, is it possible?
I think it would look like this, remember that the fields of the user_info table should allow null values.
CREATE TRIGGER tg_user
AFTER INSERT ON users
FOR EACH ROW
INSERT INTO user_info (id_user, outro_campo, exemplo)
SELECT NEW.id, NULL, NULL
FROM users
WHERE id = NEW.id