"; $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ÀÚ·á°¡ ¾ø±â¿¡
³ªÅ¸³ª´Â Çö»óÀÔ´Ï´Ù.
"; ?>