云托管软件删除的脚本

1. //查询项目包名
   
2. SELECT id FROM saas_suite_application WHERE site_id='Z01618';
   
3. 
   
4. //查询对应的ID值
   
5. -- SELECT * FROM saas_suite_menu WHERE application_ID =(SELECT id FROM saas_suite_application WHERE site_id='Z01618');
   
6. 
   
7. //删除软件Application_id
   
8. -- DELETE FROM  saas_suite_menu  WHERE application_ID ='884cb167-2d72-4758-95a2-82d351ddff6b'
   
9. 
   
10. //删除对应应用的ID
    
11. -- DELETE FROM  `saas_suite_application` WHERE site_id='Z01618' AND ID='884cb167-2d72-4758-95a2-82d351ddff6b'

复制代码