SQL语句---多表联查、改、删

2023年8月3日发(作者：)

SQL语句---多表联查、改、删SQL语句—多表联查、改、删1.多表联查select*

from Student t1 inner join Teacher t2 on =e ='Mimo_YY'2.多表联改update t1set ='Mimo_YY',='16'from Student t1 inner join Teacher t2 on =e ='Mimo_YY'3.多表联删delete t1from Student t1 inner join Teacher t2 on =e ='Mimo_YY'写法需要注意的点：update、delete后加表名update更新多个值 时，字段之间⽤‘，’ 隔开

2023年8月3日发(作者：)

SQL语句---多表联查、改、删SQL语句—多表联查、改、删1.多表联查select*

from Student t1 inner join Teacher t2 on =e ='Mimo_YY'2.多表联改update t1set ='Mimo_YY',='16'from Student t1 inner join Teacher t2 on =e ='Mimo_YY'3.多表联删delete t1from Student t1 inner join Teacher t2 on =e ='Mimo_YY'写法需要注意的点：update、delete后加表名update更新多个值 时，字段之间⽤‘，’ 隔开