Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the breadcrumb-navxt domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/devtools/public_html/blog/wp-includes/functions.php on line 6131
{"id":493,"date":"2012-03-19T14:21:00","date_gmt":"2012-03-19T17:21:00","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/"},"modified":"2021-09-04T18:00:42","modified_gmt":"2021-09-04T21:00:42","slug":"aniversariantes-do-mes-no-mysql","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/","title":{"rendered":"Aniversariantes do m\u00eas no MySQL"},"content":{"rendered":"\n

Agora que voc\u00ea j\u00e1 sabe como fazer para obter os aniversariantes do m\u00eas em PostgreSQL<\/a>, vou ensinar voc\u00ea como filtrar com um comando SQL simples os aniversariantes do m\u00eas no MySQL.<\/p>\n\n\n\n

Para nosso exemplo, iremos criar uma estrutura com uma tabela, bem simples, onde iremos inserir os registros como se fosse uma tabela com as pessoas e suas respectivas datas de nascimento, ap\u00f3s, com uso da fun\u00e7\u00e3o nativa month, localizaremos os aniversariantes, seja do m\u00eas atual ou qualquer outro m\u00eas do ano.<\/p>\n\n\n\n

1\u00ba – Estrutura de tabela dos aniversariantes do m\u00eas em MySQL:<\/h2>\n\n\n\n
 Create Table aniversariantes   \n  (   \n   id_aniversariante bigint,    \n   nome varchar(50),    \n   dt_nascimento date   \n  );  \n<\/code><\/pre>\n\n\n\n
2\u00ba – Inserindo registros e suas datas de nascimento:<\/h2>\n\n\n\n
 Insert Into aniversariantes(id_aniversariante,nome,dt_nascimento)   \n  Values(1,'Aniversariante 1','2012-01-01')   \n  ,(2,'Aniversariante 2','2012-02-01')   \n  ,(3,'Aniversariante 3','2012-03-01')   \n  ,(4,'Aniversariante 4','2012-04-01')   \n  ,(5,'Aniversariante 5','2012-05-01')   \n  ,(6,'Aniversariante 6','2012-06-01')   \n  ,(7,'Aniversariante 7','2012-07-01')   \n  ,(8,'Aniversariante 8','2012-08-01')   \n  ,(9,'Aniversariante 9','2012-09-01')   \n  ,(10,'Aniversariante 10','2012-10-01')   \n  ,(11,'Aniversariante 11','2012-11-01')   \n  ,(12,'Aniversariante 12','2012-12-01');   \n<\/code><\/pre>\n\n\n\n
3\u00ba – Consulta SQL para encontrar os aniversariantes do m\u00eas:<\/h2>\n\n\n\n
  Select *    \n  From aniversariantes   \n  Where Month(dt_nascimento) = Month(Now());  \n<\/code><\/pre>\n\n\n\n
Pronto, muito simples!<\/p>\n\n\n\n
De modo a complementar sua query, voc\u00ea pode filtrar os aniversariantes do dia atual, pra isto, adicione uma condi\u00e7\u00e3o and ali com a fun\u00e7\u00e3o day, vejamos:<\/p>\n\n\n\n
Select *    \nFrom aniversariantes   \nWhere Month(dt_nascimento) = Month(Now())\nand day(dt_nascimento) = day(Now());<\/code><\/pre>\n\n\n\n
Bom, fico por aqui, esperando mais uma vez ter sido \u00fatil, um grande abra\u00e7o e at\u00e9 a pr\u00f3xima.<\/p>\n","protected":false},"excerpt":{"rendered":"
Agora que voc\u00ea j\u00e1 sabe como fazer para obter os aniversariantes do m\u00eas em PostgreSQL, vou ensinar voc\u00ea como filtrar com um comando SQL simples os aniversariantes do m\u00eas no MySQL. Para nosso exemplo, iremos criar uma estrutura com uma tabela, bem simples, onde iremos inserir os registros como se fosse uma tabela com as … Ler mais<\/a><\/p>\n","protected":false},"author":1,"featured_media":849,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[272,49],"tags":[],"class_list":["post-493","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-banco-de-dados","category-mysql"],"yoast_head":"\nAniversariantes do m\u00eas no MySQL<\/title>\n<meta name=\"description\" content=\"Veja como filtrar atrav\u00e9s de uma query SQL como localizar os aniversariantes do m\u00eas no MYSQL, utilizando a fun\u00e7\u00e3o Month.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Aniversariantes do m\u00eas no MySQL\" \/>\n<meta property=\"og:description\" content=\"Veja como filtrar atrav\u00e9s de uma query SQL como localizar os aniversariantes do m\u00eas no MYSQL, utilizando a fun\u00e7\u00e3o Month.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Devtools\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-19T17:21:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-04T21:00:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3000\" \/>\n\t<meta property=\"og:image:height\" content=\"2000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Fabiano Abreu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fabiano Abreu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/\"},\"author\":{\"name\":\"Fabiano Abreu\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"headline\":\"Aniversariantes do m\u00eas no MySQL\",\"datePublished\":\"2012-03-19T17:21:00+00:00\",\"dateModified\":\"2021-09-04T21:00:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/\"},\"wordCount\":174,\"commentCount\":12,\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"articleSection\":[\"Banco de Dados\",\"MySQL\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/\",\"name\":\"Aniversariantes do m\u00eas no MySQL\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"datePublished\":\"2012-03-19T17:21:00+00:00\",\"dateModified\":\"2021-09-04T21:00:42+00:00\",\"description\":\"Veja como filtrar atrav\u00e9s de uma query SQL como localizar os aniversariantes do m\u00eas no MYSQL, utilizando a fun\u00e7\u00e3o Month.\",\"breadcrumb\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png\",\"width\":3000,\"height\":2000,\"caption\":\"MySQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/devtools.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Aniversariantes do m\u00eas no MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\",\"url\":\"https:\/\/devtools.com.br\/blog\/\",\"name\":\"Devtools\",\"description\":\"Sua caixa de ferramentas online\",\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devtools.com.br\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\",\"name\":\"Fabiano Abreu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"width\":184,\"height\":184,\"caption\":\"Fabiano Abreu\"},\"logo\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/devtools.com.br\/blog\"],\"url\":\"https:\/\/devtools.com.br\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Aniversariantes do m\u00eas no MySQL","description":"Veja como filtrar atrav\u00e9s de uma query SQL como localizar os aniversariantes do m\u00eas no MYSQL, utilizando a fun\u00e7\u00e3o Month.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/","og_locale":"pt_BR","og_type":"article","og_title":"Aniversariantes do m\u00eas no MySQL","og_description":"Veja como filtrar atrav\u00e9s de uma query SQL como localizar os aniversariantes do m\u00eas no MYSQL, utilizando a fun\u00e7\u00e3o Month.","og_url":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/","og_site_name":"Devtools","article_published_time":"2012-03-19T17:21:00+00:00","article_modified_time":"2021-09-04T21:00:42+00:00","og_image":[{"width":3000,"height":2000,"url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","type":"image\/png"}],"author":"Fabiano Abreu","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Fabiano Abreu","Est. tempo de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#article","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/"},"author":{"name":"Fabiano Abreu","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"headline":"Aniversariantes do m\u00eas no MySQL","datePublished":"2012-03-19T17:21:00+00:00","dateModified":"2021-09-04T21:00:42+00:00","mainEntityOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/"},"wordCount":174,"commentCount":12,"publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","articleSection":["Banco de Dados","MySQL"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/","url":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/","name":"Aniversariantes do m\u00eas no MySQL","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","datePublished":"2012-03-19T17:21:00+00:00","dateModified":"2021-09-04T21:00:42+00:00","description":"Veja como filtrar atrav\u00e9s de uma query SQL como localizar os aniversariantes do m\u00eas no MYSQL, utilizando a fun\u00e7\u00e3o Month.","breadcrumb":{"@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#primaryimage","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2013\/06\/MySQL-Logo.wine_.png","width":3000,"height":2000,"caption":"MySQL"},{"@type":"BreadcrumbList","@id":"https:\/\/devtools.com.br\/blog\/aniversariantes-do-mes-no-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/devtools.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Aniversariantes do m\u00eas no MySQL"}]},{"@type":"WebSite","@id":"https:\/\/devtools.com.br\/blog\/#website","url":"https:\/\/devtools.com.br\/blog\/","name":"Devtools","description":"Sua caixa de ferramentas online","publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devtools.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed","name":"Fabiano Abreu","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","width":184,"height":184,"caption":"Fabiano Abreu"},"logo":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/devtools.com.br\/blog"],"url":"https:\/\/devtools.com.br\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/comments?post=493"}],"version-history":[{"count":2,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/493\/revisions"}],"predecessor-version":[{"id":768,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/493\/revisions\/768"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media\/849"}],"wp:attachment":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media?parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/categories?post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/tags?post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}