Data Definition Using MySQLppt使用mysqlppt数据定义.ppt

Data Definition Using MySQL tMyn Internet Application Development tMyn, Mikkeli University of Applied Sciences Data Definition Using MySQL Many features are covered using ISO SQL standard. All the examples are done using MySQL. SQL identifiers are used to identify objects in the database, such as table names and columns. The characters that can be used in a user-defined SQL identifier must appear in a character set. The ISO standard provides a default character set, which consists of uppercase letters A…Z, the lowercase letters a…z, the digits 0…9, and the underscore (_) character. The following restrictions are imposed on an identifier: An identifier must start with a letter An identifier cannot contain spaces Character data consists of a sequence of characters from an implementation-defined character set. The format for specifying a character data type is: CHARACTER [VARYING][length] CHARACTER can be abbreviated to CHAR and CHARACTER VARYING to VARCHAR A character string may be defined as having a fixed or varying length. If the string is defined to be a fixed length and we enter a string with fewer characters than this length, the string is padded with blanks on the right to make up the required size. If the string is defined to be of varying length and we enter a string with fewer characters than this length, only those characters entered are stored, thereby using less space. The exact numeric data type is used to define numbers with an exact representation. The number consists of digits, an optional decimal point, and an optional sign. An exact numeric data type consists of a precision and scale. The precision gives the total number of significant decimal digits, that is, the total number of digits, including decimal places but excluding the point itself. The scale gives the total number of decimal places. There are several ways of specifying an exact numeric data type, for example: NUMERIC [precision[, scale]] DECIMAL [precision[, scale]] INTEGER IN