{"id":127,"date":"2008-11-14T10:35:36","date_gmt":"2008-11-14T09:35:36","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=127"},"modified":"2008-11-17T12:16:11","modified_gmt":"2008-11-17T11:16:11","slug":"presentation-mysql-50-un-sgbdr-mature","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2008\/11\/14\/presentation-mysql-50-un-sgbdr-mature\/","title":{"rendered":"Pr\u00e9sentation : MySQL 5.0, un SGBDR mature ?"},"content":{"rendered":"<p>MySQL est le<span style=\"text-decoration: underline;\"> SGBDR Open Source le plus populaire au monde<\/span>. Sa cinqui\u00e8me version, sortie en  octobre <strong>2005<\/strong>, permet de mieux r\u00e9pondre aux probl\u00e9matiques d\u2019entreprise. Au menu des nouveaut\u00e9s fonctionnelles : les vues, les proc\u00e9dures stock\u00e9es, les d\u00e9clencheurs, de nouveaux moteurs de stockage, la base de donn\u00e9es INFORMATION_SCHEMA et diverses petites am\u00e9liorations.<\/p>\n<p><strong><a title=\"MySQL 5.O, un SGBDR mature ?\" href=\"http:\/\/dasini.net\/blog\/presentations\/?#presentation_mysql\" target=\"_self\">http:\/\/dasini.net\/blog\/presentations\/?#presentation_mysql<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL est le SGBDR Open Source le plus populaire au monde. Sa cinqui\u00e8me version, sortie en octobre 2005, permet de mieux r\u00e9pondre aux probl\u00e9matiques d\u2019entreprise. Au menu des nouveaut\u00e9s fonctionnelles : les vues, les proc\u00e9dures stock\u00e9es, les d\u00e9clencheurs, de nouveaux moteurs de stockage, la base de donn\u00e9es INFORMATION_SCHEMA et diverses petites am\u00e9liorations.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[8,39],"tags":[20,42,21,40,11,41,13],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-mysql","category-presentation","tag-declencheur","tag-federated","tag-information_schema","tag-mysql-5o","tag-overview","tag-procedure-stockee","tag-vues"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-23","jetpack-related-posts":[{"id":11,"url":"https:\/\/dasini.net\/blog\/2008\/10\/27\/mysql-50-un-sgbdr-mature-part-14\/","url_meta":{"origin":127,"position":0},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 1\/4)","author":"Olivier DASINI","date":"27 octobre 2008","format":false,"excerpt":"MySQL est le SGBD Open Source le plus populaire au monde. Sa cinqui\u00e8me version, sortie en octobre 2005, permet de mieux r\u00e9pondre aux probl\u00e9matiques d'entreprise. Au menu des nouveaut\u00e9s fonctionnelles :","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":41,"url":"https:\/\/dasini.net\/blog\/2008\/10\/30\/mysql-50-un-sgbdr-mature-part-44\/","url_meta":{"origin":127,"position":1},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 4\/4)","author":"Olivier DASINI","date":"30 octobre 2008","format":false,"excerpt":"Les d\u00e9clencheurs (triggers) sont des ordres de d\u00e9clenchement d'op\u00e9rations quand un \u00e9v\u00e8nement survient sur une table.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26,"url":"https:\/\/dasini.net\/blog\/2008\/10\/29\/mysql-50-un-sgbdr-mature-part-34\/","url_meta":{"origin":127,"position":2},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 3\/4)","author":"Olivier DASINI","date":"29 octobre 2008","format":false,"excerpt":"Les proc\u00e9dures stock\u00e9es sont des listes de commandes qui peuvent \u00eatre compil\u00e9es et stock\u00e9es sur le serveur. Elles permettent de d\u00e9placer une partie de la logique m\u00e9tier d'une application de base de donn\u00e9es du client vers le serveur. Les clients n\u2019ont plus besoin de soumettre \u00e0 nouveau toute la commande,\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":133,"url":"https:\/\/dasini.net\/blog\/2008\/11\/15\/une-quinzaine-de-raisons-pour-choisir-ou-ne-pas-choisir-un-sgbdr\/","url_meta":{"origin":127,"position":3},"title":"Une quinzaine de raisons pour choisir ou ne pas choisir un SGBDR","author":"Olivier DASINI","date":"15 novembre 2008","format":false,"excerpt":"Faire le choix d'un SGBDR pour g\u00e9rer ses donn\u00e9es est devenu un r\u00e9flexe, mais est ce toujours n\u00e9cessaire ?","rel":"","context":"Dans &quot;Divers&quot;","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14,"url":"https:\/\/dasini.net\/blog\/2008\/10\/28\/mysql-50-un-sgbdr-mature-part-24\/","url_meta":{"origin":127,"position":4},"title":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 2\/4)","author":"Olivier DASINI","date":"28 octobre 2008","format":false,"excerpt":"Les vues sont la plupart du temps utiles pour donner aux utilisateurs l\u2019acc\u00e8s \u00e0 un ensemble de relations repr\u00e9sent\u00e9es sous la forme d'une table. Une vue est une table virtuelle ; les donn\u00e9es de la vue sont en fait des champs de diff\u00e9rentes tables regroup\u00e9es, ou des r\u00e9sultats d\u2019op\u00e9rations sur\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":192,"url":"https:\/\/dasini.net\/blog\/2008\/11\/23\/mysql-5-les-vues-part-17\/","url_meta":{"origin":127,"position":5},"title":"MySQL 5 : Les vues &#8212; (part 1\/7)","author":"Olivier DASINI","date":"23 novembre 2008","format":false,"excerpt":"Le langage SQL acronyme de Structured Query Language (Langage Structur\u00e9 de Requ\u00eates), a \u00e9t\u00e9 con\u00e7u pour g\u00e9rer les donn\u00e9es dans un SGBDR. A l'aide des DML (Data Manipulation Language ie les requ\u00eates SELECT, INSERT, UPDATE, DELETE) il est possible de manipuler ces donn\u00e9es qui sont stock\u00e9es dans des tables. SQL\u2026","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/127","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=127"}],"version-history":[{"count":9,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/127\/revisions"}],"predecessor-version":[{"id":159,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/127\/revisions\/159"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}