1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

用什么方法可以删除数据库中的所有表?

Discussion in '后端开发' started by 扬子, Nov 15, 2005.

  1. 扬子

    扬子 Member

    Joined:
    Sep 5, 2005
    Messages:
    949
    Likes Received:
    2
    drop table 表名;//这个只能一个个删除,我想删除所有的表,应该如何写

    PS:(前提,我没有权限删除这个数据库,只能新建、修改表)
     
  2. laogui

    laogui Administrator
    Staff Member

    Joined:
    Aug 30, 2005
    Messages:
    15,216
    Likes Received:
    35
    用phpmyadmin批量drop
     
  3. 扬子

    扬子 Member

    Joined:
    Sep 5, 2005
    Messages:
    949
    Likes Received:
    2
    感谢,这个问题算解决了。
     
  4. A君

    A君 Well-Known Member

    Joined:
    Aug 31, 2005
    Messages:
    19,987
    Likes Received:
    98
    老鬼是牛人
     
  5. 扬子

    扬子 Member

    Joined:
    Sep 5, 2005
    Messages:
    949
    Likes Received:
    2
    牛的一踏糊涂