Databases in mysql
As there are folders in our computers or mobiles they are in mysql server. Here they are called as databases
- To create a database (folder) create database name; is used
Here you can pick any name for your database in place of name, it can be alphanumeric, no spaces allowed.
- To delete a database drop database name; is used.
- To see the list of all the databases show databases; is used
- To open database or use it use name; is used.
| Query | use |
|---|---|
| create database name; | to create a database (folder) |
| drop database name; | to delete a database |
| show databases; | to list all the databases |
| use name; | to open or use database |
Check out video here