Let me ask you a question. The name of T1 does not exist in T2. It doesn"t come around a bit. The name in T2 not in T1 is still not correct
.
Let me ask you a question. The name of T1 does not exist in T2. It doesn"t come around a bit. The name in T2 not in T1 is still not correct
. T1, name does not exist in T2: what exists in T2 is noncompliant data
SELECT * FROM T1 WHERE NAME NOT IN (SELECT NAME FROM T2)
that is, the union of T1 and T2 minus T2,
select t1.name from T1 left join T2 on t1.name=t2.name where t2.name is null;
Previous: How to realize the reverse check of whois mailbox and registrant by PHP
Next: Is there a closure in this immediate execution function?
< table > < thead > < tr > < th > now the query result in mysql has the following columns. You want it to output "adv. ". Choose between the two, otherwise, or "how do you write this sql? < th > < tr > < thead > < tbody > < tr > < td > pid < td ...
how does 1.mysql export a data table of 6 million records? 2. I ve tried that direct export will overload the database. ...