I would like to know how to change the years in a database. Suppose the database posts and join dates are dated 2012, I would like to date them to 2013 using query.
Is it possible to replace all datelines with a particular dateline?
^ users table consists of registered date, last active date, last visit date, last post date.
they all can be changed for all users or selected user groups.
like that posts and threads table consist of posted date, edited date and last post date.
all these can be changed for posts / threads.
(2013-05-20, 08:39 AM).m. Wrote: [ -> ]^ users table consists of registered date, last active date, last visit date, last post date.
they all can be changed for all users or selected user groups.
like that posts and threads table consist of posted date, edited date and last post date.
all these can be changed for posts / threads.
But it's gonna take days to do it manually.
^ please post your actual requirement so that someone can provide the SQL queries.
Changing at dates between April to December 2012 to May 2013.