Skip to content

Instantly share code, notes, and snippets.

@kermie
Created March 17, 2014 10:40
Show Gist options
  • Save kermie/9597158 to your computer and use it in GitHub Desktop.
Save kermie/9597158 to your computer and use it in GitHub Desktop.
remove all product and category items at once
TRUNCATE TABLE `oxarticles`;
TRUNCATE TABLE `oxcategories`;
TRUNCATE TABLE `oxcategory2attribute`;
TRUNCATE TABLE `oxartextends`;
TRUNCATE TABLE `oxaccessoire2article`;
TRUNCATE TABLE `oxactions2article`;
TRUNCATE TABLE `oxobject2action`;
TRUNCATE TABLE `oxobject2article`;
TRUNCATE TABLE `oxobject2attribute`;
TRUNCATE TABLE `oxobject2category`;
TRUNCATE TABLE `oxobject2delivery`;
TRUNCATE TABLE `oxobject2discount`;
TRUNCATE TABLE `oxobject2group`;
TRUNCATE TABLE `oxobject2list`;
TRUNCATE TABLE `oxobject2payment`;
TRUNCATE TABLE `oxobject2selectlist`;
TRUNCATE TABLE `oxobject2seodata`;
@kermie
Copy link
Author

kermie commented Mar 17, 2014

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment