{"id":114,"date":"2021-03-12T10:32:25","date_gmt":"2021-03-12T10:32:25","guid":{"rendered":"https:\/\/kaay-coder.2sweb.sn\/kc\/?page_id=114"},"modified":"2022-04-03T01:20:24","modified_gmt":"2022-04-03T01:20:24","slug":"sql","status":"publish","type":"page","link":"https:\/\/kaay-coder.2sweb.sn\/kc\/langages\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"114\" class=\"elementor elementor-114\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-71eb195 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"71eb195\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1516819\" data-id=\"1516819\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4d161e5 elementor-widget elementor-widget-image\" data-id=\"4d161e5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"600\" height=\"342\" src=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/t.png\" class=\"attachment-large size-large wp-image-368\" alt=\"\" srcset=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/t.png 600w, https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/t-300x171.png 300w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ff1aa0d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ff1aa0d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-7ee60c1\" data-id=\"7ee60c1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ac0cb5e elementor-widget elementor-widget-accordion\" data-id=\"ac0cb5e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"accordion.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion\">\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1801\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"button\" aria-controls=\"elementor-tab-content-1801\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Qu'est ce  que SQL ?<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1801\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"region\" aria-labelledby=\"elementor-tab-title-1801\"><p>SQL est un langage informatique normalis\u00e9 servant \u00e0 exploiter des bases de donn\u00e9es relationnelles. La partie langage de manipulation des donn\u00e9es de SQL permet de rechercher, d&#8217;ajouter, de modifier ou de supprimer des donn\u00e9es dans les bases de donn\u00e9es relationnelles. Outre le langage de manipulation des donn\u00e9es .<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1802\" class=\"elementor-tab-title\" data-tab=\"2\" role=\"button\" aria-controls=\"elementor-tab-content-1802\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Syntaxe SQL<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1802\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"region\" aria-labelledby=\"elementor-tab-title-1802\"><p><span>Une base de donn\u00e9es contient le plus souvent une ou plusieurs tables. Chaque table est identifi\u00e9e par un nom (par exemple \u00abClients\u00bb ou \u00abCommandes\u00bb). Les tables contiennent des enregistrements (lignes) avec des donn\u00e9es.\u00a0 <\/span><span><span class=\"goog-text-highlight\">Dans ce didacticiel, nous utiliserons la c\u00e9l\u00e8bre base de donn\u00e9es exemple Northwind (incluse dans MS Access et MS SQL Server).<\/span><\/span><\/p><p>\u00a0<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1803\" class=\"elementor-tab-title\" data-tab=\"3\" role=\"button\" aria-controls=\"elementor-tab-content-1803\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Les commandes SQL les plus importantes<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1803\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"region\" aria-labelledby=\"elementor-tab-title-1803\"><ul><li><code class=\"w3-codespan\">SELECT<\/code><span>\u00a0&#8211; extrait les donn\u00e9es d&#8217;une base de donn\u00e9es<\/span><\/li><li><code class=\"w3-codespan\">UPDATE<\/code><span>\u00a0&#8211; met \u00e0 jour les donn\u00e9es dans une base de donn\u00e9es<\/span><\/li><li><code class=\"w3-codespan\">DELETE<\/code><span>\u00a0&#8211; supprime les donn\u00e9es d&#8217;une base de donn\u00e9es<\/span><\/li><li><code class=\"w3-codespan\">INSERT INTO<\/code><span>\u00a0&#8211; ins\u00e8re de nouvelles donn\u00e9es dans une base de donn\u00e9es<\/span><\/li><li><code class=\"w3-codespan\">CREATE DATABASE<\/code><span>\u00a0&#8211; cr\u00e9e une nouvelle base de donn\u00e9es<\/span><\/li><li><code class=\"w3-codespan\">ALTER DATABASE<\/code><span>\u00a0&#8211; modifie une base de donn\u00e9es<\/span><\/li><li><code class=\"w3-codespan\">CREATE TABLE<\/code><span>\u00a0&#8211; cr\u00e9e une nouvelle table<\/span><\/li><li><code class=\"w3-codespan\">ALTER TABLE<\/code><span>\u00a0&#8211; modifie une table<\/span><\/li><li><code class=\"w3-codespan\">DROP TABLE<\/code><span>\u00a0&#8211; supprime une table<\/span><\/li><li><code class=\"w3-codespan\">CREATE INDEX<\/code><span>\u00a0&#8211; cr\u00e9e un index (cl\u00e9 de recherche)<\/span><\/li><li><code class=\"w3-codespan\">DROP INDEX<\/code><span>\u00a0&#8211; supprime un index<\/span><\/li><\/ul><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1804\" class=\"elementor-tab-title\" data-tab=\"4\" role=\"button\" aria-controls=\"elementor-tab-content-1804\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">L' instruction SQL SELECT<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1804\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"4\" role=\"region\" aria-labelledby=\"elementor-tab-title-1804\"><p><span><span class=\"\">L&#8217;<\/span><\/span><span><span class=\"\">instruction SELECT est utilis\u00e9e pour s\u00e9lectionner des donn\u00e9es dans une base de donn\u00e9es. <\/span><\/span><span>Les donn\u00e9es renvoy\u00e9es sont stock\u00e9es dans une table de r\u00e9sultats, appel\u00e9e jeu de r\u00e9sultats.<\/span><\/p><h5><span><span class=\"\">SELECT Syntaxe<\/span><\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<em>column1<\/em>,<em>\u00a0column2, ...<\/em><br \/><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name<\/em>;<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1805\" class=\"elementor-tab-title\" data-tab=\"5\" role=\"button\" aria-controls=\"elementor-tab-content-1805\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Instruction SQL SELECT DISTINCT<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1805\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"5\" role=\"region\" aria-labelledby=\"elementor-tab-title-1805\"><p><span>L&#8217; <\/span><span>instruction SELECT DISTINCT est utilis\u00e9e pour renvoyer uniquement des valeurs distinctes (diff\u00e9rentes). <\/span><span>\u00c0 l&#8217;int\u00e9rieur d&#8217;une table, une colonne contient souvent de nombreuses valeurs en double;\u00a0et parfois vous ne voulez lister que les diff\u00e9rentes valeurs (distinctes).<\/span><\/p><h5><span>Syntaxe SELECT DISTINCT<\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">SELECT<\/span>\u00a0<span class=\"sqlkeywordcolor\">DISTINCT<\/span>\u00a0<em>column1<\/em>,<em>\u00a0column2, ...<\/em><br \/><span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name<\/em>;<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1806\" class=\"elementor-tab-title\" data-tab=\"6\" role=\"button\" aria-controls=\"elementor-tab-content-1806\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Instruction SQL INSERT INTO<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1806\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"6\" role=\"region\" aria-labelledby=\"elementor-tab-title-1806\"><p><span>L&#8217;\u00a0<\/span><span>instruction INSERT INTO est utilis\u00e9e pour ins\u00e9rer de nouveaux enregistrements dans une table. <\/span><\/p><p><span>INSERT INTO Syntaxe <\/span><\/p><p><span>Il est possible d&#8217;\u00e9crire la\u00a0<\/span><code class=\"w3-codespan\">INSERT INTO<\/code><span>\u00a0d\u00e9claration de deux mani\u00e8res:<\/span><\/p><p><span>. Sp\u00e9cifiez \u00e0 la fois les noms de colonnes et les valeurs \u00e0 ins\u00e9rer:<\/span><\/p><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">INSERT<\/span>\u00a0<span class=\"sqlkeywordcolor\">INTO<\/span>\u00a0<em>table_name<\/em>\u00a0(<em>column1<\/em>,<em>\u00a0column2<\/em>,<em>\u00a0column3<\/em>, ...)<br \/><span class=\"sqlkeywordcolor\">VALUES<\/span>\u00a0(<em>value1<\/em>,<em>\u00a0value2<\/em>,<em>\u00a0value3<\/em>, ...);<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1807\" class=\"elementor-tab-title\" data-tab=\"7\" role=\"button\" aria-controls=\"elementor-tab-content-1807\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">L'instruction SQL UPDATE<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1807\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"7\" role=\"region\" aria-labelledby=\"elementor-tab-title-1807\"><p><span>L&#8217;\u00a0<\/span><span>instruction UPDATE est utilis\u00e9e pour modifier les enregistrements existants dans une table.<\/span><\/p><h5><span>Syntaxe UPDATE<\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">UPDATE<\/span>\u00a0<em>table_name<\/em><br \/><span class=\"sqlkeywordcolor\">SET<\/span>\u00a0<em>column1\u00a0<\/em>=<em>\u00a0value1<\/em>,<em>\u00a0column2\u00a0<\/em>=<em>\u00a0value2<\/em>, ...<br \/><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1808\" class=\"elementor-tab-title\" data-tab=\"8\" role=\"button\" aria-controls=\"elementor-tab-content-1808\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">L'instruction SQL DELETE<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1808\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"8\" role=\"region\" aria-labelledby=\"elementor-tab-title-1808\"><p><span>L&#8217;\u00a0<\/span><span>instruction DELETE est utilis\u00e9e pour supprimer les enregistrements existants dans une table.<\/span><\/p><h5><span>DELETE Syntaxe<\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">DELETE<\/span>\u00a0<span class=\"sqlkeywordcolor\">FROM<\/span>\u00a0<em>table_name\u00a0<\/em><span class=\"sqlkeywordcolor\">WHERE<\/span>\u00a0<em>condition<\/em>;<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-1809\" class=\"elementor-tab-title\" data-tab=\"9\" role=\"button\" aria-controls=\"elementor-tab-content-1809\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Instruction SQL CREATE DATABASE<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-1809\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"9\" role=\"region\" aria-labelledby=\"elementor-tab-title-1809\"><p><span>L4<\/span><span>instruction CRETE DATABASE est utilis\u00e9e pour cr\u00e9er une nouvelle base de donn\u00e9es SQL.<\/span><\/p><h5><span>Syntaxe<\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">CREATE<\/span>\u00a0<span class=\"sqlkeywordcolor\">DATABASE<\/span>\u00a0<em>databasename<\/em>;<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-18010\" class=\"elementor-tab-title\" data-tab=\"10\" role=\"button\" aria-controls=\"elementor-tab-content-18010\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Instruction SQL DROP DATABASE<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-18010\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"10\" role=\"region\" aria-labelledby=\"elementor-tab-title-18010\"><p><span>L&#8217; <\/span><span>instruction <code class=\"w3-codespan\">DROP DATABASE<\/code> est utilis\u00e9e pour supprimer une base de donn\u00e9es SQL existante.<\/span><\/p><h5><span>Syntaxe<\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">DROP<\/span>\u00a0<span class=\"sqlkeywordcolor\">DATABASE<\/span>\u00a0<em>databasename<\/em>;<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-18011\" class=\"elementor-tab-title\" data-tab=\"11\" role=\"button\" aria-controls=\"elementor-tab-content-18011\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Instruction SQL CREATE TABLE<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-18011\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"11\" role=\"region\" aria-labelledby=\"elementor-tab-title-18011\"><p><span>L&#8217;<\/span><span>instruction <code class=\"w3-codespan\">CREATE TABLE<\/code> est utilis\u00e9e pour cr\u00e9er une nouvelle table dans une base de donn\u00e9es.<\/span><\/p><h5><span>Syntaxe<\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">CREATE<\/span>\u00a0<span class=\"sqlkeywordcolor\">TABLE<\/span>\u00a0<em>table_name\u00a0<\/em>(<br \/><em>\u00a0\u00a0\u00a0 column1 datatype<\/em>,<br \/><em>\u00a0\u00a0\u00a0 column2 datatype<\/em>,<br \/><em>\u00a0\u00a0\u00a0 column3 datatype<\/em>,<br \/>\u00a0\u00a0 ....<br \/>);<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-18012\" class=\"elementor-tab-title\" data-tab=\"12\" role=\"button\" aria-controls=\"elementor-tab-content-18012\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Instruction SQL DROP TABLE<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-18012\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"12\" role=\"region\" aria-labelledby=\"elementor-tab-title-18012\"><p><span>L&#8217;\u00a0<\/span><code class=\"w3-codespan\">DROP TABLE<\/code><span>instruction est utilis\u00e9e pour supprimer une table existante dans une base de donn\u00e9es.<\/span><\/p><h5><span>Syntaxe<\/span><\/h5><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">DROP<\/span>\u00a0<span class=\"sqlkeywordcolor\">TABLE<\/span>\u00a0<em>table_name<\/em>;<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-18013\" class=\"elementor-tab-title\" data-tab=\"13\" role=\"button\" aria-controls=\"elementor-tab-content-18013\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Contrainte SQL PRIMARY KEY (cl\u00e9 primaire)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-18013\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"13\" role=\"region\" aria-labelledby=\"elementor-tab-title-18013\"><p><span>La\u00a0<\/span><code class=\"w3-codespan\">PRIMARY KEY<\/code><span>contrainte identifie de mani\u00e8re unique chaque enregistrement dans une table. <\/span><span>Les cl\u00e9s primaires doivent contenir des valeurs UNIQUE et ne peuvent pas contenir de valeurs NULL. <\/span><span>Une table ne peut avoir qu&#8217;une seule cl\u00e9 primaire;\u00a0et dans la table, cette cl\u00e9 primaire peut \u00eatre constitu\u00e9e d&#8217;une ou de plusieurs colonnes (champs).<\/span><\/p><p><span><span class=\"\">Le SQL suivant cr\u00e9e un\u00a0<\/span><\/span><code class=\"w3-codespan\">PRIMARY KEY<\/code><span><span class=\"\">sur la colonne &#8220;ID&#8221; lors de la cr\u00e9ation de la table &#8220;Personnes&#8221;:<\/span><\/span><\/p><p><b><span>MySQL:<\/span><\/b><\/p><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">CREATE<\/span>\u00a0<span class=\"sqlkeywordcolor\">TABLE<\/span>\u00a0Persons (<br \/>\u00a0\u00a0\u00a0 ID int\u00a0<span class=\"sqlkeywordcolor\">NOT<\/span>\u00a0<span class=\"sqlkeywordcolor\">NULL<\/span>,<br \/>\u00a0\u00a0\u00a0 LastName varchar(<span class=\"sqlnumbercolor\">255<\/span>)\u00a0<span class=\"sqlkeywordcolor\">NOT<\/span>\u00a0<span class=\"sqlkeywordcolor\">NULL<\/span>,<br \/>\u00a0\u00a0\u00a0 FirstName varchar(<span class=\"sqlnumbercolor\">255<\/span>),<br \/>\u00a0\u00a0\u00a0 Age int,<br \/>\u00a0\u00a0\u00a0\u00a0<span class=\"sqlkeywordcolor\">PRIMARY<\/span>\u00a0<span class=\"sqlkeywordcolor\">KEY<\/span>\u00a0(ID)<br \/>);<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-accordion-item\">\n\t\t\t\t\t<h4 id=\"elementor-tab-title-18014\" class=\"elementor-tab-title\" data-tab=\"14\" role=\"button\" aria-controls=\"elementor-tab-content-18014\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon elementor-accordion-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-closed\"><i class=\"fas fa-plus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-accordion-icon-opened\"><i class=\"fas fa-minus\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a class=\"elementor-accordion-title\" tabindex=\"0\">Contrainte SQL FOREIGN KEY (cl\u00e9 \u00e9trang\u00e8re)<\/a>\n\t\t\t\t\t<\/h4>\n\t\t\t\t\t<div id=\"elementor-tab-content-18014\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"14\" role=\"region\" aria-labelledby=\"elementor-tab-title-18014\"><p><span>La\u00a0<\/span><code class=\"w3-codespan\">FOREIGN KEY <\/code><span>contrainte est utilis\u00e9e pour emp\u00eacher les actions qui d\u00e9truiraient les liens entre les tables.<\/span><\/p><p><span>A\u00a0<\/span><code class=\"w3-codespan\">FOREIGN KEY<\/code><span>est un champ (ou une collection de champs) dans une table, qui fait r\u00e9f\u00e9rence \u00e0\u00a0<\/span><code class=\"w3-codespan\">PRIMARY KEY<\/code><span>dans une autre table.<\/span><\/p><p><span>Le SQL suivant cr\u00e9e un\u00a0<\/span><code class=\"w3-codespan\">FOREIGN KEY<\/code><span>sur la colonne &#8220;PersonID&#8221; lorsque la table &#8220;Orders&#8221; est cr\u00e9\u00e9e:<\/span><\/p><p><b><span>MySQL:<\/span><\/b><\/p><div class=\"w3-example\"><pre class=\"w3-code notranslate sqlHigh\"><span class=\"sqlcolor\"><span class=\"sqlkeywordcolor\">CREATE<\/span>\u00a0<span class=\"sqlkeywordcolor\">TABLE<\/span>\u00a0Orders (<br \/>\u00a0\u00a0\u00a0 OrderID int\u00a0<span class=\"sqlkeywordcolor\">NOT<\/span>\u00a0<span class=\"sqlkeywordcolor\">NULL<\/span>,<br \/>\u00a0\u00a0\u00a0 OrderNumber int\u00a0<span class=\"sqlkeywordcolor\">NOT<\/span>\u00a0<span class=\"sqlkeywordcolor\">NULL<\/span>,<br \/>\u00a0\u00a0\u00a0 PersonID int,<br \/>\u00a0\u00a0\u00a0\u00a0<span class=\"sqlkeywordcolor\">PRIMARY<\/span>\u00a0<span class=\"sqlkeywordcolor\">KEY<\/span>\u00a0(OrderID),<br \/>\u00a0\u00a0\u00a0\u00a0<span class=\"sqlkeywordcolor\">FOREIGN<\/span>\u00a0<span class=\"sqlkeywordcolor\">KEY<\/span>\u00a0(PersonID)\u00a0<span class=\"sqlkeywordcolor\">REFERENCES<\/span>\u00a0Persons(PersonID)<br \/>);<\/span><\/pre><\/div><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-20356f4\" data-id=\"20356f4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7778670 elementor-widget elementor-widget-sidebar\" data-id=\"7778670\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"sidebar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"search-2\" class=\"widget widget_search\">\n<form role=\"search\" method=\"get\" class=\"searchform\" action=\"https:\/\/kaay-coder.2sweb.sn\/kc\/\">\n\n\t<label>\n\n\t\t<span class=\"screen-reader-text\">Recherche pour\u00a0:<\/span>\n\t\t<input type=\"search\" id=\"searchform-1\" name=\"s\" value=\"\" placeholder=\"Rechercher &hellip;\" title=\"Appuyez sur Entrer pour rechercher\" \/>\n\n\t\t\n\t\t\t<button value=\"Search\" class=\"wpbff wpbff-search\"><\/button>\n\n\t\t\n\t<\/label>\n\n<\/form>\n<\/div><div id=\"calendar-2\" class=\"widget widget_calendar\"><div id=\"calendar_wrap\" class=\"calendar_wrap\"><table id=\"wp-calendar\" class=\"wp-calendar-table\">\n\t<caption>ao\u00fbt 2026<\/caption>\n\t<thead>\n\t<tr>\n\t\t<th scope=\"col\" aria-label=\"lundi\">L<\/th>\n\t\t<th scope=\"col\" aria-label=\"mardi\">M<\/th>\n\t\t<th scope=\"col\" aria-label=\"mercredi\">M<\/th>\n\t\t<th scope=\"col\" aria-label=\"jeudi\">J<\/th>\n\t\t<th scope=\"col\" aria-label=\"vendredi\">V<\/th>\n\t\t<th scope=\"col\" aria-label=\"samedi\">S<\/th>\n\t\t<th scope=\"col\" aria-label=\"dimanche\">D<\/th>\n\t<\/tr>\n\t<\/thead>\n\t<tbody>\n\t<tr>\n\t\t<td colspan=\"5\" class=\"pad\">&nbsp;<\/td><td>1<\/td><td>2<\/td>\n\t<\/tr>\n\t<tr>\n\t\t<td id=\"today\">3<\/td><td>4<\/td><td>5<\/td><td>6<\/td><td>7<\/td><td>8<\/td><td>9<\/td>\n\t<\/tr>\n\t<tr>\n\t\t<td>10<\/td><td>11<\/td><td>12<\/td><td>13<\/td><td>14<\/td><td>15<\/td><td>16<\/td>\n\t<\/tr>\n\t<tr>\n\t\t<td>17<\/td><td>18<\/td><td>19<\/td><td>20<\/td><td>21<\/td><td>22<\/td><td>23<\/td>\n\t<\/tr>\n\t<tr>\n\t\t<td>24<\/td><td>25<\/td><td>26<\/td><td>27<\/td><td>28<\/td><td>29<\/td><td>30<\/td>\n\t<\/tr>\n\t<tr>\n\t\t<td>31<\/td>\n\t\t<td class=\"pad\" colspan=\"6\">&nbsp;<\/td>\n\t<\/tr>\n\t<\/tbody>\n\t<\/table><nav aria-label=\"Mois pr\u00e9c\u00e9dents et suivants\" class=\"wp-calendar-nav\">\n\t\t<span class=\"wp-calendar-nav-prev\"><a href=\"https:\/\/kaay-coder.2sweb.sn\/kc\/2021\/03\/\">&laquo; Mar<\/a><\/span>\n\t\t<span class=\"pad\">&nbsp;<\/span>\n\t\t<span class=\"wp-calendar-nav-next\">&nbsp;<\/span>\n\t<\/nav><\/div><\/div>\n\t\t<div id=\"recent-posts-2\" class=\"widget widget_recent_entries\">\n\t\t<h4 class=\"wpbf-widgettitle\">Articles r\u00e9cents<\/h4>\n\t\t<ul>\n\t\t\t\t\t\t\t\t\t\t\t<li>\n\t\t\t\t\t<a href=\"https:\/\/kaay-coder.2sweb.sn\/kc\/hello-world\/\">Kaay-Coder !<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t<\/ul>\n\n\t\t<\/div><div id=\"archives-2\" class=\"widget widget_archive\"><h4 class=\"wpbf-widgettitle\">Archives<\/h4>\n\t\t\t<ul>\n\t\t\t\t\t<li><a href='https:\/\/kaay-coder.2sweb.sn\/kc\/2021\/03\/'>mars 2021<\/a><\/li>\n\t\t\t<\/ul>\n\n\t\t\t<\/div><div id=\"media_gallery-2\" class=\"widget widget_media_gallery\"><div id='gallery-1' class='gallery galleryid-114 gallery-columns-2 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/kaay-coder.2sweb.sn\/kc\/accueil\/html\/'><img decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/html-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/html-150x150.png 150w, https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/html-300x300.png 300w, https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/html.png 421w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/kaay-coder.2sweb.sn\/kc\/dmxbe\/'><img decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/dMXbE-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/kaay-coder.2sweb.sn\/kc\/angular_hub642029a576c43637a3db16b5fc361ac_2385_700x450_fit_box_2\/'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/angular_hub642029a576c43637a3db16b5fc361ac_2385_700x450_fit_box_2-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/angular_hub642029a576c43637a3db16b5fc361ac_2385_700x450_fit_box_2-150x150.png 150w, https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/angular_hub642029a576c43637a3db16b5fc361ac_2385_700x450_fit_box_2.png 250w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/kaay-coder.2sweb.sn\/kc\/wordpress_logo_8-1-1024x1015\/'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/Wordpress_logo_8-1-1024x1015-1-150x150.png\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/Wordpress_logo_8-1-1024x1015-1-150x150.png 150w, https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/Wordpress_logo_8-1-1024x1015-1-300x297.png 300w, https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/Wordpress_logo_8-1-1024x1015-1-768x761.png 768w, https:\/\/kaay-coder.2sweb.sn\/kc\/wp-content\/uploads\/2021\/03\/Wordpress_logo_8-1-1024x1015-1.png 1024w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Qu&#8217;est ce que SQL ? SQL est un langage informatique normalis\u00e9 servant \u00e0 exploiter des bases de donn\u00e9es relationnelles. La partie langage de manipulation des donn\u00e9es de SQL permet de rechercher, d\u2019ajouter, de modifier ou de supprimer des donn\u00e9es dans les bases de donn\u00e9es relationnelles. Outre le langage de manipulation des donn\u00e9es . Syntaxe SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":88,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"class_list":["post-114","page","type-page","status-publish","hentry","wpbf-post"],"_links":{"self":[{"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/pages\/114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/comments?post=114"}],"version-history":[{"count":16,"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/pages\/114\/revisions"}],"predecessor-version":[{"id":887,"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/pages\/114\/revisions\/887"}],"up":[{"embeddable":true,"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/pages\/88"}],"wp:attachment":[{"href":"https:\/\/kaay-coder.2sweb.sn\/kc\/wp-json\/wp\/v2\/media?parent=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}