Mysql 内连接与外连接

Mysql 内连接与外连接

  • 建表语句
1
2
3
4
5
6
7
8
9
10
11
CREATE TABLE `a_table` (
`a_id` int(11) DEFAULT NULL,
`a_name` varchar(50) DEFAULT NULL,
`a_part` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `b_table` (
`b_id` int(11) DEFAULT NULL,
`b_name` varchar(50) DEFAULT NULL,
`b_part` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×