mysql - how treat the database record that are not activated or how to prevent it -

we have user table record user sign in our website, might not activate it

our practice 1 time user register, record store in our table, 1 time user click activation link, activation code alter ' ' (empty)

if record did not activated, email can't utilize , in our table

whats best practice or solution this?

create new table store activation code , insert user table 1 time activated?

or leave that? there waste store it

or improve solution this?

i used way:

a temporary table containing temporary accounts (not yet activated) a table containing accounts (activated)

thanks this, can spare spaces in main business relationship table , can add together task (for example, each week) remove old temporary accounts.

when user activates account, move info temporary main table.

mysql website

Three