// ¾Æ·¡ 4°³ÀÇ º¯¼ö´Â Á÷Á¢ ÀÔ·ÂÇÕ´Ï´Ù.
$host_name = "localhost"; // È£½ºÆ® À̸§, º¸Åë localhost
$user_id =""; // À¯Àú ¾ÆÀ̵ð, DB Á¢¼Ó ¾ÆÀ̵ð
$password = ""; // ¾ÏÈ£, DB Á¢¼Ó ¾ÏÈ£
$db_name = ""; // DB À̸§
echo "±×´© º¸µåÀÇ DB ¼³Á¤À» »èÁ¦ ÇÕ´Ï´Ù.
";
$connect = mysql_connect( $host_name, $user_id, $password ); // MySQL Á¢¼Ó
$mysql = mysql_select_db( $db_name, $connect ); // DB ¼±ÅÃ
$result = mysql_query( "SHOW TABLE status FROM $db_name LIKE 'gb%'", $connect );
// SHOW TABLE : Å×ÀÌºí º¸±â Äõ¸®¹®
// status : Çö»óÅÂ
// FROM $db_name : DB¿¡¼
// LIKE 'gb%' : °Ë»ö Á¶°Ç, gb·Î ½ÃÀÛÇÏ´Â µ¥ÀÌÅÍ °Ë»ö
while( $data = mysql_fetch_array( $result ) ) { // Àоî¿Â Å×À̺íÀ̸§À» ¸ðµÎ º¯È¯ÇÒ¶§ ±îÁö ·çÇÁ
mysql_query( "DROP TABLE $data[Name]" );
}
// mysql_fetch_array() : ¿¬°ü¹è¿ ÇüÅ·Πµ¥ÀÌÅÍ º¯È¯
// DROP TABLE : Å×ÀÌºí »èÁ¦ Äõ¸®¹®
mysql_close( $connect ); // DB ´Ý±â
echo "±×´©º¸µåÀÇ DBÀÚ·á°¡ ¸ðµÎ »èÁ¦ µÇ¾ú½À´Ï´Ù.
DBÀÚ·á »èÁ¦ ÈÄ ±×´©º¸µå¸¦ ´Ù½Ã ¼³Ä¡ Çϱâ À§Çؼ´Â °èÁ¤¿¡ ¼³Ä¡ µÇ¾ú´ø
±×´©º¸µå »èÁ¦ ÈÄ À缳ġ ÇϽñ⠹ٶø´Ï´Ù.
µ¤¾î ¾²±â·Î ±×´©º¸µå ¼³Ä¡ÇÒ °æ¿ì DB¿¡·¯°¡ ³³´Ï´Ù.
ÀÌ´Â ±×´©º¸µåÀÇ DB¼³Á¤ µ¥ÀÌÅͰ¡ ³²¾Æ ÀÖÀ¸³ª ½ÇÁ¦ DBÀÚ·á°¡ ¾ø±â¿¡
³ªÅ¸³ª´Â Çö»óÀÔ´Ï´Ù.
";
?>