ARTICLE DETAIL

建站实战干货

来自一线的建站与推广经验沉淀,每一条都经过真实交付验证。

使用Python管理MySQL数据库,有录播直播私教课视频教程

2026/8/14 3:52:27 拓冰建站 浏览量
使用Python管理MySQL数据库,有录播直播私教课视频教程

查看所有数据库

from mysql.db_object import Databasedb = Database(host="localhost",port=3306,database="",username="root",password="zhangdapeng520"
)
print(db.get_all_database())

删除数据库

from mysql.db_object import Databasedb = Database(host="localhost",port=3306,database="",username="root",password="zhangdapeng520"
)
print(db.get_all_database())db.delete_database("gx")
print(db.get_all_database())

添加数据库

from mysql.db_object import Databasedb = Database(host="localhost",port=3306,database="",username="root",password="zhangdapeng520"
)
db.delete_database("gx")
print(db.get_all_database())db.add_database("gx")
print(db.get_all_database())

重建数据库

from mysql.db_object import Databasedb = Database(host="localhost",port=3306,database="",username="root",password="zhangdapeng520"
)
db.add_database_force("gx")
print(db.get_all_database())

判断数据库是否存在

from mysql.db_object import Databasedb = Database(host="localhost",port=3306,database="",username="root",password="zhangdapeng520"
)
db.add_database_force("gx")
print("gx" in db.get_all_database())