1<!DOCTYPE html> <!--[if IE 6]><html id="ie6" lang="fr-FR"> <![endif]--> <!--[if IE 7]><html id="ie7" lang="fr-FR"> <![endif]--> <!--[if IE 8]><html id="ie8" lang="fr-FR"> <![endif]--> <!--[if !(IE 6) | !(IE 7) | !(IE 8) ]><!--><html lang="fr-FR"> <!--<![endif]--><head><link rel="stylesheet" href="https://sql.sh/wp-content/cache/min/1/a999f3fdd05c4879a59b66db8b9136be.css" data-minify="1"/>
1<script type="text/javascript" src="https://platform.twitter.com/widgets.js"></script>
1<script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
1<script src="https://sql.sh/wp-content/cache/min/1/7c32eb7c4208ce5033270cbae40458ea.js" data-minify="1"></script>
1 <meta charset="UTF-8" /><meta name="viewport" content="width=device-width" /><title>Cours SQL</title><link rel="profile" href="https://gmpg.org/xfn/11" /><link rel="pingback" href="https://sql.sh/xmlrpc.php" /><link type="image/png" href="https://sql.sh/favicon.ico" rel="icon" /> <!--[if lt IE 9]>
1<script src="https://sql.sh/wp-content/themes/sql_sh/js/html5shiv.js" type="text/javascript"></script>
1 <![endif]--><meta name='robots' content='index, follow, max-image-preview:large, max-snippet:-1, max-video-preview:-1' /><link rel="canonical" href="https://sql.sh/cours" /><meta property="og:locale" content="fr_FR" /><meta property="og:type" content="article" /><meta property="og:title" content="Cours SQL" /><meta property="og:description" content="Cette page recense des cours de SQL pour apprendre à communiquer avec une base de données (lecture, écriture, suppression de données …). Les cours sont simplifiés pour se remémorer la syntaxe des commandes importantes et des tutoriels sont disponibles pour permettre d’apprendre […]" /><meta property="og:url" content="https://sql.sh/cours" /><meta property="og:site_name" content="SQL" /><meta property="article:modified_time" content="2014-10-24T22:26:24+00:00" /><meta name="twitter:card" content="summary_large_image" /><meta name="twitter:label1" content="Durée de lecture estimée" /><meta name="twitter:data1" content="1 minute" />
1<script type="application/ld+json" class="yoast-schema-graph">{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sql.sh\/cours","url":"https:\/\/sql.sh\/cours","name":"Cours SQL","isPartOf":{"@id":"https:\/\/sql.sh\/#website"},"datePublished":"2012-03-14T21:22:33+00:00","dateModified":"2014-10-24T22:26:24+00:00","breadcrumb":{"@id":"https:\/\/sql.sh\/cours#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sql.sh\/cours"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sql.sh\/cours#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/sql.sh\/"},{"@type":"ListItem","position":2,"name":"Cours"}]},{"@type":"WebSite","@id":"https:\/\/sql.sh\/#website","url":"https:\/\/sql.sh\/","name":"SQL","description":"Cours et tutoriels sur le langage SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sql.sh\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"}]}</script>
1 <link rel="alternate" type="application/rss+xml" title="SQL » Flux" href="https://sql.sh/feed" /><link rel="alternate" type="application/rss+xml" title="SQL » Flux des commentaires" href="https://sql.sh/comments/feed" /><link rel="alternate" type="application/rss+xml" title="SQL » Cours Flux des commentaires" href="https://sql.sh/cours/feed" /><link rel="alternate" title="oEmbed (JSON)" type="application/json+oembed" href="https://sql.sh/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fsql.sh%2Fcours" /><link rel="alternate" title="oEmbed (XML)" type="text/xml+oembed" href="https://sql.sh/wp-json/oembed/1.0/embed?url=https%3A%2F%2Fsql.sh%2Fcours&format=xml" /><style id="wp-img-auto-sizes-contain-inline-css">img:is([sizes=auto i],[sizes^="auto," i]){contain-intrinsic-size:3000px 1500px}</style><style id="wp-emoji-styles-inline-css">img.wp-smiley,img.emoji{display:inline !important;border:none !important;box-shadow:none !important;height:1em !important;width:1em !important;margin:0 20.07em !important;vertical-align:-0.1em !important;background:none !important;padding:0 3!important}</style><style id="wp-block-library-inline-css">:root{--wp-block-synced-color:#7a00df;--wp-block-synced-color--rgb:122,0,223;--wp-bound-block-color:var(--wp-block-synced-color);--wp-editor-canvas-background:#ddd;--wp-admin-theme-color:#007cba;--wp-admin-theme-color--rgb:0,124,186;--wp-admin-theme-color-darker-10:#006ba1;--wp-admin-theme-color-darker-10--rgb:0,107,160.5;--wp-admin-theme-color-darker-20:#005a87;--wp-admin-theme-color-darker-20--rgb:0,90,135;--wp-admin-border-width-focus:2px}@media (min-resolution:192dpi){:root{--wp-admin-border-width-focus:1.5px}}.wp-element-button{cursor:pointer}:root .has-very-light-gray-background-color{background-color:#eee}:root .has-very-dark-gray-background-color{background-color:#313131}:root .has-very-light-gray-color{color:#eee}:root .has-very-dark-gray-color{color:#313131}:root .has-vivid-green-cyan-to-vivid-cyan-blue-gradient-background{background:linear-gradient(135deg,#00d084,#0693e3)}:root .has-purple-crush-gradient-background{background:linear-gradient(135deg,#34e2e4,#4721fb 50%,#ab1dfe)}:root .has-hazy-dawn-gradient-background{background:linear-gradient(135deg,#faaca8,#dad0ec)}:root .has-subdued-olive-gradient-background{background:linear-gradient(135deg,#fafae1,#67a671)}:root .has-atomic-cream-gradient-background{background:linear-gradient(135deg,#fdd79a,#004a59)}:root .has-nightshade-gradient-background{background:linear-gradient(135deg,#330968,#31cdcf)}:root .has-midnight-gradient-background{background:linear-gradient(135deg,#020381,#2874fc)}:root{--wp--preset--font-size--normal:16px;
3--wp--preset--font-size--huge:42px}.has-regular-font-size{font-size:1em}.has-larger-font-size{font-size:2.625em}.has-normal-font-size{font-size:var(--wp--preset--font-size--normal)}.has-huge-font-size{font-size:var(--wp--preset--font-size--huge)}:root .has-text-align-center{text-align:center}:root .has-text-align-left{text-align:left}:root .has-text-align-right{text-align:right}.has-fit-text{white-space:nowrap!important}#end-resizable-editor-section{display:none}.aligncenter{clear:both}.items-justified-left{justify-content:flex-start}.items-justified-center{justify-content:center}.items-justified-right{justify-content:flex-end}.items-justified-space-between{justify-content:space-between}.screen-reader-text{word-wrap:normal!important;border:0;clip-path:inset(50%);height:1px;margin:-1px;overflow:hidden;padding:0;position:absolute;width:1px}.screen-reader-text:focus{background-color:#ddd;clip-path:none;color:#444;display:block;font-size:1em;height:auto;left:5px;line-height:normal;padding:15px 423px 14px;text-decoration:none;top:5px;width:auto;z-index:100000}html :where(.has-border-color){border-style:solid}html :where([style*=border-color]){border-style:solid}html :where([style*=border-top-color]){border-top-style:solid}html :where([style*=border-right-color]){border-right-style:solid}html :where([style*=border-bottom-color]){border-bottom-style:solid}html :where([style*=border-left-color]){border-left-style:solid}html :where([style*=border-width]){border-style:solid}html :where([style*=border-top-width]){border-top-style:solid}html :where([style*=border-right-width]){border-right-style:solid}html :where([style*=border-bottom-width]){border-bottom-style:solid}html :where([style*=border-left-width]){border-left-style:solid}html :where(img[class*=wp-image-]){height:auto;max-width:100%}:where(figure){margin:0 50 1em}html :where(.is-position-sticky){--wp-admin--admin-bar--position-offset:var(--wp-admin--admin-bar--height,0px)}@media screen and (max-width:600px){html:where(.is-position-sticky){--wp-admin--admin-bar--position-offset:0px}}</style><style id="classic-theme-styles-inline-css">.wp-block-button__link{color:#fff;background-color:#32373c;border-radius:9999px;box-shadow:none;text-decoration:none;padding:calc(.667em + 2px) calc(1.333em+2px);font-size:1.125em}.wp-block-file__button{background:#32373c;color:#fff;text-decoration:none}</style><style id="global-styles-inline-css">:root{--wp--preset--aspect-ratio--square:1;--wp--preset--aspect-ratio--4-3:4/3;--wp--preset--aspect-ratio--3-4:3/4;--wp--preset--aspect-ratio--3-2:3/2;--wp--preset--aspect-ratio--2-3:2/3;--wp--preset--aspect-ratio--16-9:16/9;--wp--preset--aspect-ratio--9-16:9/16;--wp--preset--color--black:#000;--wp--preset--color--cyan-bluish-gray:#abb8c3;--wp--preset--color--white:#fff;--wp--preset--color--pale-pink:#f78da7;--wp--preset--color--vivid-red:#cf2e2e;--wp--preset--color--luminous-vivid-orange:#ff6900;--wp--preset--color--luminous-vivid-amber:#fcb900;--wp--preset--color--light-green-cyan:#7bdcb5;--wp--preset--color--vivid-green-cyan:#00d084;--wp--preset--color--pale-cyan-blue:#8ed1fc;
5--wp--preset--color--vivid-cyan-blue:#0693e3;--wp--preset--color--vivid-purple:#9b51e0;--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple:linear-gradient(135deg,rgb(6,147,227) 0%,rgb(155,81,224) 100%);--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan:linear-gradient(135deg,rgb(122,220,180) 0%,rgb(0,208,130) 100%);--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange:linear-gradient(135deg,rgb(252,185,0) 0%,rgb(255,105,0) 100%);--wp--preset--gradient--luminous-vivid-orange-to-vivid-red:linear-gradient(135deg,rgb(255,105,0) 0%,rgb(207,46,46) 100%);--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray:linear-gradient(135deg,rgb(238,238,238) 0%,rgb(169,184,195) 100%);--wp--preset--gradient--cool-to-warm-spectrum:linear-gradient(135deg,rgb(74,234,220) 0%,rgb(151,120,209) 20%,rgb(207,42,186) 40%,rgb(238,44,130) 60%,rgb(251,105,98) 80%,rgb(254,248,76) 100%);--wp--preset--gradient--blush-light-purple:linear-gradient(135deg,rgb(255,206,236) 0%,rgb(152,150,240) 100%);--wp--preset--gradient--blush-bordeaux:linear-gradient(135deg,rgb(254,205,165) 0%,rgb(254,45,45) 50%,rgb(107,0,62) 100%);--wp--preset--gradient--luminous-dusk:linear-gradient(135deg,rgb(255,203,112) 0%,rgb(199,81,192) 50%,rgb(65,88,208) 100%);--wp--preset--gradient--pale-ocean:linear-gradient(135deg,rgb(255,245,203) 0%,rgb(182,227,212) 50%,rgb(51,167,181) 100%);--wp--preset--gradient--electric-grass:linear-gradient(135deg,rgb(202,248,128) 0%,rgb(113,206,126) 100%);--wp--preset--gradient--midnight:linear-gradient(135deg,rgb(2,3,129) 0%,rgb(40,116,252) 100%);--wp--preset--font-size--small:13px;--wp--preset--font-size--medium:20px;--wp--preset--font-size--large:36px;--wp--preset--font-size--x-large:42px;--wp--preset--spacing--20:0.44rem;--wp--preset--spacing--30:0.67rem;--wp--preset--spacing--40:1rem;--wp--preset--spacing--50:1.5rem;--wp--preset--spacing--60:2.25rem;--wp--preset--spacing--70:3.38rem;--wp--preset--spacing--80:5.06rem;--wp--preset--shadow--natural:6px 6px 9px rgba(0, 0, 0, 0.2);--wp--preset--shadow--deep:12px 12px 50px rgba(0, 0, 0, 0.4);--wp--preset--shadow--sharp:6px 6px 0px rgba(0, 0, 0, 0.2);--wp--preset--shadow--outlined:6px 6px 0px -3px rgb(255, 255, 255), 6px 6px rgb(0, 0, 0);--wp--preset--shadow--crisp:6px 6px 0px rgb(0,0,0)}:where(body){margin:0}:where(.is-layout-flex){gap:0.5em}:where(.is-layout-grid){gap:0.5em}body .is-layout-flex{display:flex}.is-layout-flex{flex-wrap:wrap;align-items:center}.is-layout-flex>:is(*,div){margin:0}body .is-layout-grid{display:grid}.is-layout-grid>:is(*,div){margin:0}body{padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px}:root :where(.wp-element-button,.wp-block-button__link){background-color:#32373c;border-width:0;color:#fff;font-family:inherit;font-size:inherit;font-style:inherit;font-weight:inherit;letter-spacing:inherit;line-height:inherit;padding-top:calc(0.667em+2px);padding-right:calc(1.333em+2px);padding-bottom:calc(0.667em+2px);padding-left:calc(1.333em+2px);text-decoration:none;text-transform:inherit}.has-black-color{color:var(--wp--preset--color--black) !important}.has-cyan-bluish-gray-color{color:var(--wp--preset--color--cyan-bluish-gray) !important}.has-white-color{color:var(--wp--preset--color--white) !important}.has-pale-pink-color{color:var(--wp--preset--color--pale-pink) !important}.has-vivid-red-color{color:var(--wp--preset--color--vivid-red) !important}.has-luminous-vivid-orange-color{color:var(--wp--preset--color--luminous-vivid-orange) !important}.has-luminous-vivid-amber-color{color:var(--wp--preset--color--luminous-vivid-amber) !important}.has-light-green-cyan-color{color:var(--wp--preset--color--light-green-cyan) !important}.has-vivid-green-cyan-color{color:var(--wp--preset--color--vivid-green-cyan) !important}.has-pale-cyan-blue-color{color:var(--wp--preset--color--pale-cyan-blue) !important}.has-vivid-cyan-blue-color{color:var(--wp--preset--color--vivid-cyan-blue) !important}.has-vivid-purple-color{color:var(--wp--preset--color--vivid-purple) !important}.has-black-background-color{background-color:var(--wp--preset--color--black) !important}.has-cyan-bluish-gray-background-color{background-color:var(--wp--preset--color--cyan-bluish-gray) !important}.has-white-background-color{background-color:var(--wp--preset--color--white) !important}.has-pale-pink-background-color{background-color:var(--wp--preset--color--pale-pink) !important}.has-vivid-red-background-color{background-color:var(--wp--preset--color--vivid-red) !important}.has-luminous-vivid-orange-background-color{background-color:var(--wp--preset--color--luminous-vivid-orange) !important}.has-luminous-vivid-amber-background-color{background-color:var(--wp--preset--color--luminous-vivid-amber) !important}.has-light-green-cyan-background-color{background-color:var(--wp--preset--color--light-green-cyan) !important}.has-vivid-green-cyan-background-color{background-color:var(--wp--preset--color--vivid-green-cyan) !important}.has-pale-cyan-blue-background-color{background-color:var(--wp--preset--color--pale-cyan-blue) !important}.has-vivid-cyan-blue-background-color{background-color:var(--wp--preset--color--vivid-cyan-blue) !important}.has-vivid-purple-background-color{background-color:var(--wp--preset--color--vivid-purple) !important}.has-black-border-color{border-color:var(--wp--preset--color--black) !important}.has-cyan-bluish-gray-border-color{border-color:var(--wp--preset--color--cyan-bluish-gray) !important}.has-white-border-color{border-color:var(--wp--preset--color--white) !important}.has-pale-pink-border-color{border-color:var(--wp--preset--color--pale-pink) !important}.has-vivid-red-border-color{border-color:var(--wp--preset--color--vivid-red) !important}.has-luminous-vivid-orange-border-color{border-color:var(--wp--preset--color--luminous-vivid-orange) !important}.has-luminous-vivid-amber-border-color{border-color:var(--wp--preset--color--luminous-vivid-amber) !important}.has-light-green-cyan-border-color{border-color:var(--wp--preset--color--light-green-cyan) !important}.has-vivid-green-cyan-border-color{border-color:var(--wp--preset--color--vivid-green-cyan) !important}.has-pale-cyan-blue-border-color{border-color:var(--wp--preset--color--pale-cyan-blue) !important}.has-vivid-cyan-blue-border-color{border-color:var(--wp--preset--color--vivid-cyan-blue) !important}.has-vivid-purple-border-color{border-color:var(--wp--preset--color--vivid-purple) !important}.has-vivid-cyan-blue-to-vivid-purple-gradient-background{background:var(--wp--preset--gradient--vivid-cyan-blue-to-vivid-purple) !important}.has-light-green-cyan-to-vivid-green-cyan-gradient-background{background:var(--wp--preset--gradient--light-green-cyan-to-vivid-green-cyan) !important}.has-luminous-vivid-amber-to-luminous-vivid-orange-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-amber-to-luminous-vivid-orange) !important}.has-luminous-vivid-orange-to-vivid-red-gradient-background{background:var(--wp--preset--gradient--luminous-vivid-orange-to-vivid-red) !important}
5.has-very-light-gray-to-cyan-bluish-gray-gradient-background{background:var(--wp--preset--gradient--very-light-gray-to-cyan-bluish-gray) !important}.has-cool-to-warm-spectrum-gradient-background{background:var(--wp--preset--gradient--cool-to-warm-spectrum) !important}.has-blush-light-purple-gradient-background{background:var(--wp--preset--gradient--blush-light-purple) !important}.has-blush-bordeaux-gradient-background{background:var(--wp--preset--gradient--blush-bordeaux) !important}.has-luminous-dusk-gradient-background{background:var(--wp--preset--gradient--luminous-dusk) !important}.has-pale-ocean-gradient-background{background:var(--wp--preset--gradient--pale-ocean) !important}.has-electric-grass-gradient-background{background:var(--wp--preset--gradient--electric-grass) !important}.has-midnight-gradient-background{background:var(--wp--preset--gradient--midnight) !important}.has-small-font-size{font-size:var(--wp--preset--font-size--small) !important}.has-medium-font-size{font-size:var(--wp--preset--font-size--medium) !important}.has-large-font-size{font-size:var(--wp--preset--font-size--large) !important}.has-x-large-font-size{font-size:var(--wp--preset--font-size--x-large) !important}</style>
5<script id="cookie-notice-front-js-before">var cnArgs = {"ajaxUrl":"https:\/\/sql.sh\/wp-admin\/admin-ajax.php","nonce":"4598bcf606","hideEffect":"fade","position":"bottom","onScroll":false,"onScrollOffset":100,"onClick":false,"cookieName":"cookie_notice_accepted","cookieTime":2592000,"cookieTimeRejected":2592000,"globalCookie":false,"redirection":false,"cache":true,"revokeCookies":false,"revokeCookiesOpt":"automatic"}; 6 7//# sourceURL=cookie-notice-front-js-before</script>
7 <link rel="https://api.w.org/" href="https://sql.sh/wp-json/" /><link rel="alternate" title="JSON" type="application/json" href="https://sql.sh/wp-json/wp/v2/pages/2" /><link rel="EditURI" type="application/rsd+xml" title="RSD" href="https://sql.sh/xmlrpc.php?rsd" /><link rel='shortlink' href='https://sql.sh/?p=2' /><style type="text/css" media="all">@import url("https://sql.sh/wp-content/plugins/wp-table-reloaded/css/plugin.css?ver=1.9.4");</style>
7<script data-no-minify="1" data-cfasync="false">(function(w,d){function a(){var b=d.createElement("script");b.async=!0;b.src="https://sql.sh/wp-content/plugins/wp-rocket/inc/front/js/lazyload.1.0.5.min.js";var a=d.getElementsByTagName("script")[0];a.parentNode.insertBefore(b,a)}w.attachEvent?w.attachEvent("onload",a):w.addEventListener("load",a,!1)})(window,document);</script>
7<script type="text/javascript">jQuery(document).ready(function(){ 8 // hide back to top button 9 jQuery("#back_to_top").hide(); 10 11 // display back to top button after some scroll 12 jQuery(window).scroll(function () { 13 if (jQuery(this).scrollTop() > 100) { 14 jQuery('#back_to_top').fadeIn('slow'); 15 } else { 16 jQuery('#back_to_top').fadeOut('slow'); 17 } 18 }); 19 20 // scroll body to 0px on click 21 jQuery('#back_to_top').click(function () { 22 jQuery('body,html').animate({ 23 scrollTop: 0 24 }, 800); 25 return false; 26 }); 27});</script>
27 </head><body data-rsssl=1 class="wp-singular page-template-default page page-id-2 page-parent wp-theme-sql_sh cookies-not-set">
27<script type="text/javascript">window.google_analytics_uacct = "UA-1599467-30";</script>
27 <div id="page" class="hfeed"> <header id="branding" role="banner"> <hgroup><div id="site-title"> <a href="https://sql.sh/" title="SQL" rel="home"> <img src="https://sql.sh/wp-content/themes/sql_sh/img/sql-sh-logo-245.png" alt="SQL" width="245" height="63" /> </a></div><div id="site-description">Cours et tutoriels sur le langage SQL</div> </hgroup><form method="get" id="searchform" action="https://sql.sh/"> <label for="s" class="assistive-text">Rechercher</label> <input type="text" class="field" name="s" id="s" placeholder="Rechercher" /> <input type="submit" class="submit" name="submit" id="searchsubmit" value="Rechercher" /></form> <nav id="access" role="navigation"><h3 class="assistive-text">Menu principal</h3><div class="skip-link"><a class="assistive-text" href="#content" title="Aller au contenu">Aller au contenu</a></div><div class="menu-menu_header-container"><ul id="menu-menu_header" class="menu"><li id="menu-item-156" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-home menu-item-156"><a href="https://sql.sh/">Accueil</a></li><li id="menu-item-158" class="menu-item menu-item-type-post_type menu-item-object-page current-menu-item page_item page-item-2 current_page_item menu-item-has-children menu-item-158"><a href="https://sql.sh/cours" aria-current="page">Cours</a><ul class="sub-menu"><li id="menu-item-161" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-161"><a href="https://sql.sh/cours/select">SQL SELECT</a></li><li id="menu-item-162" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-162"><a href="https://sql.sh/cours/distinct">SQL DISTINCT</a></li><li id="menu-item-163" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-163"><a href="https://sql.sh/cours/where">SQL WHERE</a></li><li id="menu-item-193" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-193"><a href="https://sql.sh/cours/group-by">SQL GROUP BY</a></li><li id="menu-item-333" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-333"><a href="https://sql.sh/cours/having">SQL HAVING</a></li><li id="menu-item-252" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-252"><a href="https://sql.sh/cours/order-by">SQL ORDER BY</a></li><li id="menu-item-276" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-276"><a href="https://sql.sh/cours/limit">SQL LIMIT</a></li><li id="menu-item-165" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-165"><a href="https://sql.sh/cours/insert-into">SQL INSERT INTO</a></li><li id="menu-item-166" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-166"><a href="https://sql.sh/cours/update">SQL UPDATE</a></li><li id="menu-item-222" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-222"><a href="https://sql.sh/cours/delete">SQL DELETE</a></li><li id="menu-item-3222" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3222"><a href="https://sql.sh/exercices-sql">Exercices SQL</a></li></ul></li><li id="menu-item-159" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-159"><a href="https://sql.sh/sgbd">Bases de Données</a></li><li id="menu-item-3145" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3145"><a href="https://sql.sh/optimisation">Optimisation</a></li><li id="menu-item-2091" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2091"><a href="https://sql.sh/livres">Livres</a></li><li id="menu-item-157" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-157"><a href="https://sql.sh/blog">Blog</a></li></ul></div> </nav> </header><div id="main"><div id="primary"><div id="content" role="main"> <article id="post-2" class="post-2 page type-page status-publish hentry"> <header class="entry-header"><h1 class="entry-title">Cours</h1> </header><div class="entry-content"><p>Cette page recense des cours de SQL pour apprendre à communiquer avec une base de données (lecture, écriture, suppression de données …). Les cours sont simplifiés pour se remémorer la syntaxe des commandes importantes et des tutoriels sont disponibles pour permettre d’apprendre à partir de zéro. De plus, des explications sont données pour apprendre à optimiser les performances d’une base de données.</p><hr /><h2>Commandes SQL</h2><p>Ces cours permettent de comprendre tous les éléments nécessaires pour faire des requêtes SQL. Chaque commande SQL listé ci-dessous possède une fiche détail pour comprendre comment l’utiliser dans une requête.</p><div class="div_list_pages"><ul><li class="page_item page-item-3274"><a href="https://sql.sh/cours/create-trigger">CREATE TRIGGER</a></li><li class="page_item page-item-3265"><a href="https://sql.sh/cours/procedure-stockee">Procédure stockée (CREATE PROCEDURE)</a></li><li class="page_item page-item-23 page_item_has_children"><a href="https://sql.sh/cours/select">SQL SELECT</a></li><li class="page_item page-item-3197"><a href="https://sql.sh/cours/select/sql_no_cache">SQL SQL_NO_CACHE</a></li><li class="page_item page-item-41"><a href="https://sql.sh/cours/distinct">SQL DISTINCT</a></li><li class="page_item page-item-43 page_item_has_children"><a href="https://sql.sh/cours/where">SQL WHERE</a></li><li class="page_item page-item-84"><a href="https://sql.sh/cours/where/and-or">SQL AND & OR</a></li><li class="page_item page-item-298"><a href="https://sql.sh/cours/where/in">SQL IN</a></li><li class="page_item page-item-1381"><a href="https://sql.sh/cours/where/exists">SQL EXISTS</a></li><li class="page_item page-item-2048"><a href="https://sql.sh/cours/where/all">SQL ALL</a></li><li class="page_item page-item-2051"><a href="https://sql.sh/cours/where/any">SQL ANY / SOME</a></li><li class="page_item page-item-299"><a href="https://sql.sh/cours/where/between">SQL BETWEEN</a></li><li class="page_item page-item-300 page_item_has_children"><a href="https://sql.sh/cours/where/like">SQL LIKE</a></li><li class="page_item page-item-3088"><a href="https://sql.sh/cours/where/like/wildcards">SQL Wildcards</a></li><li class="page_item page-item-1361"><a href="https://sql.sh/cours/where/is">SQL IS NULL / IS NOT NULL</a></li><li class="page_item page-item-45 page_item_has_children"><a href="https://sql.sh/cours/group-by">SQL GROUP BY</a></li><li class="page_item page-item-3061"><a href="https://sql.sh/cours/group-by/with-rollup">SQL GROUP BY WITH ROLLUP</a></li><li class="page_item page-item-296"><a href="https://sql.sh/cours/having">SQL HAVING</a></li><li class="page_item page-item-224"><a href="https://sql.sh/cours/order-by">SQL ORDER BY</a></li><li class="page_item page-item-1321"><a href="https://sql.sh/cours/alias">SQL AS (alias)</a></li><li class="page_item page-item-226"><a href="https://sql.sh/cours/limit">SQL LIMIT</a></li><li class="page_item page-item-1382"><a href="https://sql.sh/cours/case">SQL CASE</a></li><li class="page_item page-item-655 page_item_has_children"><a href="https://sql.sh/cours/union">SQL UNION</a></li><li class="page_item page-item-682"><a href="https://sql.sh/cours/union/union-all">SQL UNION ALL</a></li><li class="page_item page-item-972"><a href="https://sql.sh/cours/intersect">SQL INTERSECT</a></li><li class="page_item page-item-1000"><a href="https://sql.sh/cours/except">
27SQL EXCEPT / MINUS</a></li><li class="page_item page-item-253 page_item_has_children"><a href="https://sql.sh/cours/jointures">Jointure SQL</a></li><li class="page_item page-item-1054"><a href="https://sql.sh/cours/jointures/inner-join">SQL INNER JOIN</a></li><li class="page_item page-item-656"><a href="https://sql.sh/cours/jointures/cross-join">SQL CROSS JOIN</a></li><li class="page_item page-item-657"><a href="https://sql.sh/cours/jointures/left-join">SQL LEFT JOIN</a></li><li class="page_item page-item-660"><a href="https://sql.sh/cours/jointures/right-join">SQL RIGHT JOIN</a></li><li class="page_item page-item-1052"><a href="https://sql.sh/cours/jointures/full-join">SQL FULL JOIN</a></li><li class="page_item page-item-1148"><a href="https://sql.sh/cours/jointures/self-join">SQL SELF JOIN</a></li><li class="page_item page-item-2168"><a href="https://sql.sh/cours/jointures/natural-join">SQL NATURAL JOIN</a></li><li class="page_item page-item-1389"><a href="https://sql.sh/cours/sous-requete">SQL Sous-requête</a></li><li class="page_item page-item-1383 page_item_has_children"><a href="https://sql.sh/cours/index">Index SQL</a></li><li class="page_item page-item-1617"><a href="https://sql.sh/cours/index/create">SQL CREATE INDEX</a></li><li class="page_item page-item-125 page_item_has_children"><a href="https://sql.sh/cours/insert-into">SQL INSERT INTO</a></li><li class="page_item page-item-349"><a href="https://sql.sh/cours/insert-into/on-duplicate-key">SQL ON DUPLICATE KEY UPDATE</a></li><li class="page_item page-item-62"><a href="https://sql.sh/cours/update">SQL UPDATE</a></li><li class="page_item page-item-63"><a href="https://sql.sh/cours/delete">SQL DELETE</a></li><li class="page_item page-item-2038"><a href="https://sql.sh/cours/merge">SQL MERGE</a></li><li class="page_item page-item-1700"><a href="https://sql.sh/cours/truncate-table">SQL TRUNCATE TABLE</a></li><li class="page_item page-item-444"><a href="https://sql.sh/cours/create-database">SQL CREATE DATABASE</a></li><li class="page_item page-item-448"><a href="https://sql.sh/cours/drop-database">SQL DROP DATABASE</a></li><li class="page_item page-item-64 page_item_has_children"><a href="https://sql.sh/cours/create-table">SQL CREATE TABLE</a></li><li class="page_item page-item-3073"><a href="https://sql.sh/cours/create-table/auto_increment">SQL AUTO_INCREMENT</a></li><li class="page_item page-item-3082"><a href="https://sql.sh/cours/create-table/primary-key">SQL PRIMARY KEY</a></li><li class="page_item page-item-489"><a href="https://sql.sh/cours/alter-table">SQL ALTER TABLE</a></li><li class="page_item page-item-567"><a href="https://sql.sh/cours/drop-table">SQL DROP TABLE</a></li><li class="page_item page-item-417"><a href="https://sql.sh/cours/explain">SQL EXPLAIN</a></li><li class="page_item page-item-2638"><a href="https://sql.sh/cours/optimize">SQL OPTIMIZE</a></li><li class="page_item page-item-2161"><a href="https://sql.sh/cours/commentaires">Commentaires en SQL</a></li></ul><div class="clear"></div></div><hr /><h2>Jointures SQL</h2><p>Les jointures peuvent combiner les données de plusieurs tables avec un gain intéressant sur les performances. Les cours suivant expliquent les différentes possibilités de jointures.</p><div class="div_list_pages"><ul><li class="page_item page-item-1054"><a href="https://sql.sh/cours/jointures/inner-join">SQL INNER JOIN</a></li><li class="page_item page-item-656"><a href="https://sql.sh/cours/jointures/cross-join">SQL CROSS JOIN</a></li><li class="page_item page-item-657"><a href="https://sql.sh/cours/jointures/left-join">SQL LEFT JOIN</a></li><li class="page_item page-item-660"><a href="https://sql.sh/cours/jointures/right-join">SQL RIGHT JOIN</a></li><li class="page_item page-item-1052"><a href="https://sql.sh/cours/jointures/full-join">SQL FULL JOIN</a></li><li class="page_item page-item-1148"><a href="https://sql.sh/cours/jointures/self-join">SQL SELF JOIN</a></li><li class="page_item page-item-2168"><a href="https://sql.sh/cours/jointures/natural-join">SQL NATURAL JOIN</a></li></ul><div class="clear"></div></div><hr /><h2>Fonctions SQL</h2><p>L’utilisation de fonctions facilite les calculs ou la lecture de données, grâce à des fonctions mathématiques ou des fonctions améliorant l&r
27squo;affichage des données.</p><div class="div_list_pages"><ul><li class="page_item page-item-3152"><a href="https://sql.sh/fonctions/date_format">SQL DATE_FORMAT()</a></li><li class="page_item page-item-2611"><a href="https://sql.sh/fonctions/timediff">SQL TIMEDIFF()</a></li><li class="page_item page-item-3126"><a href="https://sql.sh/fonctions/timestamp">SQL TIMESTAMP()</a></li><li class="page_item page-item-575 page_item_has_children"><a href="https://sql.sh/fonctions/agregation">Fonctions d’agrégation SQL</a></li><li class="page_item page-item-385"><a href="https://sql.sh/fonctions/agregation/avg">SQL AVG()</a></li><li class="page_item page-item-383"><a href="https://sql.sh/fonctions/agregation/count">SQL COUNT()</a></li><li class="page_item page-item-364"><a href="https://sql.sh/fonctions/agregation/max">SQL MAX()</a></li><li class="page_item page-item-387"><a href="https://sql.sh/fonctions/agregation/min">SQL MIN()</a></li><li class="page_item page-item-381"><a href="https://sql.sh/fonctions/agregation/sum">SQL SUM()</a></li><li class="page_item page-item-1390"><a href="https://sql.sh/fonctions/isnull">SQL ISNULL()</a></li><li class="page_item page-item-1845"><a href="https://sql.sh/fonctions/locate">SQL LOCATE()</a></li><li class="page_item page-item-2506"><a href="https://sql.sh/fonctions/reverse">SQL REVERSE()</a></li><li class="page_item page-item-1179"><a href="https://sql.sh/fonctions/chaines-de-caracteres">Fonctions de chaînes de caractères</a></li><li class="page_item page-item-361"><a href="https://sql.sh/fonctions/concat">SQL CONCAT()</a></li><li class="page_item page-item-352"><a href="https://sql.sh/fonctions/replace">SQL REPLACE()</a></li><li class="page_item page-item-395"><a href="https://sql.sh/fonctions/substring">SQL SUBSTRING()</a></li><li class="page_item page-item-389"><a href="https://sql.sh/fonctions/trim">SQL TRIM()</a></li><li class="page_item page-item-1665"><a href="https://sql.sh/fonctions/ltrim">SQL LTRIM()</a></li><li class="page_item page-item-1667"><a href="https://sql.sh/fonctions/rtrim">SQL RTRIM()</a></li><li class="page_item page-item-397"><a href="https://sql.sh/fonctions/lpad">SQL LPAD()</a></li><li class="page_item page-item-1704"><a href="https://sql.sh/fonctions/length">SQL LENGTH()</a></li><li class="page_item page-item-360"><a href="https://sql.sh/fonctions/upper">SQL UPPER()</a></li><li class="page_item page-item-358"><a href="https://sql.sh/fonctions/lower">SQL LOWER()</a></li><li class="page_item page-item-2487"><a href="https://sql.sh/fonctions/ucase">SQL UCASE()</a></li><li class="page_item page-item-2490"><a href="https://sql.sh/fonctions/lcase">SQL LCASE()</a></li><li class="page_item page-item-1727"><a href="https://sql.sh/fonctions/instr">SQL INSTR()</a></li><li class="page_item page-item-1671"><a href="https://sql.sh/fonctions/soundex">SQL SOUNDEX()</a></li><li class="page_item page-item-1742"><a href="https://sql.sh/fonctions/mathematiques">Fonctions mathématiques / numérique</a></li><li class="page_item page-item-354"><a href="https://sql.sh/fonctions/rand">SQL RAND()</a></li><li class="page_item page-item-357"><a href="https://sql.sh/fonctions/round">SQL ROUND()</a></li><li class="page_item page-item-1750 page_item_has_children"><a href="https://sql.sh/fonctions/date-heure">Fonctions de dates et d’heures</a></li><li class="page_item page-item-3102"><a href="https://sql.sh/fonctions/date-heure/dayofweek">SQL DAYOFWEEK()</a></li><li class="page_item page-item-362"><a href="https://sql.sh/fonctions/now">SQL NOW()</a></li><li class="page_item page-item-2453"><a href="https://sql.sh/fonctions/sec_to_time">SQL SEC_TO_TIME()</a></li><li class="page_item page-item-1723"><a href="https://sql.sh/fonctions/datediff">SQL DATEDIFF()</a></li><li class="page_item page-item-2558"><a href="https://sql.sh/fonctions/month">SQL MONTH()</a></li><li class="page_item page-item-2559"><a href="https://sql.sh/fonctions/year">SQL YEAR()</a></li><li class="page_item page-item-1785"><a href="https://sql.sh/fonctions/chiffrement">Fonctions de chiffrements</a></li><li class="page_item page-item-1720"><a href="https://sql.sh/fonctions/cast">SQL CAST()</a></li><li class="page_item page-item-1725"><a href="https://sql.sh/fonctions/convert">SQL CONVERT() (MySQL et SQL Server)</a></li><li class="page_item page-item-2575"><a href="https://sql.sh/fonctions/convert-postgresql-oracle">SQL CONVERT() (PostgreSQL et Oracle)</a></li><li class="page_item page-item-1529"><a href="https://sql.sh/fonctions/group_concat">SQL GROUP_CONCAT()</a></li><li class="page_item page-item-1980"><a href="https://sql.sh/fonctions/version">SQL VERSION()</a></li><li class="page_item page-item-1779"><a href="https://sql.sh/fonctions/md5">SQL MD5()</a></li><li class="page_item page-item-1781"><a href="https://sql.sh/fonctions/sha1">SQL SHA1()</a></li><li class="page_item page-item-391"><a href="https://sql.sh/fonctions/left">SQL LEFT()</a></li><li class="page_item page-item-393"><a href="https://sql.sh/fonctions/right">SQL RIGHT()</a></li></ul><div class="clear"></div></div></div> <footer class="entry-meta"> </footer> </article><div id="partage_page"><div><strong>Partager</strong></div><div id="partage_twitter" class="partage_button"> <a href="http://twitter.com/share" class="twitter-share-button" data-count="vertical">Tweet</a></div><div id="partage_googlep" class="partage_button"> <g:plusone size="tall"></g:plusone></div><div id="partage_facebook" class="partage_button"> <iframe src="https://www.facebook.com/plugins/like.php?href=https://sql.sh/cours&layout=box_count&show_faces=true&
27width=65&action=like&font=arial&colorscheme=light&height=65" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:65px; height:65px; margin-top:3px;" allowTransparency="true"></iframe></div><div id="annonce" class="partage_button"> <ins class="adsbygoogle" 28style="display:inline-block;width:234px;height:60px" 29data-ad-client="ca-pub-3353185178320650" 30data-ad-slot="4940696501"></ins>
30<script>(adsbygoogle = window.adsbygoogle || []).push({});</script>
30 </div><div class="clear"></div></div></div></div><div id="secondary_left" class="widget-area" role="complementary"><div class="menu-page_sidebar-container"><ul id="menu-page_sidebar" class="menu"><li id="menu-item-281" class="menu-item menu-item-type-post_type menu-item-object-page current-menu-item page_item page-item-2 current_page_item menu-item-has-children menu-item-281"><a href="https://sql.sh/cours" aria-current="page">Cours</a><ul class="sub-menu"><li id="menu-item-282" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-282"><a href="https://sql.sh/cours/select">SQL SELECT</a><ul class="sub-menu"><li id="menu-item-283" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-283"><a href="https://sql.sh/cours/distinct">SQL DISTINCT</a></li><li id="menu-item-3203" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3203"><a href="https://sql.sh/cours/select/sql_no_cache">SQL SQL_NO_CACHE</a></li></ul></li><li id="menu-item-284" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-284"><a href="https://sql.sh/cours/where">SQL WHERE</a><ul class="sub-menu"><li id="menu-item-285" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-285"><a href="https://sql.sh/cours/where/and-or">SQL AND & OR</a></li><li id="menu-item-432" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-432"><a href="https://sql.sh/cours/where/in">SQL IN</a></li><li id="menu-item-415" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-415"><a href="https://sql.sh/cours/where/between">SQL BETWEEN</a></li><li id="menu-item-441" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-441"><a href="https://sql.sh/cours/where/like">SQL LIKE</a><ul class="sub-menu"><li id="menu-item-3101" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3101"><a href="https://sql.sh/cours/where/like/wildcards">SQL Wildcards</a></li></ul></li><li id="menu-item-1378" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1378"><a href="https://sql.sh/cours/where/is">SQL IS NULL / IS NOT NULL</a></li></ul></li><li id="menu-item-286" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-286"><a href="https://sql.sh/cours/group-by">SQL GROUP BY</a><ul class="sub-menu"><li id="menu-item-3072" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3072"><a href="https://sql.sh/cours/group-by/with-rollup">SQL WITH ROLLUP</a></li></ul></li><li id="menu-item-334" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-334"><a href="https://sql.sh/cours/having">SQL HAVING</a></li><li id="menu-item-287" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-287"><a href="https://sql.sh/cours/order-by">SQL ORDER BY</a></li><li id="menu-item-1355" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1355"><a href="https://sql.sh/cours/alias">SQL AS (alias)</a></li><li id="menu-item-288" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-288"><a href="https://sql.sh/cours/limit">SQL LIMIT</a></li><li id="menu-item-1525" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1525"><a href="https://sql.sh/cours/case">SQL CASE</a></li><li id="menu-item-700" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-700"><a href="https://sql.sh/cours/union">SQL UNION</a><ul class="sub-menu"><li id="menu-item-710" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-710"><a href="https://sql.sh/cours/union/union-all">SQL UNION ALL</a></li></ul></li><li id="menu-item-983" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-983"><a href="https://sql.sh/cours/intersect">SQL INTERSECT</a></li><li id="menu-item-1024" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1024"><a href="https://sql.sh/cours/except">
30SQL EXCEPT / MINUS</a></li><li id="menu-item-289" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-289"><a href="https://sql.sh/cours/insert-into">SQL INSERT INTO</a><ul class="sub-menu"><li id="menu-item-1174" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1174"><a href="https://sql.sh/cours/insert-into/on-duplicate-key">SQL ON DUPLICATE KEY UPDATE</a></li></ul></li><li id="menu-item-290" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-290"><a href="https://sql.sh/cours/update">SQL UPDATE</a></li><li id="menu-item-291" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-291"><a href="https://sql.sh/cours/delete">SQL DELETE</a></li><li id="menu-item-2041" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2041"><a href="https://sql.sh/cours/merge">SQL MERGE</a></li><li id="menu-item-1956" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1956"><a href="https://sql.sh/cours/truncate-table">SQL TRUNCATE TABLE</a></li><li id="menu-item-447" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-447"><a href="https://sql.sh/cours/create-database">SQL CREATE DATABASE</a></li><li id="menu-item-487" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-487"><a href="https://sql.sh/cours/drop-database">SQL DROP DATABASE</a></li><li id="menu-item-488" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-488"><a href="https://sql.sh/cours/create-table">SQL CREATE TABLE</a><ul class="sub-menu"><li id="menu-item-3087" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3087"><a href="https://sql.sh/cours/create-table/primary-key">SQL PRIMARY KEY</a></li><li id="menu-item-3080" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3080"><a href="https://sql.sh/cours/create-table/auto_increment">SQL AUTO_INCREMENT</a></li></ul></li><li id="menu-item-503" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-503"><a href="https://sql.sh/cours/alter-table">SQL ALTER TABLE</a></li><li id="menu-item-574" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-574"><a href="https://sql.sh/cours/drop-table">SQL DROP TABLE</a></li><li id="menu-item-677" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-677"><a href="https://sql.sh/cours/jointures">Jointure SQL</a><ul class="sub-menu"><li id="menu-item-1070" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1070"><a href="https://sql.sh/cours/jointures/inner-join">SQL INNER JOIN</a></li><li id="menu-item-1081" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1081"><a href="https://sql.sh/cours/jointures/cross-join">SQL CROSS JOIN</a></li><li id="menu-item-1098" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1098"><a href="https://sql.sh/cours/jointures/left-join">SQL LEFT JOIN</a></li><li id="menu-item-1131" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1131"><a href="https://sql.sh/cours/jointures/right-join">SQL RIGHT JOIN</a></li><li id="menu-item-1146" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1146"><a href="https://sql.sh/cours/jointures/full-join">SQL FULL JOIN</a></li><li id="menu-item-1158" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1158"><a href="https://sql.sh/cours/jointures/self-join">SQL SELF JOIN</a></li><li id="menu-item-2182" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2182"><a href="https://sql.sh/cours/jointures/natural-join">SQL NATURAL JOIN</a></li></ul></li><li id="menu-item-1469" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1469"><a href="https://sql.sh/cours/sous-requete">SQL Sous-requête</a><ul class="sub-menu"><li id="menu-item-2047" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2047"><a href="https://sql.sh/cours/where/exists">SQL EXISTS</a></li><li id="menu-item-2055" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2055"><a href="https://sql.sh/cours/where/all">SQL ALL</a></li><li id="menu-item-2080" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2080"><a href="https://sql.sh/cours/where/any">SQL ANY / SOME</a></li></ul></li><li id="menu-item-1624" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1624"><a href="https://sql.sh/cours/index">Index SQL</a><ul class="sub-menu"><li id="menu-item-1633" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1633"><a href="https://sql.sh/cours/index/create">SQL CREATE INDEX</a></li></ul></li><li id="menu-item-1994" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1994"><a href="https://sql.sh/cours/explain">SQL EXPLAIN</a></li><li id="menu-item-2644" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2644"><a href="https://sql.sh/cours/optimize">SQL OPTIMIZE</a></li><li id="menu-item-2228" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2228"><a href="https://sql.sh/cours/commentaires">Commentaires en SQL</a></li><li id="menu-item-3223" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3223"><a href="https://sql.sh/exercices-sql">Exercices SQL</a></li></ul></li><li id="menu-item-580" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-580"><a href="https://sql.sh/fonctions">Fonctions SQL</a><ul class="sub-menu"><li id="menu-item-589" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-589"><a href="https://sql.sh/fonctions/agregation">Fonctions d’agrégation</a><ul class="sub-menu"><li id="menu-item-621" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-621"><a href="https://sql.sh/fonctions/agregation/avg">SQL AVG()</a></li><li id="menu-item-637" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-637"><a href="https://sql.sh/fonctions/agregation/count">SQL COUNT()</a></li><li id="menu-item-729" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-729"><a href="https://sql.sh/fonctions/agregation/max">SQL MAX()</a></li><li id="menu-item-1241" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1241"><a href="https://sql.sh/fonctions/agregation/min">SQL MIN()</a></li><li id="menu-item-1292" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1292"><a href="https://sql.sh/fonctions/agregation/sum">SQL SUM()</a></li></ul></li><li id="menu-item-1191" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1191"><a href="https://sql.sh/fonctions/chaines-de-caracteres">Fonctions de chaînes de caractères</a><ul class="sub-menu"><li id="menu-item-1648" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1648"><a href="https://sql.sh/fonctions/concat">SQL CONCAT()</a></li><li id="menu-item-1802" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1802"><a href="https://sql.sh/fonctions/length">SQL LENGTH()</a></li><li id="menu-item-1203" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1203"><a href="https://sql.sh/fonctions/replace">SQL REPLACE()</a></li><li id="menu-item-1778" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1778"><a href="https://sql.sh/fonctions/soundex">SQL SOUNDEX()</a></li><li id="menu-item-1269" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1269"><a href="https://sql.sh/fonctions/substring">SQL SUBSTRING()</a></li><li id="menu-item-2585" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2585"><a href="https://sql.sh/fonctions/left">SQL LEFT()</a></li><li id="menu-item-2589" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2589"><a href="https://sql.sh/fonctions/right">SQL RIGHT()</a></li><li id="menu-item-2510" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2510"><a href="https://sql.sh/fonctions/reverse">SQL REVERSE()</a></li><li id="menu-item-1664" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1664"><a href="https://sql.sh/fonctions/trim">SQL TRIM()</a></li><li id="menu-item-1681" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1681"><a href="https://sql.sh/fonctions/ltrim">SQL LTRIM()</a></li><li id="menu-item-1690" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1690"><a href="https://sql.sh/fonctions/rtrim">SQL RTRIM()</a></li><li id="menu-item-2280" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2280"><a href="https://sql.sh/fonctions/lpad">SQL LPAD()</a></li><li id="menu-item-1709" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1709"><a href="https://sql.sh/fonctions/upper">SQL UPPER()</a></li><li id="menu-item-1717" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1717"><a href="https://sql.sh/fonctions/lower">SQL LOWER()</a></li><li id="menu-item-2656" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2656"><a href="https://sql.sh/fonctions/ucase">SQL UCASE()</a></li><li id="menu-item-2655" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2655"><a href="https://sql.sh/fonctions/lcase">SQL LCASE()</a></li><li id="menu-item-1961" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1961"><a href="https://sql.sh/fonctions/locate">SQL LOCATE()</a></li><li id="menu-item-1855" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1855"><a href="https://sql.sh/fonctions/instr">SQL INSTR()</a></li></ul></li><li id="menu-item-1749" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1749"><a href="https://sql.sh/fonctions/mathematiques">Fonctions mathématiques / numérique</a><ul class="sub-menu"><li id="menu-item-1699" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1699"><a href="https://sql.sh/fonctions/rand">SQL RAND()</a></li><li id="menu-item-1485" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1485"><a href="https://sql.sh/fonctions/round">SQL ROUND()</a></li></ul></li><li id="menu-item-1757" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1757"><a href="https://sql.sh/fonctions/date-heure">Fonctions de dates et d’heures</a><ul class="sub-menu"><li id="menu-item-3161" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3161"><a href="https://sql.sh/fonctions/date_format">SQL DATE_FORMAT()</a></li><li id="menu-item-2480" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2480"><a href="https://sql.sh/fonctions/datediff">SQL DATEDIFF()</a></li><li id="menu-item-3114" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3114"><a href="https://sql.sh/fonctions/date-heure/dayofweek">SQL DAYOFWEEK()</a></li><li id="menu-item-2635" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2635"><a href="https://sql.sh/fonctions/month">SQL MONTH()</a></li><li id="menu-item-1737" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1737"><a href="https://sql.sh/fonctions/now">SQL NOW()</a></li><li id="menu-item-2469" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2469"><a href="https://sql.sh/fonctions/sec_to_time">SQL SEC_TO_TIME()</a></li><li id="menu-item-3125" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3125"><a href="https://sql.sh/fonctions/timediff">SQL TIMEDIFF()</a></li><li id="menu-item-3132" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3132"><a href="https://sql.sh/fonctions/timestamp">SQL TIMESTAMP()</a></li><li id="menu-item-2625" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2625"><a href="https://sql.sh/fonctions/year">SQL YEAR()</a></li></ul></li><li id="menu-item-1792" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-1792"><a href="https://sql.sh/fonctions/chiffrement">Fonctions de chiffrements</a><ul class="sub-menu"><li id="menu-item-1816" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1816"><a href="https://sql.sh/fonctions/md5">SQL MD5()</a></li></ul></li><li id="menu-item-1768" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1768"><a href="https://sql.sh/fonctions/cast">SQL CAST()</a></li><li id="menu-item-2574" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2574"><a href="https://sql.sh/fonctions/convert">SQL CONVERT() (MySQL et SQL Server)</a></li><li id="menu-item-2580" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2580"><a href="https://sql.sh/fonctions/convert-postgresql-oracle">SQL CONVERT() (PostgreSQL et Oracle)</a></li><li id="menu-item-2270" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2270"><a href="https://sql.sh/fonctions/isnull">SQL ISNULL()</a></li><li id="menu-item-1944" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1944"><a href="https://sql.sh/fonctions/group_concat">SQL GROUP_CONCAT()</a></li><li id="menu-item-2497" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2497"><a href="https://sql.sh/fonctions/version">SQL VERSION()</a></li></ul></li><li id="menu-item-3273" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3273"><a href="https://sql.sh/cours/procedure-stockee">Procédure stockée (CREATE PROCEDURE)</a></li><li id="menu-item-3279" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3279"><a href="https://sql.sh/cours/create-trigger">CREATE TRIGGER</a></li><li id="menu-item-280" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-has-children menu-item-280"><a href="https://sql.sh/sgbd">Système de Gestion de Base de Données</a><ul class="sub-menu"><li id="menu-item-984" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-984"><a href="https://sql.sh/sgbd/mysql">MySQL</a></li><li id="menu-item-985" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-985"><a href="https://sql.sh/sgbd/postgresql">PostgreSQL</a></li><li id="menu-item-2219" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2219"><a href="https://sql.sh/sgbd/mariadb">MariaDB</a></li><li id="menu-item-2070" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2070"><a href="https://sql.sh/sgbd/oracle-database">Oracle Database</a></li><li id="menu-item-2155" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2155"><a href="https://sql.sh/sgbd/sql-server">Microsoft SQL Server</a></li><li id="menu-item-2065" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2065"><a href="https://sql.sh/sgbd/sqlite">SQLite</a></li><li id="menu-item-2120" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2120"><a href="https://sql.sh/sgbd/microsoft-access">Access</a></li><li id="menu-item-2129" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2129"><a href="https://sql.sh/sgbd/openoffice-org-base">
30OpenOffice.org Base</a></li><li id="menu-item-2099" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2099"><a href="https://sql.sh/sgbd/cassandra">Cassandra</a></li><li id="menu-item-2105" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2105"><a href="https://sql.sh/sgbd/redis">Redis</a></li><li id="menu-item-2114" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2114"><a href="https://sql.sh/sgbd/mongodb">MongoDB</a></li><li id="menu-item-3189" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3189"><a href="https://sql.sh/sgbd/neo4j">Neo4j</a></li></ul></li><li id="menu-item-1953" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1953"><a href="https://sql.sh/moteurs">Moteurs de stockage</a></li><li id="menu-item-2263" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-2263"><a href="https://sql.sh/logiciels">Logiciels SQL</a></li></ul></div></div><div id="secondary_right" class="widget-area" role="complementary"><div></div> <aside class="widget">
30<script type="text/javascript">google_ad_client = "ca-pub-3353185178320650"; 31 /* Sql_sh_sidebar */ 32 google_ad_slot = "8828142100"; 33 google_ad_width = 160; 34 google_ad_height = 600;</script>
34
34<script type="text/javascript" 35 src="//pagead2.googlesyndication.com/pagead/show_ads.js"></script>
35 </aside><aside class="widget"><div id="ebook_pdf_sql" class="sidebar_box"> <a href="https://sql.sh/2143-cours-sql-pdf">Ebook SQL (PDF)</a></div><div id="ebook_epub_sql" class="sidebar_box"> <a href="https://sql.sh/2408-ebook-cours-sql">Ebook SQL (.epub)</a></div><div id="memento_sql" class="sidebar_box"> <a href="https://sql.sh/919-aide-memoire-mysql">Aide mémoire MySQL</a></div><div id="boutique_sql" class="sidebar_box"> <a href="https://sql.sh/boutique">Boutique SQL</a></div><div id="sql_facebook" class="sidebar_box"> <a href="http://www.facebook.com/pages/SQLsh/384110728362992">SQL.sh sur Facebook</a></div><div id="sql_twitter" class="sidebar_box"> <a href="https://twitter.com/sql_sh">SQL.sh sur Twitter</a></div> </aside></div><div class="clear"></div></div><footer id="colophon" role="contentinfo"><div class="col"><h2>Livres recommandés</h2> <button class="livre_lien" title="SQL de Frédéric Brouard" 36onclick="window.open('http://www.amazon.fr/gp/product/2744011843/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&tag=tonyarchacom-21&linkCode=as2&camp=1642&creative=6746&creativeASIN=2744011843'); _gaq.push(['_trackEvent', 'footer', 'click', 'livre-sql-frederic-brouard']);"><div id="livre1"></div><div class="livre_titre">SQL</div><div class="livre_auteur">Frédéric Brouard</div> </button> <button class="livre_lien" title="Administrez vos bases de données avec MySQL de Chantal Gribaumont" 37onclick="window.open('http://www.amazon.fr/gp/product/B00850RB1S/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&tag=tonyarchacom-21&linkCode=as2&camp=1642&creative=6746&creativeASIN=B00850RB1S'); _gaq.push(['_trackEvent', 'footer', 'click', 'livre-mysql-sdz']);"><div id="livre2"></div><div class="livre_titre">Administrez vos bases de données avec MySQL</div><div class="livre_auteur">Chantal Gribaumont</div> </button></div><div class="col"><h2>A propos</h2> <nav id="footer-link" role="navigation"><div class="menu-menu_footer-container"><ul id="menu-menu_footer" class="menu"><li id="menu-item-3225" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3225"><a href="https://sql.sh/forums">Forums</a></li><li id="menu-item-155" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-155"><a href="https://sql.sh/plan">Plan du site</a></li><li id="menu-item-185" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-185"><a href="https://sql.sh/mentions-legales">Mentions légales</a></li><li id="menu-item-1833" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-1833"><a href="https://sql.sh/partenaires">Partenaires</a></li><li id="menu-item-186" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-186"><a href="https://sql.sh/contact">Contact</a></li></ul></div> </nav></div><div class="col"><h2>Suivre sql.sh</h2> <a href="http://feeds.feedburner.com/sql-sh">S'abonner au flux RSS</a></div><div id="site-generator"> Copyright sql.sh</div> </footer></div><button id="back_to_top" onclick="_gaq.push(['_trackEvent', 'ergonomie', 'click', 'back-to-top']);" title="Retour en haut"> <img src="https://sql.sh/wp-content/themes/sql_sh/img/button-back-to-top-40.png" alt="bouton de retour en haut" width="40" height="40" /> </button>
37<script type="speculationrules">{"prefetch":[{"source":"document","where":{"and":[{"href_matches":"/*"},{"not":{"href_matches":["/wp-*.php","/wp-admin/*","/wp-content/uploads/*","/wp-content/*","/wp-content/plugins/*","/wp-content/themes/sql_sh/*","/*\\?(.+)"]}},{"not":{"selector_matches":"a[rel~=\"nofollow\"]"}},{"not":{"selector_matches":".no-prefetch, .no-prefetch a"}}]},"eagerness":"conservative"}]}</script>
37
37<script type="text/javascript" id="bbp-swap-no-js-body-class">document.body.className = document.body.className.replace( 'bbp-no-js', 'bbp-js' );</script>
37
37<script id="wp-emoji-settings" type="application/json">{"baseUrl":"https://s.w.org/images/core/emoji/17.0.2/72x72/","ext":".png","svgUrl":"https://s.w.org/images/core/emoji/17.0.2/svg/","svgExt":".svg","source":{"concatemoji":"https://sql.sh/wp-includes/js/wp-emoji-release.min.js?ver=0.0.1"}}</script>
37
37<script type="module">/*! This file is auto-generated */ 38var e="script#wp-emoji-settings",t=document.querySelector(e);if(!(t instanceof HTMLScriptElement))throw new Error("Element missing: "+e);const r=JSON.parse(t.text),s=(window._wpemojiSettings=r,"wpEmojiSettingsSupports"),o=["flag","emoji"];function i(e){try{var t={supportTests:e,timestamp:(new Date).valueOf()};sessionStorage.setItem(s,JSON.stringify(t))}catch(e){}}function c(e,t,n){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);t=new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data);e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(n,0,0);const r=new Uint32Array(e.getImageData(0,0,e.canvas.width,e.canvas.height).data);return t.every((e,t)=>e===r[t])}function p(e,t){e.clearRect(0,0,e.canvas.width,e.canvas.height),e.fillText(t,0,0);var n=e.getImageData(16,16,1,1);for(let e=0;e<n.data.length;e++)if(0!==n.data[e])return!1;return!0}function u(e,t,n,r){switch(t){case"flag":return n(e,"\ud83c\udff3\ufe0f\u200d\u26a7\ufe0f","\ud83c\udff3\ufe0f\u200b\u26a7\ufe0f")?!1:!n(e,"\ud83c\udde8\ud83c\uddf6","\ud83c\udde8\u200b\ud83c\uddf6")&&!n(e,"\ud83c\udff4\udb40\udc67\udb40\udc62\udb40\udc65\udb40\udc6e\udb40\udc67\udb40\udc7f","\ud83c\udff4\u200b\udb40\udc67\u200b\udb40\udc62\u200b\udb40\udc65\u200b\udb40\udc6e\u200b\udb40\udc67\u200b\udb40\udc7f");case"emoji":return!r(e,"\ud83e\u1fac8")}return!1}function f(e,t,n,r){let a;const s=(a="undefined"!=typeof WorkerGlobalScope&&self instanceof WorkerGlobalScope?new OffscreenCanvas(300,150):document.createElement("canvas")).getContext("2d",{willReadFrequently:!0}),o=(s.textBaseline="top",s.font="600 32px Arial",{});return e.forEach(e=>{o[e]=t(s,e,n,r)}),o}function a(e){var t=document.createElement("script");t.src=e,t.defer=!0,document.head.appendChild(t)}r.supports={everything:!0,everythingExceptFlag:!0},new Promise(t=>{let n=function(){try{var e=JSON.parse(sessionStorage.getItem(s));if("object"==typeof e&&"number"==typeof e.timestamp&&(new Date).valueOf()<e.timestamp+604800&&"object"==typeof e.supportTests)return e.supportTests}catch(e){}return null}();if(!n){if("undefined"!=typeof Worker&&"undefined"!=typeof OffscreenCanvas&&"undefined"!=typeof URL&&URL.createObjectURL&&"undefined"!=typeof Blob)try{var e="postMessage("+f.toString()+"("+[JSON.stringify(o),u.toString(),c.toString(),p.toString()].join(",")+"));",r=new Blob([e],{type:"text/javascript"});const a=new Worker(URL.createObjectURL(r),{name:"wpTestEmojiSupports"});return void(a.onmessage=e=>{i(n=e.data),a.terminate(),t(n)})}catch(e){}i(n=f(o,u,c,p))}t(n)}).then(e=>{for(const n in e)r.supports[n]=e[n],r.supports.everything=r.supports.everything&&r.supports[n],"flag"!==n&&(r.supports.everythingExceptFlag=r.supports.everythingExceptFlag&&r.supports[n]);var t;r.supports.everythingExceptFlag=r.supports.everythingExceptFlag&&!r.supports.flag,r.supports.everything||((t=r.source||{}).concatemoji?a(t.concatemoji):t.wpemoji&&t.twemoji&&(a(t.twemoji),a(t.wpemoji)))}); 39//# sourceURL=https://sql.sh/wp-includes/js/wp-emoji-loader.min.js</script>
39 <div id="cookie-notice" role="dialog" class="cookie-notice-hidden cookie-revoke-hidden cn-position-bottom" aria-label="Compliance by Hu-manity.co" style="background-color: rgba(50,50,58,1);"><div class="cookie-notice-container" style="color: #fff"><span id="cn-notice-text" class="cn-text-container">Nous utilisons des cookies pour vous garantir la meilleure expérience sur notre site web. Si vous continuez à utiliser ce site, nous supposerons que vous en êtes satisfait.</span><span id="cn-notice-buttons" class="cn-buttons-container"><button id="cn-accept-cookie" data-cookie-set="accept" class="cn-set-cookie cn-button" aria-label="OK" style="background-color: #00a99d">OK</button></span><button type="button" id="cn-close-notice" data-cookie-set="accept" class="cn-close-icon" aria-label="Non"></button></div></div><div id="fb-root"></div>
39<script type="text/javascript">(function(d, s, id) { 40 var js, fjs = d.getElementsByTagName(s)[0]; 41 if (d.getElementById(id)) return; 42 js = d.createElement(s); js.id = id; 43 js.src = "//connect.facebook.net/en_GB/all.js#xfbml=1"; 44 fjs.parentNode.insertBefore(js, fjs); 45}(document, 'script', 'facebook-jssdk')); 46 47 48window.___gcfg = {lang: 'fr'}; 49(function() { 50 var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true; 51 po.src = 'https://apis.google.com/js/plusone.js'; 52 var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s); 53})(); 54 55 56var _gaq = _gaq || []; 57_gaq.push(['_setAccount', 'UA-1599467-30']); 58_gaq.push(['_trackPageview']); 59_gaq.push(['_trackPageLoadTime']); 60(function() { 61 var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; 62 ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; 63 var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); 64})();</script>
64 </body></html> 65<!-- Cached page for great performance - Debug: cached@1790597900 -->
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.