{"id":1076,"date":"2024-07-31T11:02:18","date_gmt":"2024-07-31T09:02:18","guid":{"rendered":"https:\/\/blog.sutilweb.eu\/?page_id=1076"},"modified":"2024-07-31T11:02:19","modified_gmt":"2024-07-31T09:02:19","slug":"sql","status":"publish","type":"page","link":"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"<ul class=\"su-subpages\"><li class=\"page_item page-item-1080 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/01-introduccion-a-sql\/\" class=\"menu-link\">01. Introducci\u00f3n a SQL<\/a><\/li>\n<li class=\"page_item page-item-1084 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/02-tipos-de-sbgds\/\" class=\"menu-link\">02. Tipos de SBGDs<\/a><\/li>\n<li class=\"page_item page-item-1087 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/03-herramientas-de-trabajo\/\" class=\"menu-link\">03. Herramientas de trabajo<\/a><\/li>\n<li class=\"page_item page-item-1089 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/04-tipos-de-datos-en-sql\/\" class=\"menu-link\">04. Tipos de datos en SQL<\/a><\/li>\n<li class=\"page_item page-item-1091 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/05-tipos-de-sentencias-en-sql\/\" class=\"menu-link\">05. Tipos de sentencias en SQL<\/a><\/li>\n<li class=\"page_item page-item-1093 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/06-comandos-y-funciones-basicas-sql\/\" class=\"menu-link\">06. Comandos y funciones b\u00e1sicas SQL<\/a><\/li>\n<li class=\"page_item page-item-1096 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/07-conexion-a-nuestra-sbgd\/\" class=\"menu-link\">07. Conexi\u00f3n a nuestra SBGD<\/a><\/li>\n<li class=\"page_item page-item-1098 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/08-sintaxis-sql-y-buenas-practicas\/\" class=\"menu-link\">08. Sintaxis SQL y buenas pr\u00e1cticas<\/a><\/li>\n<li class=\"page_item page-item-1101 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/09-creando-y-eliminado-bds\/\" class=\"menu-link\">09. Creando y eliminado BDs<\/a><\/li>\n<li class=\"page_item page-item-1103 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/10-condicionales-if-exists-if-not-exists\/\" class=\"menu-link\">10. Condicionales IF EXISTS &amp; IF NOT EXISTS<\/a><\/li>\n<li class=\"page_item page-item-1105 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/11-gestionando-usuarios\/\" class=\"menu-link\">11. Gestionando usuarios<\/a><\/li>\n<li class=\"page_item page-item-1107 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/12-gestionando-privilegios-a-usuarios\/\" class=\"menu-link\">12. Gestionando privilegios a usuarios<\/a><\/li>\n<li class=\"page_item page-item-1110 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/13-creando-tablas\/\" class=\"menu-link\">13. Creando tablas<\/a><\/li>\n<li class=\"page_item page-item-1112 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/14-atributos-de-los-campos-de-una-tabla\/\" class=\"menu-link\">14. Atributos de los campos de una tabla<\/a><\/li>\n<li class=\"page_item page-item-1114 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/15-sentencia-insert-y-select\/\" class=\"menu-link\">15. Sentencia INSERT y SELECT<\/a><\/li>\n<li class=\"page_item page-item-1116 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/16-clausula-update-y-delete\/\" class=\"menu-link\">16. Cla\u00fasula UPDATE y DELETE<\/a><\/li>\n<li class=\"page_item page-item-1118 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/17-sentencia-truncate\/\" class=\"menu-link\">17. Sentencia TRUNCATE<\/a><\/li>\n<li class=\"page_item page-item-1120 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/18-preparando-la-bd-para-nuevos-temas\/\" class=\"menu-link\">18. Preparando la BD para nuevos temas<\/a><\/li>\n<li class=\"page_item page-item-1122 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/19-columnas-calculadas-y-funciones-de-agrupamiento\/\" class=\"menu-link\">19. Columnas calculadas y funciones de agrupamiento<\/a><\/li>\n<li class=\"page_item page-item-1124 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/20-clausula-group-by\/\" class=\"menu-link\">20. Cla\u00fasula GROUP BY<\/a><\/li>\n<li class=\"page_item page-item-1126 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/21-clausula-having\/\" class=\"menu-link\">21. Cla\u00fasula HAVING<\/a><\/li>\n<li class=\"page_item page-item-1128 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/22-clausula-distinct\/\" class=\"menu-link\">22. Cla\u00fasula DISTINCT<\/a><\/li>\n<li class=\"page_item page-item-1130 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/23-clausula-order\/\" class=\"menu-link\">23. Cla\u00fasula ORDER<\/a><\/li>\n<li class=\"page_item page-item-1132 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/24-clausula-between\/\" class=\"menu-link\">24. Cla\u00fasula BETWEEN<\/a><\/li>\n<li class=\"page_item page-item-1134 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/25-clausula-regexp\/\" class=\"menu-link\">25. Clausula REGEXP<\/a><\/li>\n<li class=\"page_item page-item-1136 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/26-funciones-de-cadenas-de-texto\/\" class=\"menu-link\">26. Funciones de cadenas de texto<\/a><\/li>\n<li class=\"page_item page-item-1138 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/27-indices\/\" class=\"menu-link\">27. \u00cdndices<\/a><\/li>\n<li class=\"page_item page-item-1140 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/28-llaves-foraneas\/\" class=\"menu-link\">28. Llaves for\u00e1neas<\/a><\/li>\n<li class=\"page_item page-item-1142 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/29-introduccion-a-los-joins\/\" class=\"menu-link\">29. Introducci\u00f3n a los JOINS<\/a><\/li>\n<li class=\"page_item page-item-1145 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/30-refactorizando-bd-para-joins\/\" class=\"menu-link\">30. Refactorizando BD para JOINS<\/a><\/li>\n<li class=\"page_item page-item-1147 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/31-subconsultas\/\" class=\"menu-link\">31. Subconsultas<\/a><\/li>\n<li class=\"page_item page-item-1149 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/32-vistas\/\" class=\"menu-link\">32. Vistas<\/a><\/li>\n<li class=\"page_item page-item-1151 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/33-motores-de-tablas\/\" class=\"menu-link\">33. Motores de tablas<\/a><\/li>\n<li class=\"page_item page-item-1153 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/34-juego-de-caracteres\/\" class=\"menu-link\">34. Juego de caracteres<\/a><\/li>\n<li class=\"page_item page-item-1155 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/35-restricciones\/\" class=\"menu-link\">35. Restricciones<\/a><\/li>\n<li class=\"page_item page-item-1157 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/36-transacciones\/\" class=\"menu-link\">36. Transacciones<\/a><\/li>\n<li class=\"page_item page-item-1159 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/37-funciones-de-encriptacion-y-desencriptacion\/\" class=\"menu-link\">37. Funciones de encriptaci\u00f3n y desencriptaci\u00f3n<\/a><\/li>\n<li class=\"page_item page-item-1161 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/38-procedimientos-almacenados\/\" class=\"menu-link\">38. Procedimientos almacenados<\/a><\/li>\n<li class=\"page_item page-item-1163 menu-item\"><a href=\"https:\/\/sutilweb.eu\/index.php\/databases\/sql\/39-triggers-o-disparadores\/\" class=\"menu-link\">39. Triggers o disparadores<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":1007,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-1076","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Sutil Web","author_link":"https:\/\/sutilweb.eu\/index.php\/author\/sutilweb\/"},"uagb_comment_info":0,"uagb_excerpt":null,"_links":{"self":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1076","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/comments?post=1076"}],"version-history":[{"count":2,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1076\/revisions"}],"predecessor-version":[{"id":1078,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1076\/revisions\/1078"}],"up":[{"embeddable":true,"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/pages\/1007"}],"wp:attachment":[{"href":"https:\/\/sutilweb.eu\/index.php\/wp-json\/wp\/v2\/media?parent=1076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}