Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
mysql [2013/02/04 16:11]
glaroc
mysql [2014/04/01 16:56]
glaroc
Line 7: Line 7:
 [[http://​prezi.com/​vswzpe89tbwp/​introduction-to-database-management-with-mysql/​|Link to Prezi presentation]] [[http://​prezi.com/​vswzpe89tbwp/​introduction-to-database-management-with-mysql/​|Link to Prezi presentation]]
  
-===== Ressources utiles ​=====+===== Useful resources ​=====
   * [[http://​dev.mysql.com/​doc/​refman/​5.5/​en/​|MySQL 5.5. Reference Manual]]   * [[http://​dev.mysql.com/​doc/​refman/​5.5/​en/​|MySQL 5.5. Reference Manual]]
-  ​* [[http://​dev.mysql.com/​doc/​refman/​5.0/​fr/​index.html| Manuel d'​utilisation de MySQL 5.0 en français]] +  * [[http://​www.artfulsoftware.com/​infotree/​queries.php|Common MySQL Queries]] - Very useful website with hundreds of example ​MySQL commands.  
-  ​* [[http://​www.artfulsoftware.com/​infotree/​queries.php|Common MySQL Queries]] - Site web très utile avec des centaines d'​exemples de commandes ​MySQL.  +  * [[http://​www.springerlink.com/​content/​978-1-85233-716-2/​|Database Design Manual: using MySQL for Windows]] - This book can be downloaded for free from most universities
-  * [[http://​www.springerlink.com/​content/​978-1-85233-716-2/​|Database Design Manual: using MySQL for Windows]] - Ce livre peut-être téléchargé gratuitement en PDF à partir de la majorité des universités+
  
 ====== Installing MySQL ====== ====== Installing MySQL ======
Line 193: Line 192:
  
 ** MATH AND GROUP BY (Aggregate) Functions** ** MATH AND GROUP BY (Aggregate) Functions**
-|AVG() |Return the average value of the argument| +|avg() |Return the average value of the argument| 
-|COUNT(DISTINCT) |Return the count of a number of different values| +|count(DISTINCT) |Return the count of a number of different values| 
-|COUNT() |Return a count of the number of rows returned| +|count() |Return a count of the number of rows returned| 
-|GROUP_CONCAT() |Return a concatenated string| +|group_concat() |Return a concatenated string| 
-|MAX() |Return the maximum value| +|max() |Return the maximum value| 
-|MIN() |Return the minimum value| +|min() |Return the minimum value| 
-|STD() |Return the population standard deviation| +|stddev() |Return the population standard deviation| 
-|STDDEV_POP() |Return the population standard deviation| +|stddev_pop() |Return the population standard deviation| 
-|STDDEV_SAMP() |Return the sample standard deviation| +|stddev_samp() |Return the sample standard deviation| 
-|STDDEV() |Return the population standard deviation| +|sum() |Return the sum| 
-|SUM() |Return the sum| +|var_pop() |Return the population standard variance| 
-|VAR_POP() |Return the population standard variance| +|var_samp() |Return the sample variance| 
-|VAR_SAMP() |Return the sample variance| +|variance() |Return the population standard variance| 
-|VARIANCE() |Return the population standard variance| +[[http://www.postgresql.org/docs/9.3/static/functions-aggregate.html|Full list]]
-[[http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html|Full list]]+
 \\ \\
 \\ \\