All about databases in mysql.

uzairk (53)in #termux • 6 years ago

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

#mysql #database #programming #tech

6 years ago in #termux by uzairk (53)

Sort:

federico-r (37) 4 years ago

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.

$0.00