All about databases in mysql.

in #termux6 years ago

Databases in mysql

Screenshot_2019-09-19-17-44-33-266_com.termux.png

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.
Queryuse
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

Sort:  

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:

  • Awesome built-in debugger for stored procedures and triggers
  • Query Builder
  • Query Profiler functionality helps to track, recreate and fix problems in MySQL
  • Compare data and schema
  • SQL code completion and formatting.
    It greatly simplifies the work with databases and saves time.