{"id":39,"date":"2008-12-22T23:48:00","date_gmt":"2008-12-22T21:48:00","guid":{"rendered":"http:\/\/www.blackhats.es\/wordpress\/?p=39"},"modified":"2022-08-20T18:26:12","modified_gmt":"2022-08-20T16:26:12","slug":"sql-en-emacs","status":"publish","type":"post","link":"https:\/\/www.blackhats.es\/wordpress\/?p=39","title":{"rendered":"SQL en emacs"},"content":{"rendered":"<p>Para utilizar SQL bajo emacs requiere tener instalado el cliente mysql como m\u00ednimo.<\/p>\n<p>Existen 2 m\u00e9todos a la hora de operar con SQL:<\/p>\n<ul>\n<li><strong>Interactivo (interactive):<\/strong> te comunica directamente con la base de datos del servidor, ejecuta los comandos y muestra la salida inmediatamente.<\/li>\n<\/ul>\n<ul>\n<li><strong>Editando (editing):<\/strong> te permite construir y editar comandos m\u00e1s complejos.<\/li>\n<\/ul>\n<p>Para ejecutar el modo interactivo debemos pulsar <strong>M-x sql-mysql<\/strong> y luego pregunta por el modo espec\u00edfico de la base de datos. Tambi\u00e9n pedir\u00e1 datos como <strong>username<\/strong>, <strong>password<\/strong>, <strong>base de datos<\/strong> y <strong>servidor a conectar<\/strong>.<\/p>\n<p>Para entrar en modo editando debemos ejecutar <strong>M-x sql-mode<\/strong>. Este modo provee cierta asistencia para componer sentencias SQL complejas.<\/p>\n<p><strong>C-c C-c<\/strong> : &#8216;<span style=\"color: #0000ff;\">sql-send-paragraph<\/span>&#8216;; env\u00eda el p\u00e1rrafo.<br \/>\n<strong> C-c C-v<\/strong> : &#8216;<span style=\"color: #0000ff;\">sql-send-region<\/span>&#8216;; env\u00eda una regi\u00f3n.<br \/>\n<strong> C-c C-b<\/strong> : &#8216;<span style=\"color: #0000ff;\">sql-send-buffer<\/span>&#8216;; env\u00eda el buffer completo.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Para utilizar SQL bajo emacs requiere tener instalado el cliente mysql como m\u00ednimo. Existen 2 m\u00e9todos a la hora de operar con SQL: Interactivo (interactive): te comunica directamente con la base de datos del servidor, ejecuta los comandos y muestra la salida inmediatamente. Editando (editing): te permite construir y editar comandos m\u00e1s complejos. Para ejecutar [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[8,49,50,51],"class_list":["post-39","post","type-post","status-publish","format-standard","hentry","category-basic","tag-emacs","tag-sql","tag-sql-mode","tag-sql-mysql"],"_links":{"self":[{"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/39"}],"collection":[{"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=39"}],"version-history":[{"count":1,"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions"}],"predecessor-version":[{"id":792,"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/39\/revisions\/792"}],"wp:attachment":[{"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=39"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=39"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.blackhats.es\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=39"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}