how to take data from one mysql table and insert it into another :?

Question

I’m trying to do brush validator (serial), but I don’t know how to do it.

I have two tables: "validation" and "maturity".

In the "validation" table, you have the following fields:

id(int), data(varchar), pincode(varchar), status(int)

In the "maturity" table, you have the following fields:

id(int), data(varchar)

I wanted to take the data from the validation table (date) and update to the expiration table but will only update if the serial is right when typing ! and if the status etiver 0 !

exemplo: 
0 = ainda não ativou!
1 = ja foi ativado !

someone could help me ?

Answer 1

Assuming that the id be it autoincrement:

INSERT INTO vencimento(data)
SELECT v.data
  FROM validacao v
 WHERE v.pincode = 'xxxxxxx'
   and v.status = 0;