Python如何创建新数据库（） _Python最新开发教程

本文概述

获取现有数据库列表
创建新数据库

【Python如何创建新数据库（）】在本教程的这一部分中, 我们将创建新的数据库PythonDB。
获取现有数据库列表我们可以使用以下MySQL查询来获取所有数据库的列表。

> show databases;

例子

import mysql.connector#Create the connection object myconn = mysql.connector.connect(host = "localhost", user = "root", passwd = "google")#creating the cursor objectcur = myconn.cursor()try:dbs = cur.execute("show databases")except:myconn.rollback()for x in cur:print(x)myconn.close()

输出

('EmployeeDB', )('Test', )('TestDB', )('information_schema', )('srcmini', )('srcmini1', )('mydb', )('mysql', )('performance_schema', )('testDB', )

创建新数据库可以使用以下SQL查询创建新数据库。

> create database < database-name>

例子

import mysql.connector#Create the connection object myconn = mysql.connector.connect(host = "localhost", user = "root", passwd = "google")#creating the cursor objectcur = myconn.cursor()try:#creating a new databasecur.execute("create database PythonDB2")#getting the list of all the databases which will now include the new database PythonDBdbs = cur.execute("show databases")except:myconn.rollback()for x in cur:print(x)myconn.close()

输出

('EmployeeDB', )('PythonDB', )('Test', )('TestDB', )('anshika', )('information_schema', )('srcmini', )('srcmini1', )('mydb', )('mydb1', )('mysql', )('performance_schema', )('testDB', )