关于mysql外键查询的疑问，如下图和代码

Question

如下，建立两张表，怎么curd使2张表同时发生改变,就是查询出两张表的数据这种，另外再问一下，实际项目中使用这种方式多吗

my_class

CREATE TABLE `my_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(20) NOT NULL,
  `room` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

my_foreign1

CREATE TABLE `my_foreign1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL COMMENT '学生姓名',
  `c_id` int(11) DEFAULT NULL COMMENT '班级id',
  PRIMARY KEY (`id`),
  KEY `c_id` (`c_id`),
  CONSTRAINT `my_foreign1_ibfk_1` FOREIGN KEY (`c_id`) REFERENCES `my_class` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

只会单表查询

my_foreign1

use test521;
insert into my_foreign1 (name,c_id) VALUES ('cccc',1);
update my_foreign1 set name = "ccccccc" where id = 1;
select * from my_foreign1;
delete from my_foreign1 where id =1;

my_class

insert into my_class (name,room) VALUES ('aaa',1);
insert into my_class (name,room) VALUES ('bbb',2);

Answer 1

一个插入语句只能插入一张表。