mysql 删除

fyggzb 2020-06-10

mysql -u$DB_USER -p$DB_PASS reviewdb -e "DELETE FROM account_project_watches WHERE project_name=‘openstack/openstack-ci‘;"
mysql -u$DB_USER -p$DB_PASS reviewdb -e "DELETE FROM changes WHERE dest_project_name=‘openstack/openstack-ci‘;"
mysql -u$DB_USER -p$DB_PASS reviewdb -e "DELETE FROM submodule_subscriptions WHERE submodule_project_name=‘openstack/openstack-ci‘;"

-e, --execute=name  Execute command and quit. (Disables --force and history file.)

sudo mv ~gerrit2/review_site/git/{openstack-attic/akanada,openstack-attic/akanda}.git  #这种mv方式,值得学习
sudo mv /opt/lib/git/{openstack-attic/akanada,openstack-attic/akanda}.git

相关推荐