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
|
JavaTpoint offers too many high quality services. Mail us on h[email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected].
Duration: 1 week to 2 week