PageSourceSearch

https://sql.sh/cours

html sql.sh collected 2026-10-03 22:50:39 UTC 67,772 bytes, 65 lines download raw bytes

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 &#8230;). Les cours sont simplifiés pour se remémorer la syntaxe des commandes importantes et des tutoriels sont disponibles pour permettre d&rsquo;apprendre [&hellip;]" /><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 &raquo; Flux" href="https://sql.sh/feed" /><link rel="alternate" type="application/rss+xml" title="SQL &raquo; Flux des commentaires" href="https://sql.sh/comments/feed" /><link rel="alternate" type="application/rss+xml" title="SQL &raquo; 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&#038;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 &#8230;). Les cours sont simplifiés pour se remémorer la syntaxe des commandes importantes et des tutoriels sont disponibles pour permettre d&rsquo;apprendre à partir de zéro. De plus, des explications sont données pour apprendre à optimiser les performances d&rsquo;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&rsquo;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 &#038; 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&rsquo;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&rsquo;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&rsquo;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&amp;layout=box_count&amp;show_faces=true&amp;
27width=65&amp;action=like&amp;font=arial&amp;colorscheme=light&amp;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 &#038; 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&rsquo;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&rsquo;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.