6_5_run_mysql_command_remotely.py 文件源码

python
阅读 21 收藏 0 点赞 0 评论 0

项目:Python-Network-Programming-Cookbook-Second-Edition 作者: PacktPublishing 项目源码 文件源码
def ls_db():
    """ List a dbs with size in MB """
    if not env.db_name:
        db_name = prompt("Which DB to ls?")
    else:
        db_name = env.db_name
    query = """SELECT table_schema                                        "DB Name", 
       Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
        FROM   information_schema.tables         
        WHERE table_schema = \"%s\" 
        GROUP  BY table_schema """ %db_name
    run_sql(db_name, query)
评论列表
文章目录


问题


面经


文章

微信
公众号

扫码关注公众号