<?php

   $connect = mysql_connect ('localhost', 'root', '11111111') or die (mysql_error());
   mysql_create_db('testDB') or die(mysql_error()); //testDB라는 데이터베이스를 생성
   mysql_select_db('testDB',$connect);

   $sql = "CREATE TABLE test_member ( ";
   $sql = $sql . " seq int not null auto_increment, ";
   $sql = $sql . " memuid varchar(20) NOT NULL, ";
   $sql = $sql . " name varchar(20) NOT NULL, ";
   $sql = $sql . " addr varchar(255) NOT NULL, ";
   $sql = $sql . " PRIMARY KEY(seq), ";
   $sql = $sql . " UNIQUE memuid (memuid) );";

   $result = mysql_query($sql) or die(mysql_error());
   mysql_drop_db('testDB'); //데이터베이스 testDB를 드롭시킴

?>

<?php
   $connect = mysql_connect ('localhost', 'root', '11111111') or die (mysql_error());
   mysql_query("CREATE DATABASE testDB") or die(mysql_error());
   mysql_select_db('testDB',$connect);

   $sql = "CREATE TABLE test_member ( ";
   $sql = $sql . " seq int not null auto_increment, ";
   $sql = $sql . " memuid varchar(20) NOT NULL, ";
   $sql = $sql . " name varchar(20) NOT NULL, ";
   $sql = $sql . " addr varchar(255) NOT NULL, ";
   $sql = $sql . " PRIMARY KEY(seq), ";
   $sql = $sql . " UNIQUE memuid (memuid) );";

   $result = mysql_query($sql) or die(mysql_error());
   mysql_query("DROP DATABASE testDB") or die(mysql_error());

 ?>