{"id":505,"date":"2009-03-09T02:05:21","date_gmt":"2009-03-09T01:05:21","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=505"},"modified":"2009-03-07T20:34:54","modified_gmt":"2009-03-07T19:34:54","slug":"toolkit-dev-nouvelle-rubrique-sur-dasininet","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2009\/03\/09\/toolkit-dev-nouvelle-rubrique-sur-dasininet\/","title":{"rendered":"Toolkit DEV: nouvelle rubrique sur dasini.net"},"content":{"rendered":"

Nouvelle rubrique sur dasini.net<\/a>: Toolkit DEV<\/strong><\/a><\/p>\n

Le but de cette rubrique est de synth\u00e9tiser les commandes les plus utiles aux d\u00e9veloppeurs MySQL. Vous retrouverai donc une liste, non exhaustive<\/span>, de commandes sql particuli\u00e8rement utilis\u00e9es lors du d\u00e9veloppement d’une application, ainsi qu’un exemple d’utilisation.<\/p>\n

http:\/\/dasini.net\/blog\/toolkit-dev\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Nouvelle rubrique sur dasini.net: Toolkit DEV
\nLe but de cette rubrique est de synth\u00e9tiser les commandes les plus utiles aux d\u00e9veloppeurs MySQL.
\nVous retrouverai donc une liste, non exhaustive, des commandes sql les plus utilis\u00e9es lors du d\u00e9veloppement d’une application, ainsi qu’un exemple d’utilisation.<\/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":[1],"tags":[108],"class_list":["post-505","post","type-post","status-publish","format-standard","hentry","category-non-classe","tag-toolkit-dev"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-89","jetpack-related-posts":[{"id":448,"url":"https:\/\/dasini.net\/blog\/2009\/02\/09\/restaurer-une-sauvegarde-en-desactivant-le-log-binaire\/","url_meta":{"origin":505,"position":0},"title":"Restaurer une sauvegarde en d\u00e9sactivant le log binaire","author":"Olivier DASINI","date":"9 f\u00e9vrier 2009","format":false,"excerpt":"Il est pafois utile de d\u00e9sactiver le log binaire lors d'une restauration. MySQL permet de le d\u00e9sactiver pour une session avec la commande SQL_LOG_BIN:","rel":"","context":"Dans "Astuce"","block_context":{"text":"Astuce","link":"https:\/\/dasini.net\/blog\/category\/astuce\/"},"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":505,"position":1},"title":"MySQL 5 : Les vues — (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 "MySQL"","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":687,"url":"https:\/\/dasini.net\/blog\/2009\/07\/27\/sql-server-et-mysql-stars-des-utilisateurs-europeens\/","url_meta":{"origin":505,"position":2},"title":"SQL Server et MySQL : stars des utilisateurs europ\u00e9ens","author":"Olivier DASINI","date":"27 juillet 2009","format":false,"excerpt":"Selon la derni\u00e8re \u00e9tude d'Evans Data, les d\u00e9veloppeurs europ\u00e9ens auraient abondemment utilis\u00e9 SQL Server et MySQL. Les deux bases se retrouvent plac\u00e9es dans un mouchoir de poche, alrs qu'Oracle se classe troisi\u00e8me. Plus surprenant, DB2 est devanc\u00e9 par PostGreSQL. Les d\u00e9veloppeurs de la zone EMEA ont presque autant utilis\u00e9 SQL\u2026","rel":"","context":"Dans "Divers"","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"img":{"alt_text":"evansjpg","src":"https:\/\/i0.wp.com\/www.lemagit.fr\/files\/caafani6behdhxrka4knac3go4zb7dju87c5rp08w208h12c.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1153,"url":"https:\/\/dasini.net\/blog\/2011\/12\/12\/meetup-mysql-viadeo-lemug-fr-les-videos\/","url_meta":{"origin":505,"position":3},"title":"Meetup MySQL Viadeo \/ LeMUG.fr, les vid\u00e9os","author":"Olivier DASINI","date":"12 d\u00e9cembre 2011","format":false,"excerpt":"Les vid\u00e9os du meetup Viadeo\/LeMUG sont dispo: Christophe Tibault : Opening keynote C\u00e9dric Peintre : Planification et monitoring de mysqldump avec ZRM community St\u00e9phane Combaudon : Maatkit\/Percona Toolkit en pratique Marc Thomas : Passer de 10 000 \u00e0 plus de 10 000 000 de paiements par mois Olivier Dasini :\u2026","rel":"","context":"Dans "Conf\u00e9rence"","block_context":{"text":"Conf\u00e9rence","link":"https:\/\/dasini.net\/blog\/category\/conference\/"},"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":505,"position":4},"title":"MySQL 5.0 : Un SGBDR mature ? — (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 "MySQL"","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":544,"url":"https:\/\/dasini.net\/blog\/2009\/03\/29\/jobs-nouvelle-rubrique-sur-dasininet\/","url_meta":{"origin":505,"position":5},"title":"Jobs: nouvelle rubrique sur dasini.net","author":"Olivier DASINI","date":"29 mars 2009","format":false,"excerpt":"MySQL, php, Zend Frameworkd, Symfony, AJAX,... La demande est l\u00e0 ! voici ma modeste contribution http:\/\/dasini.net\/blog\/jobs\/","rel":"","context":"Dans "Divers"","block_context":{"text":"Divers","link":"https:\/\/dasini.net\/blog\/category\/divers\/"},"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\/505","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=505"}],"version-history":[{"count":4,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/505\/revisions"}],"predecessor-version":[{"id":510,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/505\/revisions\/510"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=505"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=505"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=505"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}