21.6 C
New York

MySQL SQL

Published:

The journey of Mysql starts with SQL. Sql is a widely used programming language for RDBMS (relational database management system)

SQL is an acronym which stands for

S = Structured
Q = Query
L = Language

MySql is a combination of “My” and “SQL”.

The “My” is the name MySql co-founder Michael “Monty” Widenius 1st Daughter according to Wikipedia

Semicolon after Mysql Query commands

Just like every other programming languages, the semicolon always mark the end of any command line, therefore it is not applicable to only Mysql.

the most commonly used mysql query commands are:

  • SELECT – extracts data from a database
  • UPDATE – updates data in a database
  • DELETE – deletes data from a database
  • INSERT INTO – inserts new data into a database
  • CREATE DATABASE – creates a new database
  • ALTER DATABASE – modifies a database
  • CREATE TABLE – creates a new table
  • ALTER TABLE – modifies a table
  • DROP TABLE – deletes a table
  • CREATE INDEX – creates an index (search key)
  • DROP INDEX – deletes an index

Case sensitivity of Mysql Query commands

finally, like been usually heard that mysql commands are not case sensitive.

I will say that though that’s the case but it is better MOST preferable to differentiate it commands and operators in query using Uppercase for them

Godwin
Godwinhttps://shopinson.com
Owner and founder of shopinson.com. He is a passionate programmer with enthusiasm in daily discovering of solving logic with new block of codes. He loves creating contents and blogging his new discoveries on programming language and related peripherals.

Related articles

spot_img

Recent articles

spot_img