MySQL培训2(培训教程).ppt

* RHEL Clustering Storage Management page:* Every table must belong to a database That is, you cannot create a table that is not located within some database If the table named in the CREATE TABLE statement is not qualified with a database name, the table is created in the default database To indicate explicitly where to create the table, you can qualify the table name with the name of the desired database, using db_name.table_name syntax * RHEL Clustering Storage Management page:* Creating table with indexes When you create a table, you can provide index definitions in addition to the column definitions. Indexes are useful for speeding up queries by reducing record lookup: CREATE TABLE employee ( id INT NOT NULL, last_name CHAR(30) NOT NULL, first_name CHAR(30) NOT NULL, UNIQUE (id), INDEX (last_name, first_name) ); * RHEL Clustering Storage Management page:* Specifying the Storage Engine for a Table Every table is created using one of the storage engines supported by the server The set of storage engines available depends both on how the server was compiled when it was built and on the options used at startup To see which storage engines your server supports, use the SHOW ENGINES statement: * RHEL Clustering Storage Management page:* Specifying the Storage Engine for a Table To specify a storage engine when you create a table, include an ENGINE = engine_name option in the CREATE TABLE statement: CREATE TABLE users (id INT) ENGINE = InnoDB; The ALTER TABLE statement allows you convert a table from one storage engine to another: ALTER TABLE users ENGINE = MyISAM; If a CREATE TABLE statement includes no ENGINE option, MySQL creates the table using the default storage engine, which is determined from the value of the storage_engine system variable * RHEL Clustering Storage Management page:* Set the default Engine Specified at server startup with the --default-storage-engine option For a running server, an administrator who has the SUPER privilege ca