Setting LastUpdated to a future date

[BetterDeadThanZed]

I'm om the process of overhauling one of my servers and it'll be offline for a few days. I don't want my player's bases and vehicles to be cleaned up during the down time,  so I need an SQL query that will set the LastUpdated to a future time for all objects in the object_data section. What is the SQL query I would use?

[LunatikCH]

You can try this:

UPDATE epoch.object_data SET LastUpdated = 2018-03-25 16:24:02

[BetterDeadThanZed]

You can try this:

UPDATE epoch.object_data SET LastUpdated = 2018-03-25 16:24:02

 

Thanks for the reply, but I get this with that query:

 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[ElDubya]

UPDATE epoch.object_data SET LastUpdated = 2018-03-25 16:24:02 

 

Do you have a table called epoch.object_data?

[BetterDeadThanZed]

UPDATE epoch.object_data SET LastUpdated = 2018-03-25 16:24:02 

 

Do you have a table called epoch.object_data?

 

I have a table called object_data and I removed the epoch. part before using the query.