dropå½ä»¤ç¨äºå é¤æ°æ®åºã
dropå½ä»¤æ ¼å¼ï¼drop database <æ°æ®åºå>;
ä¾å¦ï¼å é¤å为 xhkdbçæ°æ®åºï¼
mysql> drop database xhkdb;
[ä¾å1] å é¤ä¸ä¸ªå·²ç»ç¡®å®åå¨çæ°æ®åºï¼
mysql> drop database drop_database;
Query OK, 0 rows affected (0.00 sec)
[ä¾å2] å é¤ä¸ä¸ªä¸ç¡®å®åå¨çæ°æ®åºï¼
mysql> drop database drop_database;
ERROR 1008 (HY000): Can't drop database 'drop_database'; database doesn't exist
// åçé误ï¼ä¸è½å é¤'drop_database'æ°æ®åºï¼è¯¥æ°æ®åºä¸åå¨ã
mysql> drop database if exists drop_database;
Query OK, 0 rows affected, 1 warning (0.00 sec)
//产çä¸ä¸ªè¦å说ææ¤æ°æ®åºä¸åå¨
mysql> create database drop_database; // å建ä¸ä¸ªæ°æ®åº
Query OK, 1 row affected (0.00 sec)
mysql> drop database if exists drop_database; // if exists å¤ææ°æ®åºæ¯å¦åå¨ï¼ä¸åå¨ä¹ä¸äº§çé误
Query OK, 0 rows affected (0.00 sec)
温馨提示:答案为网友推荐,仅供参考