A LEFT OUTER JOIN (or simply LEFT JOIN) in MySQL is used to retrieve all records from the "left" table, and the matched records from the "right" table. If there is no match, NULL values are returned ...
create table student(id int auto_increment primary key,name varchar(10) unique key,gender enum('男','女'),provence varchar(10),college_id int); insert into student ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results