Creating new databases

In this section of the tutorial, we will create the new database PythonDB.

Getting the list of existing databases

We can get the list of all the databases by using the following MySQL query.

<br />
>  show databases;<br />

Example

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

Output:

('EmployeeDB',)
('Test',)
('TestDB',)
('information_schema',)
('javatpoint',)
('javatpoint1',)
('mydb',)
('mysql',)
('performance_schema',)
('testDB',)

Creating the new database

The new database can be created by using the following SQL query.

<br />
>  create database <database-name><br />

Example

<br />
import mysql.connector</p>
<p>#Create the connection object<br />myconn = mysql.connector.connect(host = “localhost”, user = “root”,passwd = “google”)</p>
<p>#creating the cursor object<br />cur = myconn.cursor()</p>
<p>try:<br />    #creating a new database<br />    cur.execute(“create database PythonDB2”)</p>
<p>    #getting the list of all the databases which will now include the new database PythonDB<br />    dbs = cur.execute(“show databases”)</p>
<p>except:<br />    myconn.rollback()</p>
<p>for x in cur:<br />        print(x)</p>
<p>myconn.close()<br />

Output:

('EmployeeDB',)
('PythonDB',)
('Test',)
('TestDB',)
('anshika',)
('information_schema',)
('javatpoint',)
('javatpoint1',)
('mydb',)
('mydb1',)
('mysql',)
('performance_schema',)
('testDB',)

原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/263642.html

Creating new databases

Creating new databases

Getting the list of existing databases

Example

Creating the new database

Example

相关推荐

发表回复