Now we will learn how to create database. Database names are case sensitive. so we must have to refer our database in lower case "databasename" not "DataBaseName" in linux. This case sensitive concept is also true for tables.
Create DatabaseWhen the users create a database, it is stored as a set of files on the hard disk of the computer. To create a user-defined database, you can use the CREATE DATABASE statement.
CREATE DATABASE testdbThis command will create one new database with name of "testdb". If database name already exists, you will get following error message
Can't create database 'testdb'; database exists
Use DatabaseBefore we use the database, we must select it for use each time.
USE auxiboxThis command will select the existing database to use now.
DROP DATABASE testdbUsing this command we will remove the database from our server.