MySQL Common data query

1. The associated query modifies the update ex_question_questioncategory T5INNER JOIN (SELECT QC. Question_id,qc. question_category_id from Ex_question_questioncategory QC right JOIN(SELECT q.question_id,q.content from Ex_ Question Q WHERE q.content like '% keyword% ') T1on QC. question_id =t1. question_id) t2on T5. Question_id=t2. Question_idset T5. Question_category_id= ' f39d2a3e49c0b98f0149c1f4cd9f0022 ' 2.--query a table for data that does not exist in table B (there is a foreign key in A:domain,b:resource) select A. * FROM Sys_domain a where isn't EXISTS (select B.DOMAIN_FK from Sys_resource b where A.DOMAIN_ID=B.DOMAIN_FK)

MySQL Common data query