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

Introduction to SQL

Structure Query Language: It is a tool which is used to communicate with the database Types of SQL statements 1. Data Definition Language(DDL) e.g. CREATE, ALTER, DROP, RENAME, TRUNCATE 2. Data Manipulation Language(DML) e.g. SELECT, INSERT, UPDATE, DELETE 3. Data Control Language(DCL)...

Read More

JDBC Statements

Statement PreparedStatement CallableStatement 1.Statement Statement is an interface available in java.sql package. Subclass of Statement interface is provided by Driver vendor. You can create the Statement object using the following methods of Connection interface. public Statement createStatement(); public Statement createStatement(int,int); public Statement...

Read More

Parameters

Servlet Instance Creation By default, the servlet instance will be created when the first client will send the request to the servlet. Only one instance will be created for one servlet and will be used to process all the requests by using...

Read More

Introduction

JDBC is a technology which is used to interact with the database from Java Application JDBC Technology is a part of Java Standard Edition JDBC is a Specification provided by Java vendor and implemented by Java Vendor or DB vendor. JDBC Versions...

Read More