Trigger

 In this lesson, we will introduce you to MySQL triggers. By definition, a MySQL trigger is a type of stored program, associated with a table, that will be activated automatically once a specific event related to the table of association occurs.  This...

Read More

SQL Query

Please download the script from the GitHub. Schema Database-Schema ...

Read More

JOINS

The SQL tool that allows us to construct a relationship between objects. A join shows a result set, containing fields derived from two or more tables. We must find a related column from the two tables that contain the same type of...

Read More

Stored Routines

Routine in a context other than a computer, a usual, fixed action, or series of actions, repeated periodically. Stored routine An SQL statement, or a set of SQL statements, that can be stored on the database server Whenever a user needs to...

Read More

MySQL Index

The index of table functions as the index of a book Data is taken from a column of the table and is stored in a certain order in a distinct place called an index. Your datasets will typically contain 100,000+ or even...

Read More

Views

 A virtual table whose contents are obtained from an existing table or tables called base tables. The view itself does not contain any real data; the data is physically stored in the base table. The view simply shows the data contained in...

Read More

SQL Data Type

String Data Type String Data Type Storage/ MAX_SIZE(Byte) Example Remark Character CHAR Fixed/255 CHAR(5) 50% faster Variable character VARCHAR Variable/65,535 VARCHAR(5) a lot more responsive to the data value inserted ENUM (enumeration) ENUM ENUM(‘M’,’F’) MySQL will show an error if you attempt...

Read More