sql - Update and Select MYSQL, Convert Unixtime to timestamp -

got minor issue, im working on old old database layout did not self.

the 1 hu created used unix timestamps everything, want converte in normal mysql timestamp, know can from_unixtimestam function.

but need crap unix timestamp column called last_login , converte timestamp , save value last_login_sql

how heck this?

table name: kunstner column name of unix timestamp: last_login column name of timestamp: last_login_sql

there id column ofc.

hope can me out here.

as saving new value, should work:

update kunstner set last_login_sql = unix_timestamp(last_login)