Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
mysql [2013/02/04 21:11] glaroc |
mysql [2014/04/01 20:56] (current) 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]] | + | |
| \\ | \\ | ||
| \\ | \\ | ||
