问在两张表中插入？

EN

CREATE TABLE IF NOT EXISTS `baseuser` (
    `id` int(11) NOT NULL,
    `uname` varchar(55) NOT NULL,
    `pwd` varchar(55) NOT NULL
  ) ENGINE=InnoDB ;

CREATE TABLE IF NOT EXISTS `facultydet` (
  `id` int(11) NOT NULL,
  `baseuser_id` int(11) NOT NULL,
  `department` varchar(55) DEFAULT NULL
) ENGINE=InnoDB;

CREATE ALGORITHM = MERGE
 VIEW `facultyuser`
 AS SELECT `baseuser`.`id` AS `id`, `uname`, `pwd`, `department` 
 FROM `baseuser`, `facultydet` 
 WHERE `facultydet`.`baseuser_id` = `baseuser`.`id`;