Skip to content

Instantly share code, notes, and snippets.

@mactive
Created March 27, 2011 14:19
Show Gist options
  • Save mactive/889239 to your computer and use it in GitHub Desktop.
Save mactive/889239 to your computer and use it in GitHub Desktop.
clean onecity test db
UPDATE `lenovo_one`.`sm_category`
SET `is_upload` = '0',`is_audit_confirm` ='0',`audit_status` ='0'
WHERE `sm_category`.`cat_id` > 1;
TRUNCATE TABLE `sm_city`;
TRUNCATE TABLE `sm_city_audit`;
TRUNCATE TABLE `sm_city_ad`;
TRUNCATE TABLE `sm_city_temp`;
TRUNCATE TABLE `sm_city_gallery`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment