請問大家 我在cmd模式下 要Drop這個table (mysql)
結果輸入後 畫面就不動了？ 請問是什麼原因呢？謝謝
註：我用root 登入
| django_content_type |
| django_migrations |
| django_session |
| django_site |
| django_summernote_attachment |
| homeapp_agentorlandlordmodel |
| homeapp_buyerdemandmodel |
| homeapp_daynumber |
| homeapp_messagemodel |
| homeapp_rentcommentmodel |
| homeapp_renthousemodel |
| homeapp_sellcommentmodel |
| homeapp_sellhousemodel |
| homeapp_tenantdemandmodel |
| homeapp_traderecord |
| homeapp_userip |
| homeapp_visitnumber |
| registration_registrationprofile |
| registration_supervisedregistrationprofile |
+--------------------------------------------+
26 rows in set (0.00 sec)
mysql> DROP TABLE homeapp_renthousemodel;
已邀請的邦友 {{ invite_list.length }}/5
SHOW PROCESSLIST;
看有哪些正在跑的,跟你想drop 的 table 有關的.
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
或是
SELECT * FROM performance_schema.processlist\G
然後用 kill 把那個(那些) process 殺掉,這個不建議 這樣做啦,你要知道 這樣做是有風險的. 若可以等待,就等他(們) 跑完.
你有先指定使用庫嘛??
如果有的話，理論上因該會正常執行。
不行的話，可以試試以下指令
DROP TABLE if exists homeapp_renthousemodel
不過要記得，請勿在正式環境下處理。
要不然會打包走人的。
從刪庫到跑路
我畫面如下
mysql> show tables;
+--------------------------------------------+
| Tables_in_houseweb |
+--------------------------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
| django_site |
| django_summernote_attachment |
| homeapp_agentorlandlordmodel |
| homeapp_buyerdemandmodel |
| homeapp_daynumber |
| homeapp_messagemodel |
| homeapp_rentcommentmodel |
| homeapp_renthousemodel |
| homeapp_sellcommentmodel |
| homeapp_sellhousemodel |
| homeapp_tenantdemandmodel |
| homeapp_traderecord |
| homeapp_userip |
| homeapp_visitnumber |
| registration_registrationprofile |
| registration_supervisedregistrationprofile |
+--------------------------------------------+
26 rows in set (0.00 sec)
mysql> DROP TABLE homeapp_renthousemodel;
^C -- query aborted
ERROR 1317 (70100): Query execution was interrupted
mysql> DROP TABLE if exists homeapp_renthousemodel;
^C -- query aborted
ERROR 1317 (70100): Query execution was interrupted
mysql> use houseweb
Database changed
mysql> DROP TABLE if exists homeapp_renthousemodel;
畫面一樣 「完全」沒在動？ 真的不知為什麼？
還請解惑 感恩
iThome鐵人賽
看影片追技術