mysqlÖÐɾ³ýÊý¾Ý¿âµÄÓï¾ä
ɾ³ý mysql Êý¾Ý¿âʹÓà drop database database_name; Óï¾ä£¬ÆäÖÐ database_name ΪҪɾ³ýµÄÊý¾Ý¿âÃû³Æ¡£×¢ÖØÊÂÏ±¸·ÝÊý¾Ý£¬Ö»ÓÐÓµÓÐ drop ȨÏÞµÄÓû§¿ÉÒÔɾ³ýÊý¾Ý¿â£¬É¾³ýǰɾ³ýÊý¾Ý¿âÖеÄËùÓй¤¾ß¡£
MySQL ɾ³ýÊý¾Ý¿âµÄÓï¾ä
ÔõÑùɾ³ý MySQL Êý¾Ý¿â£¿
Ҫɾ³ý MySQL Êý¾Ý¿â£¬¿ÉÒÔʹÓÃÒÔÏÂÏÂÁ
DROP DATABASE database_name;
µÇ¼ºó¸´ÖÆ
ÆäÖÐ database_name ÊÇҪɾ³ýµÄÊý¾Ý¿âµÄÃû³Æ¡£
×¢ÖØÊÂÏ
ÔÚɾ³ýÊý¾Ý¿â֮ǰ£¬ÇëÈ·±£ÄúÒѱ¸·ÝÁËÆäÖеÄËùÓÐÊý¾Ý£¬ÓÉÓÚɾ³ýºó½«ÎÞ·¨»Ö¸´¡£
ÓµÓÐ DROP ȨÏÞµÄÓû§²Å»ªÉ¾³ýÊý¾Ý¿â¡£
ÈôÊÇÊý¾Ý¿âÖаüÀ¨Èκαí»òÆäËû¹¤¾ß£¬ÔòÔÚɾ³ýÊý¾Ý¿â֮ǰ±ØÐèÏÈɾ³ýÕâЩ¹¤¾ß¡£
Ö´Ðа취£º
·¿ª MySQL ÏÂÁîÐнçÃæ¡£
ʹÓÃÒÔÏÂÏÂÁîÅþÁ¬µ½ MySQL ЧÀÍÆ÷£ºmysql -u username -p password¡£
ÊäÈëÊý¾Ý¿âÃÜÂë¡£
Ö´ÐÐ DROP DATABASE database_name; ÏÂÁî¡£
È·ÈÑþ³Øý²Ù×÷£¬ÊäÈë Y¡£
ʾÀý£º
Ҫɾ³ýÃûΪ my_database µÄÊý¾Ý¿â£¬¿ÉÒÔÖ´ÐÐÒÔÏÂÏÂÁ
DROP DATABASE my_database;
µÇ¼ºó¸´ÖÆ
ÒÔÉϾÍÊÇmysqlÖÐɾ³ýÊý¾Ý¿âµÄÓï¾äµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡