Comment regrouper les 3requêtes SQL?

Bonjour à tous,

Est ce que c'est possible de faire regrouper les 3 SQL différentes en une seule SQL? Si oui, pourriez-vous m'inquiquer un exemple avec les 3sql ci-dessus:

Code:

---

1 2 3

SELECT COUNT(Count_MsgBR) AS total FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' SELECT COUNT(Count_MsgME) AS total FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' SELECT COUNT(Count_MsgMS) AS total FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0'

---

Comme ca je pourrais exécuter une requete et de racourcir la programmation.

Merci bcq de votre aide.

Bon ap midi.

Fred :wink:

Fais comme ceci:

Code:

---

1 2 3 4 5

(SELECT COUNT(Count_MsgBR) AS total FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' ) Union all (SELECT COUNT(Count_MsgME) AS total FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' ) Union all (SELECT COUNT(Count_MsgMS) AS total FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0')

---

J'ai essayé, ca ne marche pas, il y a une erreur:

ERREUR 1064: Something is wrong in your syntax près de '(SELECT COUNT(Count_MsgBR) AS total FROM `message` WHERE O_TypeM' à la ligne 1

Merci de m'aider.

Fred :wink:

Essaye sans les parenthèses

Code:

---

1 2 3 4 5

SELECT   (SELECT COUNT(Count_MsgBR) AS total FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' ) AS Count_1, (SELECT COUNT(Count_MsgME) AS total FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' ) AS Count_2, (SELECT COUNT(Count_MsgMS) AS total FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0') AS Count_3

---

J'ai encore réssayé, mais finalement celà ne marche pas encore :cry:
Voici le message d'erreur:
ERREUR 1064: Something is wrong in your syntax près de 'SELECT COUNT(Count_MsgBR) AS total FROM `message` WHERE O_TypeMs' à la ligne 3

Merci de votre aide.

Fred

Salut,

j'ai essayé avec ca et ça marche

Code:

---

SELECT COUNT(*) AS total FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0'

---

mais pas avec ca 8O

Code:

---

1 2 3 4 5

SELECT   (SELECT COUNT(*) AS total FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' ) AS Count_1, (SELECT COUNT(*) AS total FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' ) AS Count_2, (SELECT COUNT(*) AS total FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0') AS Count_3

---

même pas avec ça :?

Code:

---

1 2 3 4 5

SELECT   (SELECT COUNT(*) AS totalbr FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' ) AS Count_1, (SELECT COUNT(*) AS totalme FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' ) AS Count_2, (SELECT COUNT(*) AS totalms FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0') AS Count_3

---

Merci de votre aide

Code:

---

1 2 3 4 5

SELECT COUNT(*) AS total FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' union all SELECT COUNT(*) FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' union all SELECT COUNT(*) FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0'

---

ou

Code:

---

1 2 3 4

SELECT * from (SELECT COUNT(*) AS totalbr FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' ) , (SELECT COUNT(*) AS totalme FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' ) , (SELECT COUNT(*) AS totalms FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0')

---

Salut, celà ne marche pas encore, voici le message d'erreur pour:
ERREUR 1064: Something is wrong in your syntax près de 'SELECT COUNT(*) AS totalbr FROM `message` WHERE O_TypeMsg = 'BR'' à la ligne 2

Code:

---

1 2 3 4

SELECT * from (SELECT COUNT(*) AS totalbr FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' ) , (SELECT COUNT(*) AS totalme FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' ) , (SELECT COUNT(*) AS totalms FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0')

---

Et l'autre message d'erreur pour:
ERREUR 1064: Something is wrong in your syntax près de 'union all
SELECT COUNT(*) AS totalME FROM `message` WHERE O_Typ' à la ligne 2

Code:

---

1 2 3 4 5

SELECT COUNT(*) AS totalBR FROM `message` WHERE O_TypeMsg = 'BR' AND O_Read = '0' union all SELECT COUNT(*) AS totalME FROM `message` WHERE O_TypeMsg = 'ME' AND O_Read = '0' union all SELECT COUNT(*) AS totalMS FROM `message` WHERE O_TypeMsg = 'MS' AND O_Read = '0'

---

Merci de votre aide :wink:

Quel SGBDR, quelle version.

Attention la deuxième solution n'est pas exactement ce que j'ai écrit (mais devrait passer quand même)

Nom de la base de données: MySQL
Version: 3.23.49

Vlà, merci de votre aide

Je ne dispose pas de mySQL Version: 3.23.49. Vérifie dans la doc si cette version accepte les unions.

UNION est implémentée en MySQL 4.0.0. UNION est utilisé pour combiner le résultat de plusieurs requêtes SELECT en un seul résultat. :?

Il n'existe pas un autre moyen possible?

Merci de m'aider :wink:

Avec ORACLE, il y a une fonction DECODE, dont l'exemple DECODE(O_TypeMsg, 'BR', 1, 0)
vaut 1 si O_TypeMsg = 'BR' et 0 sinon. Si tu as quelque chose d'équivalent sous mySql :

Code:

---

1 2 3 4

SELECT SUM(DECODE(O_TypeMsg, 'BR', 1, 0)) AS totalbr, SUM(DECODE(O_TypeMsg, 'ME', 1, 0)) AS totalme, SUM(DECODE(O_TypeMsg, 'MS', 1, 0)) AS totalms FROM `message` WHERE O_Read = '0'

---

Citation:

---

Envoyé par pgibone

Avec ORACLE, il y a une fonction DECODE, dont l'exemple DECODE(O_TypeMsg, 'BR', 1, 0)
vaut 1 si O_TypeMsg = 'BR' et 0 sinon. Si tu as quelque chose d'équivalent sous mySql :

Code:

---

1 2 3 4

SELECT SUM(DECODE(O_TypeMsg, 'BR', 1, 0)) AS totalbr, SUM(DECODE(O_TypeMsg, 'ME', 1, 0)) AS totalme, SUM(DECODE(O_TypeMsg, 'MS', 1, 0)) AS totalms FROM `message` WHERE O_Read = '0'

---

---

Celà ne marche pas également, voici message erreur: ERREUR 1064: Something is wrong in your syntax près de ' 1, 0)) AS totalbr,
SUM(DECODE(O_TypeMsg, 'ME', 1, 0)) A' à la ligne 1

Merci de m'aider

En dessous de la version 4, MySQL ne supporte ni les requêtes ensemblistes, ni les sous requêtes.

Il n'y a donc pas de solution pour faire cela en SQL avec MySQL.

A +

Merci bcq de votre aide, j'avais surement deviné mais je vous remercie en tout cas pour l'aide qui m'est encore besoin pour les autres logiciels de base de donénes comme SQL Server ou Oracle ou Interbase ou etc...

Bon week end. :wink: