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
The popularity of MySQL has led to a proliferation of easy-to-use database tools on the market. One of the most popular solutions in the world is Devart's dbForge Studio for MySQL. The most significant benefits:
It greatly simplifies the work with databases and saves time.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit