/MySQL-Database

Hi, welcome to the MySQL Database repository, I created this repository for friends who want to deepen SQL syntax / queries in depth, I will update the material in it periodically, Friends can also contribute directly to this repository.

MySQL Database v1.0

Hi, welcome to the MySQL Database repository, I created this repository for friends who want to deepen SQL syntax / queries in depth, I will update the material in it periodically, And You can also contribute directly to this repository with PR (Pull Request).

Discussion Material

Query SQL

  • CREATE DATABASE, Creating a database syntax/query
  • SHOW DATABASES, Show all database in your DBMS MySQL
  • USE, Using access database after create
  • CREATE TABLE, Creating Table into database after Database is created and accessed database is selected
  • SHOW TABLES, Show some table if table is exist in database
  • SHOW DATABASES, Show database if database is exist in MySQL Server / DBMS (Database Management System)
  • DROP TABLE, Delete choosen table in database
  • DROP DATABASE, Drop choosen database
  • SELECT, Extracts data from table in database
  • UPDATE, Update data from table in database
  • DELETE, Delete data from table in database
  • INSERT INTO , Insert data into table is selected in database
  • ALTER TABLE, Modifies a database