一个简单的MySQL数据库脚本

                                                       一个简单的MySQL数据库脚本

         这段时间因为项目需要学习了MySQL数据库，贴一个关于创建数据库，数据表，用户的MySQL脚本，和大家分享。

-- --Create Database -- create database if not exists new_db character set = 'gb2312' collate = 'gb2312_chinese_ci'; -- --Create Table -- use new_db; drop table if exists Customer; create table Customer ( CustomerID smallint unsigned not null primary key auto_increment, Name varchar(20) not null, Gender ENUM('M', 'F') not null, /*M->Male, F->Female*/ Address varchar(25) not null default ' ', Telephone smallint unsigned not null default '0' )engine = InnoDB default charset = gb2312 default collate = gb2312_chinese_ci; use new_db; drop table if exists TestingInfo; create table TestingInfo ( TestingID smallint unsigned primary key not null auto_increment, CustomerID smallint unsigned not null , City varchar(20) not null default ' ', CurDate date not null default 0, CheckIn ENUM('T', 'N') not null, /*T->True, N->Not*/ Groups ENUM('A', 'B', 'C') not null, foreign key (CustomerID) references Customer(CustomerID) )engine = InnoDB default charset = gb2312 default collate = gb2312_chinese_ci; -- --Creata user -- use new_db; grant select, insert, update, delete on new_db.* to m1@'%', m2@'%', m3@'%'; 

         具体的语法，可以参考MySQL的文档。

 

<script src="http://s.vdoing.com/u/107/54977.js" type="text/javascript"></script>