Insert ID into another field of the same table at the time of INSERT

Question

I’m in the following situation, I’ve been searching the net and found similar aids but not what I really need to know and I don’t even know if it’s possible!

Come on! There would be some way for me to put the ID number that will be inserted in the INSERT query and clone it to another field of the same table but, all of this in the same query?

---

table:

users

fields:

id (Auto increment)

id_member

---

I would like to do a query where the number that will be generated in the id field is also placed in the id_member field.

Thanks!

Answer 1

Create a TRIGGER AFTER INSERT to accomplish a UPDATE:

CREATE TRIGGER new_loaner_added
AFTER INSERT ON usuarios
FOR EACH ROW
  UPDATE usuarios
     SET id_membro = NEW.id
   WHERE id = NEW.id;

---

TRIGGER

A Trigger is a named database Object that is Associated with a table, and that activates when a particular Event occurs for the table.

In free translation:

A Trigger is a database named object that is associated with a table, and is activated when a particular event occurs for the table.