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 object

cur = 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

例子

import mysql.connector

#Create the connection object

myconn = mysql.connector.connect(host = "localhost", user = "root", passwd = "google")

#creating the cursor object

cur = myconn.cursor()

try:

#creating a new database

cur.execute("create database PythonDB2")

#getting the list of all the databases which will now include the new database PythonDB

dbs = 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', )