關(guān)于mysql外鍵查詢的疑問，如下圖和代碼

如下，建立兩張表，怎么curd使2張表同時(shí)發(fā)生改變,就是查詢出兩張表的數(shù)據(jù)這種，另外再問一下，實(shí)際項(xiàng)目中使用這種方式多嗎

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 '學(xué)生姓名',
  `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;

只會(huì)單表查詢

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);