All about databases in mysql.

in #termux5 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.

Coin Marketplace

STEEM 0.19
TRX 0.14
JST 0.029
BTC 66425.17
ETH 3185.93
USDT 1.00
SBD 2.63