SQL Mode

SQL Mode is a Function that returns the frequent occurring value of a numeric expression. When there are no duplicate values in the records, the mode returns NA.

Understand with Example

To understand the example we use the following query that include a set of string value in a normal  mode. The Query result in 0 (false for the condition), when the 1 is not present between -5 and 5. Otherwise it returns 1 (true for the condition), if it exists between -5 and 5.

mysql> SET sql_mode = '';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT NOT 1 BETWEEN -5 AND 5;
+------------------------+
| NOT 1 BETWEEN -5 AND 5 |
+------------------------+
| 0                      |
+------------------------+
1 row in set (0.00 sec)

mysql> SELECT  1 BETWEEN -5 AND 5;
+--------------------+
| 1 BETWEEN -5 AND 5 |
+--------------------+
| 1                  |
+--------------------+
1 row in set (0.00 sec)

Related Tags for SQL Mode:
sql,  c,  function,  fun,  io,  expression,  value,  return,  record,  unc,  numeric,  records,  values,  express,  mode,  ssi,  e,  li,  in,  no,  mod,  m,  nt,  ca,  es,  func,  me,  cat,  when,  s,  urn,  ess,  at,  is,  ha,  press,  pre,  du,  ar,  cc,  rds,  xp,  va,  s,  s,  ri,  ring,  rd,  th,  alu,  hat,  freq,  ica,  ica,  pl,  pr,  ode,  on,  o

More Tutorials from this section

• MySQL Absolute Value
• MySQL Addition
• MySQL Add Column
• MySQL Affected Rows
• MySQL Area
• MySQL Arithmetic
• MySQL ASC
• MySQL Ascending Command
• MySQL Auto_Increment
• MySQL Boolean Value
• Mysql Switch CASE
• Mysql Check
• MySQL Converting Expression
• Mysql Decimal Datatype
• Mysql Describe
• Mysql Else Condition
• Mysql Exists
• Mysql For Loop
• Mysql From
• PHP SQL IF Statement

Ask Questions?    Discuss: SQL Mode  

Post your Comment

Your Name (*) :

Your Email :
Subject (*):
Your Comment (*):