{"id":2891,"date":"2026-05-07T09:37:29","date_gmt":"2026-05-07T01:37:29","guid":{"rendered":"https:\/\/tekno.bali-island.com\/?p=2891"},"modified":"2026-05-07T09:37:31","modified_gmt":"2026-05-07T01:37:31","slug":"dml-en-sql-definition-types-et-commandes-de-base","status":"publish","type":"post","link":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/","title":{"rendered":"DML en SQL : D\u00e9finition, Types et Commandes de Base"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>D\u00e9finition et types de DML<\/strong><\/h2>\n\n\n\n<p><strong>Data Manipulation Language (DML)<\/strong>&nbsp;est une m\u00e9thode de requ\u00eate SQL qui peut \u00eatre utilis\u00e9e apr\u00e8s que la structure de la base de donn\u00e9es a \u00e9t\u00e9 cr\u00e9\u00e9e \u00e0 l&rsquo;aide de DDL (Data Definition Language). En termes simples, la DML est un ensemble de commandes de requ\u00eate qui servent \u00e0 manipuler les donn\u00e9es \u00e0 l&rsquo;int\u00e9rieur d&rsquo;une base de donn\u00e9es.<\/p>\n\n\n\n<p>Les commandes principales en DML comprennent&nbsp;<strong>INSERT<\/strong>&nbsp;pour ajouter des donn\u00e9es,&nbsp;<strong>UPDATE<\/strong>&nbsp;pour modifier ou remplacer des donn\u00e9es, et&nbsp;<strong>DELETE<\/strong>&nbsp;pour supprimer des donn\u00e9es.<\/p>\n\n\n\n<p>La DML elle-m\u00eame est divis\u00e9e en deux grands types :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>DML proc\u00e9durale :<\/strong>\u00a0Dans ce type, les commandes utilis\u00e9es pour manipuler les donn\u00e9es doivent \u00eatre accompagn\u00e9es d&rsquo;instructions claires sur\u00a0<em>comment<\/em>\u00a0les donn\u00e9es dans le fichier de base de donn\u00e9es sont accessibles. La DML proc\u00e9durale est g\u00e9n\u00e9ralement utilis\u00e9e dans les langages de programmation de haut niveau comme C et C++.<\/li>\n\n\n\n<li><strong>DML non proc\u00e9durale :<\/strong>\u00a0Contrairement \u00e0 la DML proc\u00e9durale, dans la DML non proc\u00e9durale, les donn\u00e9es peuvent \u00eatre manipul\u00e9es directement sans avoir \u00e0 inclure de commandes sur la mani\u00e8re d&rsquo;acc\u00e9der \u00e0 ces donn\u00e9es. La DML non proc\u00e9durale est g\u00e9n\u00e9ralement utilis\u00e9e dans les SGBD (Syst\u00e8mes de Gestion de Base de Donn\u00e9es) comme Paradox, FoxPro et SQL.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Utilit\u00e9 des commandes INSERT, UPDATE et DELETE en SQL<\/strong><\/h2>\n\n\n\n<p>Voici une explication plus d\u00e9taill\u00e9e des trois commandes de base de la DML, accompagn\u00e9e d&rsquo;exemples d&rsquo;utilisation :<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>1. Commande INSERT<\/strong><\/h3>\n\n\n\n<p><strong>INSERT<\/strong>&nbsp;est une commande utilis\u00e9e pour ajouter ou ins\u00e9rer de nouvelles lignes de donn\u00e9es dans une table d&rsquo;une base de donn\u00e9es.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Syntaxe :<\/strong><\/p>\n\n\n\n<p>sql<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">INSERT INTO nom_table (colonne_donnees) VALUES (valeur_donnees);<\/pre>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Exemple d&rsquo;utilisation :<\/strong><\/p>\n\n\n\n<p>sql<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">INSERT INTO Jurusan (KodeJur, NamaJur) VALUES ('12', 'Teknik Informatika');<\/pre>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Explication :<\/strong>&nbsp;La commande ci-dessus est utilis\u00e9e pour ajouter de nouvelles donn\u00e9es dans la table \u00ab Jurusan \u00bb. La colonne \u00ab KodeJur \u00bb sera remplie avec la valeur 12, tandis que la colonne \u00ab NamaJur \u00bb sera remplie avec Teknik Informatika.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>2. Commande UPDATE<\/strong><\/h3>\n\n\n\n<p><strong>UPDATE<\/strong>&nbsp;est une commande utilis\u00e9e pour modifier, mettre \u00e0 jour ou remplacer des donn\u00e9es d\u00e9j\u00e0 pr\u00e9sentes dans la base de donn\u00e9es.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Syntaxe :<\/strong><\/p>\n\n\n\n<p>sql<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">UPDATE nom_table SET nom_colonne = nouvelle_valeur_colonne WHERE condition;<\/pre>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Exemple d&rsquo;utilisation :<\/strong><\/p>\n\n\n\n<p>sql<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">UPDATE Mahasiswa SET Nama='Wilan' WHERE No='1123';<\/pre>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Explication :<\/strong>&nbsp;Cette commande signifie que nous modifions les donn\u00e9es dans la table \u00ab Mahasiswa \u00bb, plus pr\u00e9cis\u00e9ment en rempla\u00e7ant le contenu de la colonne \u00ab Nama \u00bb par Wilan, uniquement pour la ligne dont la valeur \u00ab No \u00bb est \u00e9gale \u00e0 1123.<br><strong>Remarque importante :<\/strong>&nbsp;Si la condition WHERE n&rsquo;est pas incluse, le syst\u00e8me modifiera&nbsp;<strong>toutes<\/strong>&nbsp;les donn\u00e9es de cette colonne pour toutes les lignes.<\/p>\n<\/blockquote>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>3. Commande DELETE<\/strong><\/h3>\n\n\n\n<p><strong>DELETE<\/strong>&nbsp;est une commande utilis\u00e9e pour supprimer des lignes de donn\u00e9es dans la base de donn\u00e9es.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Syntaxe :<\/strong><\/p>\n\n\n\n<p>sql<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM nom_table WHERE condition;<\/pre>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Exemple d&rsquo;utilisation :<\/strong><\/p>\n\n\n\n<p>sql<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM Mahasiswa WHERE No='1123';<\/pre>\n<\/blockquote>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p><strong>Explication :<\/strong>&nbsp;Cette commande est utile pour supprimer les donn\u00e9es de la table \u00ab Mahasiswa \u00bb qui poss\u00e8dent un enregistrement avec \u00ab No \u00bb (ou NIM) 1123.<br><strong>Remarque importante :<\/strong>&nbsp;La suppression de donn\u00e9es \u00e0 l&rsquo;aide de DELETE d\u00e9pend fortement de la condition WHERE utilis\u00e9e. Vous devriez toujours v\u00e9rifier que la commande DELETE est d\u00e9finie avec la bonne condition afin qu&rsquo;aucune donn\u00e9e importante ne soit accidentellement supprim\u00e9e.<\/p>\n<\/blockquote>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>D\u00e9finition et types de DML Data Manipulation Language (DML)&nbsp;est une m\u00e9thode de requ\u00eate SQL qui peut \u00eatre utilis\u00e9e apr\u00e8s que la structure de la base de donn\u00e9es a \u00e9t\u00e9 cr\u00e9\u00e9e \u00e0 l&rsquo;aide de DDL (Data Definition Language). En termes simples, la DML est un ensemble de commandes de requ\u00eate qui servent \u00e0 manipuler les donn\u00e9es \u00e0 l&rsquo;int\u00e9rieur d&rsquo;une base de donn\u00e9es. Les commandes principales en DML comprennent&nbsp;INSERT&nbsp;pour ajouter des donn\u00e9es,&nbsp;UPDATE&nbsp;pour modifier ou remplacer des donn\u00e9es, et&nbsp;DELETE&nbsp;pour supprimer des donn\u00e9es. La DML elle-m\u00eame est divis\u00e9e en deux grands types : Utilit\u00e9 des commandes INSERT, UPDATE et DELETE en SQL Voici une explication plus d\u00e9taill\u00e9e des trois commandes de base de la DML, accompagn\u00e9e d&rsquo;exemples d&rsquo;utilisation : 1. Commande INSERT INSERT&nbsp;est une commande utilis\u00e9e pour ajouter ou ins\u00e9rer de nouvelles lignes de donn\u00e9es dans une table d&rsquo;une base de donn\u00e9es. Syntaxe : sql INSERT INTO nom_table (colonne_donnees) VALUES (valeur_donnees); Exemple d&rsquo;utilisation : sql INSERT INTO Jurusan (KodeJur, NamaJur) VALUES (&rsquo;12&rsquo;, &lsquo;Teknik Informatika&rsquo;); Explication :&nbsp;La commande ci-dessus est utilis\u00e9e pour ajouter de nouvelles donn\u00e9es dans la table \u00ab Jurusan \u00bb. La colonne \u00ab KodeJur \u00bb sera remplie avec la valeur 12, tandis que la colonne \u00ab NamaJur \u00bb sera remplie avec Teknik Informatika. &hellip;<\/p>\n","protected":false},"author":1,"featured_media":2877,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[95],"tags":[],"class_list":["post-2891","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programmation"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DML en SQL : D\u00e9finition, Types et Commandes de Base<\/title>\n<meta name=\"description\" content=\"Comprendre le concept de DML en SQL. Apprenez les diff\u00e9rences entre DML proc\u00e9durale et non proc\u00e9durale ainsi que les fonctions des commandes INSERT, UPDATE et DELETE.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DML en SQL : D\u00e9finition, Types et Commandes de Base\" \/>\n<meta property=\"og:description\" content=\"Comprendre le concept de DML en SQL. Apprenez les diff\u00e9rences entre DML proc\u00e9durale et non proc\u00e9durale ainsi que les fonctions des commandes INSERT, UPDATE et DELETE.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/\" \/>\n<meta property=\"og:site_name\" content=\"Bali Island Tekno\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-05-07T01:37:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-07T01:37:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DML.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Wilan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Wilan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/\"},\"author\":{\"name\":\"Wilan\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\"},\"headline\":\"DML en SQL : D\u00e9finition, Types et Commandes de Base\",\"datePublished\":\"2026-05-07T01:37:29+00:00\",\"dateModified\":\"2026-05-07T01:37:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/\"},\"wordCount\":556,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DML.webp\",\"articleSection\":[\"Programmation\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/\",\"name\":\"DML en SQL : D\u00e9finition, Types et Commandes de Base\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DML.webp\",\"datePublished\":\"2026-05-07T01:37:29+00:00\",\"dateModified\":\"2026-05-07T01:37:31+00:00\",\"description\":\"Comprendre le concept de DML en SQL. Apprenez les diff\u00e9rences entre DML proc\u00e9durale et non proc\u00e9durale ainsi que les fonctions des commandes INSERT, UPDATE et DELETE.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#primaryimage\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DML.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/DML.webp\",\"width\":1920,\"height\":1080,\"caption\":\"DML\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/articles\\\/dml-en-sql-definition-types-et-commandes-de-base\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DML en SQL : D\u00e9finition, Types et Commandes de Base\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/\",\"name\":\"Bali Island Tekno\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#organization\",\"name\":\"Bali Island Tekno\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"width\":512,\"height\":512,\"caption\":\"Bali Island Tekno\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/Wilanpedia\\\/61575048527927\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/fr\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\",\"name\":\"Wilan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"caption\":\"Wilan\"},\"sameAs\":[\"https:\\\/\\\/tekno.bali-island.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DML en SQL : D\u00e9finition, Types et Commandes de Base","description":"Comprendre le concept de DML en SQL. Apprenez les diff\u00e9rences entre DML proc\u00e9durale et non proc\u00e9durale ainsi que les fonctions des commandes INSERT, UPDATE et DELETE.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/","og_locale":"fr_FR","og_type":"article","og_title":"DML en SQL : D\u00e9finition, Types et Commandes de Base","og_description":"Comprendre le concept de DML en SQL. Apprenez les diff\u00e9rences entre DML proc\u00e9durale et non proc\u00e9durale ainsi que les fonctions des commandes INSERT, UPDATE et DELETE.","og_url":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/","og_site_name":"Bali Island Tekno","article_publisher":"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/","article_published_time":"2026-05-07T01:37:29+00:00","article_modified_time":"2026-05-07T01:37:31+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DML.webp","type":"image\/webp"}],"author":"Wilan","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Wilan","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#article","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/"},"author":{"name":"Wilan","@id":"https:\/\/tekno.bali-island.com\/fr\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42"},"headline":"DML en SQL : D\u00e9finition, Types et Commandes de Base","datePublished":"2026-05-07T01:37:29+00:00","dateModified":"2026-05-07T01:37:31+00:00","mainEntityOfPage":{"@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/"},"wordCount":556,"commentCount":0,"publisher":{"@id":"https:\/\/tekno.bali-island.com\/fr\/#organization"},"image":{"@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DML.webp","articleSection":["Programmation"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/","url":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/","name":"DML en SQL : D\u00e9finition, Types et Commandes de Base","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#primaryimage"},"image":{"@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DML.webp","datePublished":"2026-05-07T01:37:29+00:00","dateModified":"2026-05-07T01:37:31+00:00","description":"Comprendre le concept de DML en SQL. Apprenez les diff\u00e9rences entre DML proc\u00e9durale et non proc\u00e9durale ainsi que les fonctions des commandes INSERT, UPDATE et DELETE.","breadcrumb":{"@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#primaryimage","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DML.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/05\/DML.webp","width":1920,"height":1080,"caption":"DML"},{"@type":"BreadcrumbList","@id":"https:\/\/tekno.bali-island.com\/fr\/articles\/dml-en-sql-definition-types-et-commandes-de-base\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tekno.bali-island.com\/fr\/"},{"@type":"ListItem","position":2,"name":"DML en SQL : D\u00e9finition, Types et Commandes de Base"}]},{"@type":"WebSite","@id":"https:\/\/tekno.bali-island.com\/fr\/#website","url":"https:\/\/tekno.bali-island.com\/fr\/","name":"Bali Island Tekno","description":"","publisher":{"@id":"https:\/\/tekno.bali-island.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tekno.bali-island.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/tekno.bali-island.com\/fr\/#organization","name":"Bali Island Tekno","url":"https:\/\/tekno.bali-island.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/tekno.bali-island.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","width":512,"height":512,"caption":"Bali Island Tekno"},"image":{"@id":"https:\/\/tekno.bali-island.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/"]},{"@type":"Person","@id":"https:\/\/tekno.bali-island.com\/fr\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42","name":"Wilan","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","caption":"Wilan"},"sameAs":["https:\/\/tekno.bali-island.com"]}]}},"_links":{"self":[{"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/posts\/2891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/comments?post=2891"}],"version-history":[{"count":1,"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/posts\/2891\/revisions"}],"predecessor-version":[{"id":2892,"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/posts\/2891\/revisions\/2892"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/media\/2877"}],"wp:attachment":[{"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/media?parent=2891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/categories?post=2891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/fr\/wp-json\/wp\/v2\/tags?post=2891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}