数据库系统原理(英文)-4-11.pptVIP

March 2011 Database System Concepts - Chapter4 Advanced SQL - PART 2 RELATIONAL DATABASES Chapter 4 Advanced SQL Integrity constraints in SQL §4.1-4.2 Security in SQL (§4.3) authorization, grant/revoke Embedded and dynamic SQL §4.4-4.5 4.1.1 Built-in Data Types in SQL In addition to the basic data types, e.g. char(n), varchar(n), int, smallint, numeric(p, d), real, double precision, float(n), described in §3.2, the other built-in data types include date: Dates, containing a (4 digit) year, month and date e.g. date ‘2005-7-27 time: Time of day, in hours, minutes and seconds e.g. tim