数据库系统概念第四章.ppt

PrinciplesofDatabaseSystemsIntermediateSQL1.

ConstituentPartsofSQL(SQL组成部分)TheSQLlanguagehasseveralparts:Data-de?nitionlanguage(DDL)Data-manipulationlanguage(DML)Integrity(完整性)(includedinDDL)Viewde?nition(视图定义)(includedinDDL)Transactioncontrol(事务控制)Authorization(授权)EmbeddedSQLanddynamicSQL(嵌入式SQL及动态SQL)SSDUT-SoftwareSchoolofDUT2

JoinExpressionsSSDUT-SoftwareSchoolofDUT3

SSDUT-SoftwareSchoolofDUT4

ReviewJoinandNaturalJoinselect*

fromstudent,takes

wherestudent.ID=takes.ID;select*

fromstudentnaturaljointakes;select*

fromstudentjointak