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. ExampleOutput: ('EmployeeDB',) ('Test',) ('TestDB',) ('information_schema',) ('javatpoint',) ('javatpoint1',) ('mydb',) ('mysql',) ('performance_schema',) ('testDB',) Creating the new databaseThe new database can be created by using the following SQL query. ExampleOutput: ('EmployeeDB',) ('PythonDB',) ('Test',) ('TestDB',) ('anshika',) ('information_schema',) ('javatpoint',) ('javatpoint1',) ('mydb',) ('mydb1',) ('mysql',) ('performance_schema',) ('testDB',)
Next TopicCreating Tables
|