: CASE : Procedure Function MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Procedure Function
»
CASE
»
159.1 .
CASE WHEN with ELSE
Hits: 1142
159.2 .
Using CASE WHEN condition statement in a procedure
Hits: 1109
159.3 .
Using CASE WHEN statement in a procedure
Hits: 1054
159.4 .
CASE Statement with Condition Checks
Hits: 1008
159.5 .
For checking a uniform condition you may use the CASE construct
Hits: 1038
MySQL TUTORIALS
Procedure Function
»
CASE
Introduction
TEXT
Delimiter
Default
Function
Begin End
Function Returning
Buildin Functions
Procedure
Declare
Call
DEFINER
Parameters
Output
Operator
Select Into
Variable Assignment
Update Table
Variable Declaration
Insert
Variable Scope
Delete
Set
Create Table
IF statement
Drop Table
While
Dynamic Statement
CASE
DETERMINISTIC
ITERATE
Condition HANDLER
LEAVE
Predefined Exceptions
LOOP
Procedure Data Dictionary
Repeat until
Function Data Dictionary
CHAR
Transaction
BIGINT
Lock
DATE
Perl
DATETIME
PHP
DOUBLE
Java
FLOAT
CSharp
INT
Python
VARCHAR
VB.net
NUMERIC
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View