bases_de_donnees:mysql:case
Différences
Ci-dessous, les différences entre deux révisions de la page.
bases_de_donnees:mysql:case [2015/08/01 01:42] – modification externe 127.0.0.1 | bases_de_donnees:mysql:case [2020/02/13 00:39] (Version actuelle) – supprimée sgariepy | ||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
- | CASE | ||
- | WHEN `User`.`firstname` IS NULL | ||
- | THEN `User`.`username` | ||
- | WHEN `User`.`firstname` IS NOT NULL | ||
- | THEN (CONCAT(`User`.`firstname`, | ||
- | END | ||
- | |||
- | |||
- | CASE `User`.`show_fullname` | ||
- | WHEN 1 THEN | ||
- | IF((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL), `User`.`username`, | ||
- | WHEN 0 THEN | ||
- | `User`.`username` | ||
- | END | ||
- | |||
- | |||
- | CASE `User`.`show_fullname` | ||
- | WHEN 1 THEN | ||
- | `User`.`name` | ||
- | WHEN 0 THEN | ||
- | `User`.`username` | ||
- | END | ||
- | |||
- | CASE `User`.`show_fullname` WHEN 1 THEN `User`.`name` WHEN 0 THEN `User`.`username` END | ||
- | |||
- | |||
- | |||
- | CASE `User`.`show_fullname` | ||
- | WHEN 1 THEN | ||
- | |||
- | |||
- | CASE | ||
- | WHEN `User`.`firstname` IS NULL THEN | ||
- | `User`.`username` | ||
- | WHEN `User`.`firstname` IS NOT NULL THEN | ||
- | CONCAT(`User`.`firstname`, | ||
- | END | ||
- | |||
- | WHEN 0 THEN | ||
- | `User`.`username` | ||
- | END | ||
- | |||
- | CASE `User`.`show_fullname` WHEN 1 THEN CASE WHEN `User`.`firstname` IS NULL THEN `User`.`username` WHEN `User`.`firstname` IS NOT NULL WHEN CONCAT(`User`.`firstname`, | ||
- | |||
- | |||
- | |||
- | CASE `User`.`show_fullname` WHEN 1 THEN IF((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL), `User`.`username`, | ||
- | |||
- | |||
- | |||
- | ((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL)) AND ((`User`.`firstname` = '' | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | ALTER TABLE `socialbeer`.`users` | ||
- | ADD COLUMN `name_mode` enum(' | ||
- | |||
- | |||
- | |||
- | |||
- | ' | ||
- | |||
- | CASE `User`.`show_fullname` | ||
- | WHEN 1 THEN | ||
- | IF(((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL)) OR ((`User`.`firstname` = "" | ||
- | WHEN 0 THEN | ||
- | `User`.`username` | ||
- | END' | ||
- | |||
- | |||
- | |||
- | IF(((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL)) OR ((`User`.`firstname` = "" | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | ' | ||
- | |||
- | |||
- | |||
- | CASE `User`.`name_display` | ||
- | WHEN " | ||
- | `User`.`username` | ||
- | WHEN " | ||
- | IF(((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL)) OR ((`User`.`firstname` = "" | ||
- | WHEN " | ||
- | CONCAT(`User`.`firstname`, | ||
- | END | ||
- | |||
- | |||
- | CASE `User`.`name_display` WHEN " | ||
- | |||
- | |||
- | <a href="#" | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||
- | |||