C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
Creating new databasesIn this section of the tutorial, we will create the new database PythonDB. Getting the list of existing databasesWe can get the list of all the databases by using the following MySQL query. > show databases; Exampleimport 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() Output: ('EmployeeDB',) ('Test',) ('TestDB',) ('information_schema',) ('TheDeveloperBlog',) ('TheDeveloperBlog1',) ('mydb',) ('mysql',) ('performance_schema',) ('testDB',) Creating the new databaseThe new database can be created by using the following SQL query. > create database <database-name> Exampleimport 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() Output: ('EmployeeDB',) ('PythonDB',) ('Test',) ('TestDB',) ('anshika',) ('information_schema',) ('TheDeveloperBlog',) ('TheDeveloperBlog1',) ('mydb',) ('mydb1',) ('mysql',) ('performance_schema',) ('testDB',)
Next TopicCreating Tables
|