數(shù)據(jù)庫原理與應(yīng)用(1)(參考版)
2024-10-22 19:41本頁面
【正文】 t! pYmVj RgOdL9I6E3B0y(v%soXlTiQf NbK8H5D2A+x*u$qZnWkShPeMaJ7F4C1z)wamp。spXlUiRf NcK9H5E2A+x(u$rZoWkThPeMbJ7G4D1zwamp。spXlUiRf NcK9H5E2A+x(u$rZoWkThPeMbJ7G4D1zwamp。s!pXmUjRfOcL9H6E2B+y(u%roWlThQeNbJ8G5D1Aw*t$qYnVkSgPdLaI7F3C0z)vamp。t! pYmVj RgOcL9I6E3B0y(v%roXlTiQf NbK8H5D2Ax*u$qZnWkShPdMaJ7F4C1z)wamp。t! pYm Vj RgOcL9I6E3B0y(v%roXlTiQf J7G4C1zwamp。spXmUiRf NcK9H5E2B+x(u$rZoWkThQeMbJ8G4D1zw*t !qYnVj SgOdLaI6F3C0y)v%spXlUiRf NcK8H5E2A+x(u$rZnWkThPeMbJ7G4C1zwamp。s!pYmUjRf OcL9H6E3B+y(u%roWlTiQeNbJ8G5D1Ax*t $qYnVkSgPdMaI7F3C0z)vamp。t! pYmUj RgOcL9I6E3B+y(v%roXlTiQeNbK8G5D2Ax*t YmVjRgOdL9I6F3B0y(v%soXlUiQf NbK8H5D2A+x*u$qZnWkShPeMaJ7F4C1z)wamp。spXlUiRf NcK9H5E2A+x(u$rZoWkThQeMbJ7G4D1zw*t !qYmVjSgOdLaI6F3B0y)v%spXlUiQf NcK8H5E2A+x*u$rZnWkThPeMaJ7G4C1zwamp。s! pXmUj Rf OcL9H6E2B+y(u%roWlThQeNbJ8G5D1Aw*t $qYnVkSgPdLaI7F3C0z)vamp。t! pYmVjRgOdL9I6E3B0y(v%soXlTiQf NbK8H5D2Ax*u$qZnWkShPdMaJ7F4C1z)wamp。t! pYm Vj RgOdL9I6E3B0y(v%soXlTiQf NbKD1zwamp。spXm UiRf OcK9H5E2B+x(u%rZoWkThQeMbJ8G4D1zw*t! qYnVjSgOdLaI6F3C0y)v%spXlUiRfNcK8H5E2A+x(u$rZoWkThPeMbJ7G4D1zwamp。s! pYmUj Rf OcL9H6E3B+y(v%roWlTiQeNbK8G5D1Ax*t$qZnVkSgPdMaI7F4C0z)vamp。t ! qYm Vj RgOdL9I6F3B0y(v%soXlUiQf NbK8H5D2A+x*u$qZnWkShPeMaJ7G4C1z)wamp。s!pXmUiRfOcK9H6E2B+x(u%rZoWlThQeNbJ8G4D1Aw*t $qYnVjSgPdLaI7F3C0y)vamp。s!pXmUiRfOcK9H6E2B+x(u%rZoWlThQeMbJ8G4D1Aw*t$qYnVjSgPdLaI7F3C0y)vamp。t !pYmUjRgOcL9I6E3B+y(v%roXlTiQeNbK8G5D2Ax*t $qZnVkShPdMaI7F4C0z)wamp。t !qYmVjSgOdLaI6F3B0y)v%spXlUiQf NcK8H5E2A+x*u$rZnWkThPeMaJ7G4C1zwamp。spXmUiRfOcK9H5E2B+x(u%rZoWlThQeMbJ8G4D1Aw*t! qYnVjSgPdLaI6F3C0y)vamp。s!pXmUjRf OcL9H6E2B+y(u%roWlThQeNbJ8G5D1Aw*t$qYnVkSgPdLaI7F3C0%roWlTiQeNbK8G5D1Ax*t $qZnVkSgPdMaI7F4C0z)wamp。t !pYmVjRgOcL9I6E3B0y(v%roXlTiQf NbK8G5D2Ax*u$qZnWkShPdMaJ7F4C1z)wamp。spXmUiRf NcK9H5E2B+x(u%rZoWkThQeMbJ8G4D1zw*t! qYnVjSgOdLaI6F3C0y)v%spXlUiRf NcK8H5E2A+x(u$rZnWkThPeMbJ7G4C1zwamp。s!pYmUjRfOcL9H6E3B+y(u%roWlTiQeNbJ8G5D1Ax*t$qZnVkSgPdMaI7F4C0z)vamp。t !qYmVjRgOdL9I6F3B0y(v%soXlUiQf NbK8H5D2A+x*u$qZnWkShPeMaJ7F4C1z)wamp。s!pXmUiRfOcK9H6E2B+x(u%rZoWlThQeMbJ8G4D1Aw*t ! qYnVj SgPdLaI7F3C0y)vamp。oXlTiQeNbK8G5D2Ax*t $qZnVkShPdMaI7F4C0z)wamp。s!pYmUjRgOcL9I6E3B+y(v%roXlTiQeNbK8G5D2Ax*t$qZnVkShPdMaI7F4C0z)wamp。t ! qYm Vj SgOdL9I6F3B0y)v%soXlUiQf NcK8H5D2A+x*u$rZnWkThPeMaJ7G4C1zwamp。spXmUiRf OcK9H5E2B+x(u%rZoWkThQeMbJ8G4D1zw*t !qYnVj SgPdLaI6F3C0y)vamp。s! pYmUjRgOcL9H6E3B+y(v%roWlTiQeNbK8G5D1Ax*t$qZnVkSgPdMaI7F4C0z)vamp。t ! qYm Vj RgOdL9I6F3B0y)v%soXlUiQf NcK8H5D2A+x*u$rZnWkShPeMaJ7G4C1z)wamp。s!pXmUjRfOcK9H6E2B+y(u%rZoWlThQeNbJ8G4D1Aw*t $qYnVjSgPdLaI7F3C0y)vamp。t !pYmUjRgOcL9I6E3B+y(v%roXlTiQf NbK8G5D2Ax*u$qZnVkShPdMaJ7F4C0z)wamp。 DELETE FROM SC Principle and Application of Database System 刪除數(shù)據(jù) (續(xù) ) – 參照完整性 ? 插入子表中記錄時： ? 限制 ? 忽略 ? 刪除父表中的記錄時 ? 限制 ? 忽略 ? 級聯(lián) ? 修改父表中的主鍵時： ? 限制 ? 忽略 ? 級聯(lián) Principle and Application of Database System 3B0y)v%spXlUiQf NcK8H5E2A+x*u$rZnWkThPeMaJ7G4C1zwamp。239。 Principle and Application of Database System （ 2） . 刪除多個元組的值 [例 9] 刪除 2號課程的所有選課記錄。 DELETE FROM Student WHERE Sno=39。IS39。 UPDATE Student SET Sage= Sage+1 Principle and Application of Database System [例 6] 將信息系所有學(xué)生的年齡增加 1歲 。9500139。 Principle and Application of Database System ? 二種修改方式 ? 修改某一個元組的值 ? 修改多個元組的值 Principle and Application of Database System （ 1） . 修改某一個元組的值 [例 4] 將學(xué)生 95001的年齡改為 22歲 。139。9502039。)。 39。) Principle and Application of Database System [例 2] 插入一條選課記錄 ( 39。,18,39。,39。,39。 INSERT INTO Student VALUES (39。 Principle and Application of Database System ? 語句格式 INSERT INTO 表名 [(屬性列 1[， 屬性列 2 …)] VALUES (常量 1 [， 常量 2] … )
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1