初夏小谈：MySQL之多表联合增删查改

1.多表联合插入数据

insert into class(test_num) select num from test where name = 'jack';
update test t, class c set c.class_name = '英语' where t.num = c.test_num and t.name = 'jack'

2.多表联合删除数据

delete 表名 from 表1, 表2 where 表1.num = 表2.test_num and 表1.name = 'jack'
delete class from test, class where test.num = class.test_num and test.name = 'jack'

3.多表联合查找数据

select class.test_num, class.class_name from test, class where test.name = 'jack'

4.多表联合更新数据

update test t, class c set c.class_name = '英语' where t.num = c.test_num and t.name = 'jack'

                                                                                                                                                            珍&源码