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