Help in mysql?
Posted: Fri Feb 12, 2010 5:20 am
I have mysql database and contains table "act" which have 4 fields name
id, name, date_birth, date_of_retire
1 Jam 03-09-1987
2 Johnson 04-01-1992
I want to set a query for 'date_of_retire' as that it adds 60 years with 'date_birth' and display in
'date_of_retire' field.
please help.
Adil
id, name, date_birth, date_of_retire
1 Jam 03-09-1987
2 Johnson 04-01-1992
I want to set a query for 'date_of_retire' as that it adds 60 years with 'date_birth' and display in
'date_of_retire' field.
please help.
Adil