{"id":138,"date":"2011-07-26T11:10:00","date_gmt":"2011-07-26T14:10:00","guid":{"rendered":"http:\/\/helbertt.16mb.com\/site\/index.php\/2011\/07\/26\/deletando-registros-com-mais-de-30-dias-mysql\/"},"modified":"2011-07-26T11:10:00","modified_gmt":"2011-07-26T14:10:00","slug":"deletando-registros-com-mais-de-30-dias-mysql","status":"publish","type":"post","link":"https:\/\/helbertt.xyz\/site\/deletando-registros-com-mais-de-30-dias-mysql\/","title":{"rendered":"Deletando registros com mais de 30 dias \u2013 MySQL"},"content":{"rendered":"<p>Se voc\u00ea quiser excluir registros com mais de X dias no MySQL, h\u00e1 uma maneira simples de fazer:<\/p>\n<p><\/p>\n<blockquote><p>DELETE FROM tabela WHERE date &lt; DATE_SUB(NOW(), INTERVAL 30 DAY); <\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Se voc\u00ea quiser excluir registros com mais de X dias no MySQL, h\u00e1 uma maneira simples de fazer: DELETE FROM<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout"},"categories":[70,31],"tags":[],"_links":{"self":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/138"}],"collection":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/comments?post=138"}],"version-history":[{"count":0,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/posts\/138\/revisions"}],"wp:attachment":[{"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/media?parent=138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/categories?post=138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helbertt.xyz\/site\/wp-json\/wp\/v2\/tags?post=138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}