PHP培训课件第五讲.ppt

MySQL数据库(2)
MySQL语法的奥秘
我们将深入介绍MySQL支持的SQL。可以将他们分为七大类:
、删除与选用数据库(database)
create database
drop database
use
2. 建立、改变、删除数据表(table)与索引
(index)
ALTER TABLE
CREATE TABLE
CREATE INDEX
DROP TABLE
DROP INDEX

DESCRIBE
EXPLAIN
SHOW

SELECT

DELETE
INSERT
UPDATE
LOAD DATA
REPLACE
OPTIMIZE TABLE

FLUSH
GRANT
KILL
REVOKE

CREATE FUNCTION
DROP FUNCTION
LOCK TABLE
SET
UNLOCK TABLE
用法举例:
CREATE DATABASE
语法:
CREATE DATABASE db_name
例子:
mysql>create database cars;
DROP DATABASE
语法:
DROP DATABASE [if exists] db_name
例子:
mysql>drop database cars;
USE
语法:
USE db_name
例子:
USE cars;
CREATE TABLE
语法:
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)]
[table_options] [select_statement]