On the basis of Operation MySQL queries provide the following five different types of queries:- DDL (Data definition language) DML (Data manipulation language) DQL (Data query language) DCL (Data control language) TCL (Transaction control language)
Author: Veena Rani
MySQL Table
A MySQL table in the database is used to organize data in the form of rows and columns. And it is used for storing and displaying data. To create a table we use CREATE TABLE
MySQL View
MySQL View act as a virtual table. It is also a stored query. When it invokes then it produces a result. Just like a real table view containing rows and columns. All column names and
MySQL Triggers
MySQL Triggers is an event-based stored program. Also, we can say Trigger is a database object associated with a table and It will execute automatically when the specific event will fire. A specific event can
MySQL Procedure
MySQL Procedure is often called stored procedure. It is a pre-compiled SQL statement, which is stored in the database. So we can say, It is a subprogram or subroutine. So, stored procedure code can be
MySQL Store Function
MySQL Store Function is a part of MySQL stored program. It is a set of SQL statements that perform some specific task and return a single value. Syntax:- DELIMITER $$ CREATE FUNCTION fun_name(para1,para2,…) RETURN datatype
MySQL Function
Mysql Provides a lot of inbuilt MySQL functions. But MySQL also provides CREATE FUNCTION syntax for creating loadable programs of MySQL Function. Syntax:- CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_nam RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME
MySQL Encryption or Compression Functions
In MySQL Encryption or Compression Function, we will discuss the AES_DECRYPT Function, AES_ENCRYPT Function, CRC32 Function, ENCRYPT Function, FROM_BASE64 Function, MD5 Function, OLD_PASSWORD Function, PASSWORD Function. AES_DECRYPT Function:- AES_DECRYPT Function is used for decrypting an
MySQL Advanced Function Part-5
In MySQL Advanced Function Part-5 we will discuss about the LAST_INSERT_ID, LEAST, LOAD_FILE, MASTER_POS_WAIT, NULLIF, SESSION_USER, SYSTEM_USER, USER, VERSION LEAST Function:- The LEAST Function is used for returning the least value of the given list
MySQL Advanced Function Part-4
In MySQL Advanced Function Part-4 we will discuss about the IFNULL, IN, INET6_ATON, INET6_NTOA, INET_ATON, INET_NTOA, ISNULL, LAST_VALUE, LEAD IFNULL Function:- IFNULL Function is used to check given if the expression is NULL. Syntax:- IFNULL(check