结构化查询语言SQL的组成.pptVIP

SQL: Queries, Constraints, Triggers Chapter 5 SQL的组成 The Data Definition Language(DDL)create table ,alter table, drop table, create view… The Data Manipulation Language(DML)select , insert ,delete, update The Date Control Language (DCL)grant , revoke Example Instances We will use these instances of the Sailors and Reserves relations in our examples. If the key for the Reserves relation contained only the attributes sid and bid, how would the semantics differ? Basic SQL Query relation-list A list of relation names (possibly with a range-variable after each name). target-list A list of at