Tag:Total external

  • Multi table join query and sub query of MySQL

    Time:2022-2-12

    1. Preliminary preparation #Build table create table department( id int, name varchar(20) ); create table employee( id int, name varchar(20), sex enum(‘male’,’female’), age int, dep_id int ); #Insert data insert into department values (200, ‘technology’), (201, ‘human resources’), (202, ‘sales’), (203, ‘operation’); insert into employee(id,name,sex,age,dep_id) values (1,’cai’,’male’,18,200), (2,’liu’,’female’,48,201), (3,’ling’,’male’,38,201), (4,’liangliang’,’female’,28,202), (5,’acai’,’male’,18,200), (6,’bao’,’female’,18,204) ; 2. Connected […]