
{"id":11,"date":"2008-10-27T20:16:48","date_gmt":"2008-10-27T18:16:48","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=11"},"modified":"2008-11-28T10:54:09","modified_gmt":"2008-11-28T09:54:09","slug":"mysql-50-un-sgbdr-mature-part-14","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2008\/10\/27\/mysql-50-un-sgbdr-mature-part-14\/","title":{"rendered":"MySQL 5.0 : Un SGBDR mature ? &#8212; (part 1\/4)"},"content":{"rendered":"<p><!-- \t\t@page { margin: 2cm } \t\tP { margin-bottom: 0.21cm } --><\/p>\n<p style=\"margin-bottom: 0cm;\">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&rsquo;entreprise. 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 style=\"margin-bottom: 0cm;\">\n<p style=\"margin-bottom: 0cm;\">Avec toutes ces nouveaut\u00e9s la philosophie de MySQL reste la m\u00eame : \u00ab\u00a0simplicit\u00e9 et hautes performances\u00a0\u00bb.<\/p>\n<p style=\"margin-bottom: 0cm;\">\n<p style=\"margin-bottom: 0cm;\"><!-- \t\t@page { margin: 2cm } \t\tP { margin-bottom: 0.21cm } \t\tH2 { margin-bottom: 0.21cm } \t\tH2.western { font-family: \"Arial\", sans-serif; font-size: 14pt; font-style: italic } \t\tH2.cjk { font-family: \"MS Mincho\"; font-size: 14pt; font-style: italic } \t\tH2.ctl { font-family: \"Tahoma\"; font-size: 14pt; font-style: italic } --><\/p>\n<h2 class=\"western\">Fonctionnalit\u00e9s<\/h2>\n<p style=\"margin-bottom: 0cm;\">D\u00e9j\u00e0, avant m\u00eame la version 5, MySQL supportait de nombreuses fonctionnalit\u00e9s avanc\u00e9es lui permettant de r\u00e9pondre \u00e0 un grand nombre de probl\u00e9matiques d&rsquo;entreprise : Les requ\u00eates imbriqu\u00e9es depuis MySQL 4.1, les transactions depuis MySQL 3.23 ainsi que les cl\u00e9s \u00e9trang\u00e8res et l&rsquo;int\u00e9grit\u00e9 r\u00e9f\u00e9rentielle.<\/p>\n<p><!-- \t \t --><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"4\" width=\"100%\" bordercolor=\"#000000\">\n<col width=\"73\"><\/col>\n<col width=\"57\"><\/col>\n<col width=\"59\"><\/col>\n<col width=\"68\"><\/col>\n<thead>\n<tr valign=\"top\">\n<th width=\"28%\"><\/th>\n<th width=\"22%\">MySQL 4.1<\/th>\n<th width=\"23%\">MySQL 5.0<\/th>\n<th width=\"26%\">MySQL 5.1<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr valign=\"top\">\n<td width=\"28%\">Cl\u00e9s \u00e9trang\u00e8res \/ Int\u00e9grit\u00e9 r\u00e9f\u00e9rentielle<\/td>\n<td width=\"22%\">\n<p align=\"center\">Avec le moteur innoDB<\/p>\n<\/td>\n<td width=\"23%\">\n<p align=\"center\">Avec le moteur innoDB<\/p>\n<\/td>\n<td width=\"26%\">\n<p align=\"center\">Avec le moteur innoDB<\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"28%\">R\u00e9plication<\/td>\n<td width=\"22%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<td width=\"23%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<td width=\"26%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"28%\">Requ\u00eates imbriqu\u00e9es<\/td>\n<td width=\"22%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<td width=\"23%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<td width=\"26%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"28%\">Vues<\/td>\n<td width=\"22%\">\n<p align=\"center\">\n<\/td>\n<td width=\"23%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<td width=\"26%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"28%\">Proc\u00e9dures stock\u00e9es<\/td>\n<td width=\"22%\">\n<p align=\"center\">\n<\/td>\n<td width=\"23%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<td width=\"26%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"28%\">D\u00e9clencheurs<\/td>\n<td width=\"22%\">\n<p align=\"center\">\n<\/td>\n<td width=\"23%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<td width=\"26%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<\/tr>\n<tr valign=\"top\">\n<td width=\"28%\">Partitionnement<\/td>\n<td width=\"22%\">\n<p align=\"center\">\n<\/td>\n<td width=\"23%\">\n<p align=\"center\">\n<\/td>\n<td width=\"26%\">\n<p align=\"center\">Oui<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"margin-bottom: 0cm;\">\n<address style=\"margin-bottom: 0cm;\">(<a title=\"MySQL 5.O, un SGBDR mature ? -- (part 2\/4)\" href=\"http:\/\/dasini.net\/blog\/2008\/10\/28\/mysql-50-un-sgbdr-mature-part-24\/\">suite -&gt;<\/a>)<br \/>\n<\/address>\n<p style=\"margin-bottom: 0cm;\">\n<p style=\"margin-bottom: 0cm;\">\n","protected":false},"excerpt":{"rendered":"<p>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&rsquo;entreprise. Au menu des nouveaut\u00e9s fonctionnelles :<\/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],"tags":[241,10,11],"class_list":["post-11","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-mysql5","tag-overview"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-b","jetpack-related-posts":[{"id":127,"url":"https:\/\/dasini.net\/blog\/2008\/11\/14\/presentation-mysql-50-un-sgbdr-mature\/","url_meta":{"origin":11,"position":0},"title":"Pr\u00e9sentation : MySQL 5.0, un SGBDR mature ?","author":"Olivier DASINI","date":"14 novembre 2008","format":false,"excerpt":"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\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":4479,"url":"https:\/\/dasini.net\/blog\/2021\/03\/28\/webinar-mysql-les-dernieres-nouveautes\/","url_meta":{"origin":11,"position":1},"title":"Webinar &#8211; MySQL les derni\u00e8res nouveaut\u00e9s","author":"Olivier DASINI","date":"28 mars 2021","format":false,"excerpt":"Rejoignez nous ce mardi 30 mars \u00e0 14h30 CET, pour ce webinar: MySQL, les derni\u00e8res nouveaut\u00e9s.","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":513,"url":"https:\/\/dasini.net\/blog\/2009\/03\/15\/conferences-mysql-au-salon-solutions-linux-2009\/","url_meta":{"origin":11,"position":2},"title":"Conf\u00e9rences MySQL au salon Solutions Linux 2009","author":"Olivier DASINI","date":"15 mars 2009","format":false,"excerpt":"Ce sont les 31 mars, 1er et 2 avril 2009 \u00e0 la Porte de Versailles, dans le Hall 2.2, que la 10\u00e8me \u00e9ditions de Solutions Linux \/ OpenSource aura lieu. Au menu, comme chaque ann\u00e9e, des exposants (comme Anaska Alter Way,...), les diff\u00e9rentes communaut\u00e9s open source (comme Le MySQL User\u2026","rel":"","context":"Dans &quot;Conf\u00e9rence&quot;","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3969,"url":"https:\/\/dasini.net\/blog\/2020\/11\/10\/resume-des-nouveautes-de-mysql-8-0-22\/","url_meta":{"origin":11,"position":3},"title":"R\u00e9sum\u00e9 des nouveaut\u00e9s de MySQL 8.0.22","author":"Olivier DASINI","date":"10 novembre 2020","format":false,"excerpt":"J'ai cr\u00e9\u00e9, sp\u00e9cialement pour toi, une pr\u00e9sentation qui r\u00e9sume les nouvelles fonctionnalit\u00e9s de la derni\u00e8re version de MySQL, sortie le 19 octobre 2020, la 8.0.22.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/CFFcaqhN-W8\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":334,"url":"https:\/\/dasini.net\/blog\/2008\/12\/13\/les-nouveautes-de-mysql-51-part-45\/","url_meta":{"origin":11,"position":4},"title":"Les nouveaut\u00e9s de MySQL 5.1 &#8212; (part 4\/5)","author":"Olivier DASINI","date":"13 d\u00e9cembre 2008","format":false,"excerpt":"Le moteur de stockage CSV n'est pas une vraie nouveaut\u00e9. Il est disponible depuis MySQL 4.1.4 (MySQL 5.1 pour M.S. Windows). Sa particularit\u00e9 est de stocker les donn\u00e9es dans un fichier texte au format CSV (Comma Separated Values) o\u00f9 les donn\u00e9es sont s\u00e9par\u00e9es par une virgule. Les avantages sont multiples,\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":1795,"url":"https:\/\/dasini.net\/blog\/2017\/07\/24\/ou-telecharger-mysql\/","url_meta":{"origin":11,"position":5},"title":"O\u00f9 t\u00e9l\u00e9charger MySQL ?","author":"Olivier DASINI","date":"24 juillet 2017","format":false,"excerpt":"Lorsque l'on d\u00e9marre un nouveau projet, il est en g\u00e9n\u00e9ral conseill\u00e9 de partir sur la version la plus r\u00e9cente de MySQL, histoire de profiter des toutes derni\u00e8res fonctionnalit\u00e9s mais aussi (surtout ?) d'\u00eatre certain d'\u00eatre \u00e0 jour au niveau des patchs de s\u00e9curit\u00e9. Cet article centralise les diff\u00e9rentes URLs pour\u2026","rel":"","context":"Dans &quot;Astuce&quot;","block_context":{"text":"Astuce","link":"https:\/\/dasini.net\/blog\/category\/astuce\/"},"img":{"alt_text":"Powered by MySQL","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/powered-by-mysql-125x64.png?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/11","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=11"}],"version-history":[{"count":6,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":233,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/11\/revisions\/233"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}