{"id":1758,"date":"2018-05-15T13:03:50","date_gmt":"2018-05-15T11:03:50","guid":{"rendered":"http:\/\/slamsoft-corp.com\/?p=1758"},"modified":"2018-05-15T13:03:50","modified_gmt":"2018-05-15T11:03:50","slug":"les-fonctions-sql","status":"publish","type":"post","link":"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/","title":{"rendered":"Les fonctions SQL"},"content":{"rendered":"<p>Au m\u00eame titre que beaucoup de <strong>Tubes<\/strong> chez slamsOft Corp, celui-ci a pour vocation d&rsquo;\u00eatre un simple pense-b\u00eate pour les employ\u00e9s de la soci\u00e9t\u00e9.<br \/>\nN&rsquo;y voyez donc aucun Tuto ou apprentissage particulier, il ne s&rsquo;agit que d&rsquo;un Tube o\u00f9 quelques connaissances sur les fonctions SQL sont stock\u00e9es, afin de pouvoir tr\u00e8s facilement s&rsquo;y replonger en cas de besoin&#8230;<\/p>\n<pre><strong>UPPER<\/strong> : Permet de convertir un champ avec des lettres en majuscules.\r\n<em>ex: SELECT UPPER(eggs_visiteur) AS visiteur_maj FROM tube_sql<\/em><\/pre>\n<pre><strong>LOWER<\/strong> : Permet de convertir un champ avec des lettres en minuscules.<\/pre>\n<pre><strong>LENGTH<\/strong> : Permet de r\u00e9cup\u00e9rer le nombre de caract\u00e8res d'un champ.\r\n<em>ex: SELECT LENGTH(eggs_visiteur) AS longueur_nom FROM tube_sql<\/em><\/pre>\n<pre><strong>ROUND<\/strong> : Permet d'arrondir un nombre d\u00e9cimal et de choisir le nombre apr\u00e8s la virgule.\r\n<em>ex: SELECT ROUND(prix, 1) AS prix_arrondi FROM tube_sql<\/em><\/pre>\n<pre><strong>AVG<\/strong> : Permet de calculer la moyenne d'un champ, lorsque celui-ci comporte des nombres.\r\n<em>ex: SELECT AVG(eggs_visiteurs_quotidien) AS moyenne_visiteur FROM tube_sql<\/em><\/pre>\n<pre><strong>SUM<\/strong> : Permet d'additionner toutes les valeurs d'un champ, lorsque celui-ci comporte des nombres.\r\n<em>ex: SELECT SUM(eggs_visiteurs_quotidien) total_visiteur FROM tube_sql WHERE jour='lundi'<\/em><\/pre>\n<pre><strong>MAX<\/strong> : Permet de retourner la valeur maximale.\r\n<em>ex: SELECT MAX(eggs_visiteurs_quotidien) AS prix_max FROM tube_sql<\/em><\/pre>\n<pre><strong>MIN<\/strong> : Permet de retourner la valeur minimale.\r\n<em>ex: SELECT MIN(eggs_visiteurs_quotidien) AS prix_min FROM tube_sql<\/em><\/pre>\n<pre><strong>COUNT<\/strong> : Permet de compter le nombre d'entr\u00e9e.\r\n<em>ex: SELECT COUNT(*) AS nbjours FROM tube_sql<\/em>\r\nLa fonction <strong>COUNT<\/strong> peut-\u00eatre accompagn\u00e9e du mot-cl\u00e9 <strong>DISTINCT<\/strong>.Cela permet de connaitre le nombre d'entr\u00e9es diff\u00e9rentes dans la table, mais pouvant se r\u00e9p\u00e9ter. Comme des personnes ou des villes par exemple.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Au m\u00eame titre que beaucoup de Tubes chez slamsOft Corp, celui-ci a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[13],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Les fonctions SQL - slamsOft Corp.<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les fonctions SQL - slamsOft Corp.\" \/>\n<meta property=\"og:description\" content=\"Au m\u00eame titre que beaucoup de Tubes chez slamsOft Corp, celui-ci a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"slamsOft Corp.\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/EggManu\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/EggManu\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-15T11:03:50+00:00\" \/>\n<meta name=\"author\" content=\"SlamsOft\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@EggMarty\" \/>\n<meta name=\"twitter:site\" content=\"@EggMarty\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"SlamsOft\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/slamsoft-corp.com\/#website\",\"url\":\"https:\/\/slamsoft-corp.com\/\",\"name\":\"slamsOft Corp.\",\"description\":\"Tube craft\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/slamsoft-corp.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/\",\"url\":\"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/\",\"name\":\"Les fonctions SQL - slamsOft Corp.\",\"isPartOf\":{\"@id\":\"https:\/\/slamsoft-corp.com\/#website\"},\"datePublished\":\"2018-05-15T11:03:50+00:00\",\"dateModified\":\"2018-05-15T11:03:50+00:00\",\"author\":{\"@id\":\"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf\"},\"breadcrumb\":{\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/slamsoft-corp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Les fonctions SQL\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf\",\"name\":\"SlamsOft\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/slamsoft-corp.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg\",\"contentUrl\":\"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg\",\"caption\":\"SlamsOft\"},\"sameAs\":[\"http:\/\/slamsoft-corp.com\/\",\"https:\/\/www.facebook.com\/EggManu\/\",\"https:\/\/twitter.com\/EggMarty\"],\"url\":\"https:\/\/slamsoft-corp.com\/index.php\/author\/admin4504\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Les fonctions SQL - slamsOft Corp.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Les fonctions SQL - slamsOft Corp.","og_description":"Au m\u00eame titre que beaucoup de Tubes chez slamsOft Corp, celui-ci a [&hellip;]","og_url":"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/","og_site_name":"slamsOft Corp.","article_publisher":"https:\/\/www.facebook.com\/EggManu\/","article_author":"https:\/\/www.facebook.com\/EggManu\/","article_published_time":"2018-05-15T11:03:50+00:00","author":"SlamsOft","twitter_card":"summary_large_image","twitter_creator":"@EggMarty","twitter_site":"@EggMarty","twitter_misc":{"\u00c9crit par":"SlamsOft","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/slamsoft-corp.com\/#website","url":"https:\/\/slamsoft-corp.com\/","name":"slamsOft Corp.","description":"Tube craft","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/slamsoft-corp.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/","url":"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/","name":"Les fonctions SQL - slamsOft Corp.","isPartOf":{"@id":"https:\/\/slamsoft-corp.com\/#website"},"datePublished":"2018-05-15T11:03:50+00:00","dateModified":"2018-05-15T11:03:50+00:00","author":{"@id":"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf"},"breadcrumb":{"@id":"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/slamsoft-corp.com\/index.php\/2018\/05\/15\/les-fonctions-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/slamsoft-corp.com\/"},{"@type":"ListItem","position":2,"name":"Les fonctions SQL"}]},{"@type":"Person","@id":"https:\/\/slamsoft-corp.com\/#\/schema\/person\/230a6256c44062d2950c818ef8743acf","name":"SlamsOft","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/slamsoft-corp.com\/#\/schema\/person\/image\/","url":"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg","contentUrl":"http:\/\/slamsoft-corp.com\/wp-content\/uploads\/2018\/04\/avatar_user_1_1523361156-96x96.jpg","caption":"SlamsOft"},"sameAs":["http:\/\/slamsoft-corp.com\/","https:\/\/www.facebook.com\/EggManu\/","https:\/\/twitter.com\/EggMarty"],"url":"https:\/\/slamsoft-corp.com\/index.php\/author\/admin4504\/"}]}},"_links":{"self":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts\/1758"}],"collection":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/comments?post=1758"}],"version-history":[{"count":18,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts\/1758\/revisions"}],"predecessor-version":[{"id":1778,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/posts\/1758\/revisions\/1778"}],"wp:attachment":[{"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1758"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1758"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/slamsoft-corp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1758"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}