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
Over the last 10+ years I am working as web developer. I have been develop wide range of website and web Application using HTML, DHTML, XHTML, HTML5, CSS, CSS3, Javascript, Jquery, Ajax, Core PHP, WordPress and database MySQL including sites for startup companies and small businesses.
I have been work on several API like Facebook, Twitter, Paypal, Authorize dot net, Strip, google, Infusionsoft, Github etc.
I have very good concept in SEO and online Marketing,
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
