有两张表:user和department
User表:
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) DEFAULT NULL,
`age` int(11) DEFAULT NULL,
`birthday` date DEFAULT NULL,
PRIMARY KEY (`id`)
)
INSERT INTO USER VALUE(NAME,age,birthday)
VALUES("张三",20,"2018-10-31");
表内数据如下:
部门表:
CREATE TABLE `department` (
`id` bigint(11) NOT NULL,
`name` varchar(10) NOT NULL,
`descr` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
)
INSERT INTO department (id,NAME,descr)
VALUES(1,"开发部","开发高级产品