一個簡單的MySQL資料庫指令碼

                                                       一個簡單的MySQL資料庫指令碼

         這段時間因為項目需要學習了MySQL資料庫，貼一個關於建立資料庫，資料表，使用者的MySQL指令碼，和大家分享。

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

         具體的文法，可以參考MySQL的文檔。