Vladimir Putin “We discussed this important issue yesterday over a beer...”
Barack OBAMA “You know, my faith is one that admits some doubt...”
MySQL can manage the contention for table contents by using Locking :
Internal Locking can be performed in the MySQL server itself for managing the contention for table content by multiple threads. This locking is known as internal because this locking is performed entirely by the server and it does not involve any other programs.
External locking [...]
A Trigger is a named database object which defines some action that the database should take when some databases related event occurs. Triggers are executed when you issues a data manipulation command like INSERT, DELETE, UPDATE on a table for which the trigger has been created. They are automatically executed and also transparent to the [...]
Cursors are used when the SQL Select statement is expected to return more than one row. Cursors are supported inside procedures and functions. Cursors must be declared and its definition contains the query. The cursor must be defined in the DECLARE section of the program. A cursor must be opened before processing and close after [...]
Flow Control Constructs include the IF, CASE, LOOP, WHILE, ITERATE, REPEAT and LEAVE constructs. They are fully implemented.
These constructs can contain single statement or a block of statements using with BEGIN…..END statement. And these constructs can be nested also.
IF Statement
The general syntax of IF Statement is :
IF search_condition THEN statement_list [ELSEIF search_condition THEN statement_list] [...]
A subquery can be defined as a query within a query. In other words, any query results that we reuse in another query. Subquery is known as nestee queries or subselects also. Subqueries don’t include any new functionality but the queries are more readable with using subqueries rather than of joins.
We will describe you the [...]