« MySQL/Fonctions » : différence entre les versions

Contenu supprimé Contenu ajouté
Aucun résumé des modifications
Ligne 219 :
</source>
 
===MAX(fieldchamp)===
MAX() can be used to get the maximum value for an expression in the rows matching to a query. If no row matches the query, returns NULL.
<source lang=sql>
Ligne 226 :
</source>
 
===MIN(fieldchamp)===
MIN() can be used to get the minimum value for an expression in the rows matching to a query. If no row matches the query, returns NULL.
<source lang=sql>
Ligne 232 :
</source>
 
===AVG(fieldchamp)===
AVG() can be used to get the average value for an expression in the rows matching to a query. If no row matches the query, returns NULL.
<source lang=sql>
Ligne 238 :
</source>
 
===SUM(fieldchamp)===
SUM() can be used to get the sum of the values for an expression in the rows matching to a query. If no row matches the query, returns NULL.
 
Ligne 246 :
</source>
 
===GROUP_CONCAT(fieldchamp)===
GROUP_CONCAT() can be used to concatenate values from all records for a group into a single string separated by comma or any additional token you like.