DELETE FROM object_data

[ShoobieStomper]

Hey, guys! I have been doing a lot of research on SQL, but I cannot seem to figure this out. I want to delete all of the vehicles from my server because I have changed some settings in my init.sqf. I would like to make a batch file to do so. I am using MySQL Workbench along with XAMPP. They are both installed in the same folder on my desktop.

I think this is the right code, but I don't know how to lump it all into a batch file.

DELETE FROM object_data

Thanks in advance! :-)

P.S. I tried to delete all of the vehicles directly in MySQL Workbench, but I couldn't get it to work.

[cen]

DELETE FROM 
`Object_DATA`
WHERE `Classname` 
NOT REGEXP 'land|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort|sand|scaffold|misc|nest|parachute|border';

 

[ShoobieStomper]

DELETE FROM 
`Object_DATA`
WHERE `Classname` 
NOT REGEXP 'land|storage|shed|bench|wall|floor|fence|pump|wood|hrescue|stick|pole|generator|panel|house|rack|bag|stand|barrel|canvas|wire|hedgehog|net|trap|ramp|fort|sand|scaffold|misc|nest|parachute|border';

 

Thank you! Can I add that to a batch file?

[Richie]

Run it as an scheduled event, read more Here

[ShoobieStomper]

Thanks, guys! It worked great! :-)