This time I'm going to write it down!
November 4, the first exam, the content of the exam is about the MySQL query command, the test of a morning, took the question to a face, not kidding, I thought the problem will be very simple! The result is I think too much ....
Give some examples:
Identify all people with the same native origin as "Qin Yi" (Qin Yi: MMP)
SELECT * from Stu where jg= (select JG from Stu where name= "Qin Yi");
Find out the department information of Hebei People (Hebei people strongly condemn)
SELECT * from Yxinfo where id= (select Yxid from Stu where jg= "Hebei");
Find information about all students in the same department as Fujian girls (Fujian girls are eaten by Cantonese)
SELECT * from Stu where yxid= (select Yxid from Stu where jg= "Fujian" and sex= "female");
Have to say there are many places to learn, these things if not often look, want to remember the real difficulties, let alone master
Again, the code to write a two of the problem is not big, but put a bunch in front of me ... I have to admit, I may be suffering from intense phobia. _ (: З"∠) _
Third day of training for the Oracle (ZIBO) test staff