{"id":2612,"date":"2022-09-24T11:50:04","date_gmt":"2022-09-24T11:50:04","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=2612"},"modified":"2023-05-20T13:57:14","modified_gmt":"2023-05-20T13:57:14","slug":"providing-friday-proofs-to-mysql-consultants","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants","title":{"rendered":"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &#8220;Friday&#8221;, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to prove it. Prove it technically that it actually is a Friday.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This blog post is my attempt to share the proofs of existence of a &#8220;Friday&#8221;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using MySQL datetime function: dayname<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>MySQL &#91;(Kedar)]&gt; select dayname(now());\n+----------------+\n| dayname(now()) |\n+----------------+\n| Friday         |\n+----------------+\n1 row in set (0.000 sec)\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Running system command from MySQL prompt<\/h2>\n\n\n\n<!--more-->\n\n\n\n<pre class=\"wp-block-code\"><code>MySQL &#91;(Kedar)]&gt; \\! date +'%A'\nFriday\nMySQL &#91;(Kedar)]&gt;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Using ntpd service with shell script and cowsay<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code># Shell Script: .\/believeitornot\n&gt;\/tmp\/sayit\nspeak_the_truth() {\nclear\n cat \/tmp\/sayit | cowsay -f tux\n exit;\n}\n# pgrep -x chronyd&gt;\/dev\/null &amp;&amp; echo -e \"Declaration: Sworn on NTP daemon.\\n\" &gt; \/tmp\/sayit  &amp;&amp; ntpd=1 || ( echo \"Can't trust time without ntpd\" &gt;&gt; \/tmp\/sayit &amp;&amp; speak_the_truth &amp;&amp; exit 1; )\npgrep -x ntpd &gt;\/dev\/null &amp;&amp; echo -e \"Declaration: Sworn on NTP daemon.\\n\" &gt; \/tmp\/sayit  &amp;&amp; ntpd=1 || ( echo \"Can't trust time without ntpd\" &gt;&gt; \/tmp\/sayit &amp;&amp; speak_the_truth &amp;&amp; exit 1; )\nspeak_the_truth\nsleep 1\nif &#91; $ntpd == 1 ]; then\n for day in Saturday Sunday Monday Tuesday Wednesday Thursday; do\n  sleep 1;\n  if &#91; `date +'%A'` != $day ]; then\n   echo -e \"Is this $day: NO. \\n\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n  else\n   echo -e \"This is $day, not a Friday.\\n\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n   exit;\n  fi\n done;\n  sleep 1;\n  if ! &#91; `date +'%A'` != \"Friday\" ]; then\n   echo -e \"Is this anything but Friday? - NO\\n\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n   sleep 1;\n   echo -e \"\\n Thank NTPD it is Friday.\" &gt;&gt; \/tmp\/sayit\n   speak_the_truth\n  fi;\nfi;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Note that this was done on Cent OS 7. For Cent OS 8 you might not get ntp and instead use chronyd.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Sample Execution and proving of Friday<\/strong> <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>_______________________________\n&lt; Can't trust time without ntpd &gt;\n-------------------------------\n  \\\n   \\\n       .--.\n      |o_o |\n      |:_\/ |\n     \/\/   \\ \\\n    (|     | )\n   \/'\\_   _\/`\\\n   \\___)=(___\/\n\n\n   ___________________________________\n  \/ Declaration: Sworn on NTP daemon. \\\n  |                                   |\n  | Is this Saturday: NO.             |\n  |                                   |\n  | Is this Sunday: NO.               |\n  |                                   |\n  | Is this Monday: NO.               |\n  |                                   |\n  | Is this Tuesday: NO.              |\n  |                                   |\n  | Is this Wednesday: NO.            |\n  |                                   |\n  | Is this Thursday: NO.             |\n  |                                   |\n  | Is this anything but Friday? - NO |\n  |                                   |\n  \\ Thank NTPD it is Friday.          \/\n   -----------------------------------\n         \\\n          \\\n              .--.\n             |o_o |\n             |:_\/ |\n            \/\/   \\ \\\n           (|     | )\n          \/'\\_   _\/`\\\n          \\___)=(___\/\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Stored procedure in MySQL 8 using WITH RECURSIVE<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>DROP PROCEDURE IF EXISTS kedar.is_it_friday;\ndelimiter \/\/\nCREATE PROCEDURE kedar.is_it_friday(IN today varchar(15))\nBEGIN\n\n  IF STR_TO_DATE(today,'%Y-%m-%d') IS NULL THEN\n      SIGNAL SQLSTATE 'ERR0R' SET MESSAGE_TEXT = 'Are you insane?';\n  END IF;\n\n  WITH RECURSIVE `days` AS\n  (\n    SELECT 1 AS `day` UNION ALL SELECT `day` + 1 FROM `days` WHERE `day` &lt; DAY(LAST_DAY(NOW()))\n  )\n  SELECT dt fridays_in_month, if(dt = date(now()),'Hell Yeah!!!','Nope!') is_it_today from (SELECT concat(year(today),'-',lpad(month(today),2,'0'),'-',lpad(day,2,'0')) dt FROM `days` where DAYNAME(concat(year(today),'-',lpad(month(today),2,'0'),'-',lpad(day,2,'0'))) ='FRIDAY') xXx;\nEND\n\/\/\ndelimiter ;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Executing the procedure and validating proofs<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql&gt; call kedar.is_it_friday('2022-09-16');\n+------------------+--------------+\n| fridays_in_month | is_it_today  |\n+------------------+--------------+\n| 2022-09-02       | Nope!        |\n| 2022-09-09       | Nope!        |\n| 2022-09-16       | Hell Yeah!!! |\n| 2022-09-23       | Nope!        |\n| 2022-09-30       | Nope!        |\n+------------------+--------------+\n5 rows in set (0.00 sec)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">List Fridays of the whole year using MySQL procedures<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>\nDROP PROCEDURE IF EXISTS kedar.list_annual_days;\ndelimiter \/\/\nCREATE PROCEDURE kedar.list_annual_days(IN year varchar(4), IN day varchar(10))\nBEGIN\nDECLARE dateStart date;\nDECLARE dateEnd date;\nDECLARE _query VARCHAR(1000);\n\nIF day = '' THEN SET day='FRIDAY'; END IF;\nIF year = '' THEN SET year=year(now()); END IF;\n\nselect day, year;\nset dateStart=(select concat(year,'-01-01'));\nset dateEnd=(select concat(year,'-12-31'));\n\n\nDROP TABLE IF EXISTS days_8582;\nCREATE TEMPORARY TABLE days_8582 (kdt varchar(20), kdy varchar(20));\nWHILE dateStart &lt;= dateEnd DO\n  INSERT INTO days_8582 select dateStart, DAYNAME(dateStart) from dual where  DAYNAME(dateStart) = day;\n  SET dateStart = date_add(dateStart, INTERVAL 1 DAY);\nEND WHILE;\nselect kdt date, kdy day,  if(kdt = date(now()),'Hell Yeah!!!','Nope!') is_it_today,if( datediff(kdt, now()) &lt; 0,concat(abs( datediff(kdt, now())), ' days ago'), concat(abs( datediff(kdt, now())), ' days to go')) `when` from days_8582;\nDROP TABLE IF EXISTS days_8582;\nEND\n\/\/\ndelimiter ;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Executing the procedure and validating proofs<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql &#91;kedar]&gt; call kedar.list_annual_days('','');\n+--------+------+\n| day    | year |\n+--------+------+\n| FRIDAY | 2022 |\n+--------+------+\n1 row in set (0.001 sec)\n\n+------------+--------+--------------+---------------+\n| date       | day    | is_it_today  | when          |\n+------------+--------+--------------+---------------+\n| 2022-01-07 | Friday | Nope!        | 259 days ago  |\n| 2022-01-14 | Friday | Nope!        | 252 days ago  |\n| 2022-01-21 | Friday | Nope!        | 245 days ago  |\n| 2022-01-28 | Friday | Nope!        | 238 days ago  |\n| 2022-02-04 | Friday | Nope!        | 231 days ago  |\n| 2022-02-11 | Friday | Nope!        | 224 days ago  |\n| 2022-02-18 | Friday | Nope!        | 217 days ago  |\n| 2022-02-25 | Friday | Nope!        | 210 days ago  |\n| 2022-03-04 | Friday | Nope!        | 203 days ago  |\n| 2022-03-11 | Friday | Nope!        | 196 days ago  |\n| 2022-03-18 | Friday | Nope!        | 189 days ago  |\n| 2022-03-25 | Friday | Nope!        | 182 days ago  |\n| 2022-04-01 | Friday | Nope!        | 175 days ago  |\n| 2022-04-08 | Friday | Nope!        | 168 days ago  |\n| 2022-04-15 | Friday | Nope!        | 161 days ago  |\n| 2022-04-22 | Friday | Nope!        | 154 days ago  |\n| 2022-04-29 | Friday | Nope!        | 147 days ago  |\n| 2022-05-06 | Friday | Nope!        | 140 days ago  |\n| 2022-05-13 | Friday | Nope!        | 133 days ago  |\n| 2022-05-20 | Friday | Nope!        | 126 days ago  |\n| 2022-05-27 | Friday | Nope!        | 119 days ago  |\n| 2022-06-03 | Friday | Nope!        | 112 days ago  |\n| 2022-06-10 | Friday | Nope!        | 105 days ago  |\n| 2022-06-17 | Friday | Nope!        | 98 days ago   |\n| 2022-06-24 | Friday | Nope!        | 91 days ago   |\n| 2022-07-01 | Friday | Nope!        | 84 days ago   |\n| 2022-07-08 | Friday | Nope!        | 77 days ago   |\n| 2022-07-15 | Friday | Nope!        | 70 days ago   |\n| 2022-07-22 | Friday | Nope!        | 63 days ago   |\n| 2022-07-29 | Friday | Nope!        | 56 days ago   |\n| 2022-08-05 | Friday | Nope!        | 49 days ago   |\n| 2022-08-12 | Friday | Nope!        | 42 days ago   |\n| 2022-08-19 | Friday | Nope!        | 35 days ago   |\n| 2022-08-26 | Friday | Nope!        | 28 days ago   |\n| 2022-09-02 | Friday | Nope!        | 21 days ago   |\n| 2022-09-09 | Friday | Nope!        | 14 days ago   |\n| 2022-09-16 | Friday | Nope!        | 7 days ago    |\n<strong>| 2022-09-23 | Friday | Hell Yeah!!! | 0 days to go  |<\/strong>\n| 2022-09-30 | Friday | Nope!        | 7 days to go  |\n| 2022-10-07 | Friday | Nope!        | 14 days to go |\n| 2022-10-14 | Friday | Nope!        | 21 days to go |\n| 2022-10-21 | Friday | Nope!        | 28 days to go |\n| 2022-10-28 | Friday | Nope!        | 35 days to go |\n| 2022-11-04 | Friday | Nope!        | 42 days to go |\n| 2022-11-11 | Friday | Nope!        | 49 days to go |\n| 2022-11-18 | Friday | Nope!        | 56 days to go |\n| 2022-11-25 | Friday | Nope!        | 63 days to go |\n| 2022-12-02 | Friday | Nope!        | 70 days to go |\n| 2022-12-09 | Friday | Nope!        | 77 days to go |\n| 2022-12-16 | Friday | Nope!        | 84 days to go |\n| 2022-12-23 | Friday | Nope!        | 91 days to go |\n| 2022-12-30 | Friday | Nope!        | 98 days to go |\n+------------+--------+--------------+---------------+\n52 rows in set (0.020 sec)<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Let&#8217;s verifying against all time-zones and verify all are having Friday<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>&#91;kedar@nitty-witty.com ~]# for tz in `timedatectl list-timezones`; do echo $tz has `date --date='TZ=\"$tz\" this Fri' +'%A'`; done<\/strong>\nAfrica\/Abidjan has Friday\nAfrica\/Accra has Friday\nAfrica\/Addis_Ababa has Friday\nAfrica\/Algiers has Friday\nAfrica\/Asmara has Friday\nAfrica\/Bamako has Friday\nAfrica\/Bangui has Friday\nAfrica\/Banjul has Friday\nAfrica\/Bissau has Friday\nAfrica\/Blantyre has Friday\nAfrica\/Brazzaville has Friday\nAfrica\/Bujumbura has Friday\nAfrica\/Cairo has Friday\nAfrica\/Casablanca has Friday\nAfrica\/Ceuta has Friday\nAfrica\/Conakry has Friday\nAfrica\/Dakar has Friday\nAfrica\/Dar_es_Salaam has Friday\nAfrica\/Djibouti has Friday\nAfrica\/Douala has Friday\nAfrica\/El_Aaiun has Friday\nAfrica\/Freetown has Friday\nAfrica\/Gaborone has Friday\nAfrica\/Harare has Friday\nAfrica\/Johannesburg has Friday\nAfrica\/Juba has Friday\nAfrica\/Kampala has Friday\nAfrica\/Khartoum has Friday\nAfrica\/Kigali has Friday\nAfrica\/Kinshasa has Friday\nAfrica\/Lagos has Friday\nAfrica\/Libreville has Friday\nAfrica\/Lome has Friday\nAfrica\/Luanda has Friday\nAfrica\/Lubumbashi has Friday\nAfrica\/Lusaka has Friday\nAfrica\/Malabo has Friday\nAfrica\/Maputo has Friday\nAfrica\/Maseru has Friday\nAfrica\/Mbabane has Friday\nAfrica\/Mogadishu has Friday\nAfrica\/Monrovia has Friday\nAfrica\/Nairobi has Friday\nAfrica\/Ndjamena has Friday\nAfrica\/Niamey has Friday\nAfrica\/Nouakchott has Friday\nAfrica\/Ouagadougou has Friday\nAfrica\/Porto-Novo has Friday\nAfrica\/Sao_Tome has Friday\nAfrica\/Tripoli has Friday\nAfrica\/Tunis has Friday\nAfrica\/Windhoek has Friday\nAmerica\/Adak has Friday\nAmerica\/Anchorage has Friday\nAmerica\/Anguilla has Friday\nAmerica\/Antigua has Friday\nAmerica\/Araguaina has Friday\nAmerica\/Argentina\/Buenos_Aires has Friday\nAmerica\/Argentina\/Catamarca has Friday\nAmerica\/Argentina\/Cordoba has Friday\nAmerica\/Argentina\/Jujuy has Friday\nAmerica\/Argentina\/La_Rioja has Friday\nAmerica\/Argentina\/Mendoza has Friday\nAmerica\/Argentina\/Rio_Gallegos has Friday\nAmerica\/Argentina\/Salta has Friday\nAmerica\/Argentina\/San_Juan has Friday\nAmerica\/Argentina\/San_Luis has Friday\nAmerica\/Argentina\/Tucuman has Friday\nAmerica\/Argentina\/Ushuaia has Friday\nAmerica\/Aruba has Friday\nAmerica\/Asuncion has Friday\nAmerica\/Atikokan has Friday\nAmerica\/Bahia has Friday\nAmerica\/Bahia_Banderas has Friday\nAmerica\/Barbados has Friday\nAmerica\/Belem has Friday\nAmerica\/Belize has Friday\nAmerica\/Blanc-Sablon has Friday\nAmerica\/Boa_Vista has Friday\nAmerica\/Bogota has Friday\nAmerica\/Boise has Friday\nAmerica\/Cambridge_Bay has Friday\nAmerica\/Campo_Grande has Friday\nAmerica\/Cancun has Friday\nAmerica\/Caracas has Friday\nAmerica\/Cayenne has Friday\nAmerica\/Cayman has Friday\nAmerica\/Chicago has Friday\nAmerica\/Chihuahua has Friday\nAmerica\/Costa_Rica has Friday\nAmerica\/Creston has Friday\nAmerica\/Cuiaba has Friday\nAmerica\/Curacao has Friday\nAmerica\/Danmarkshavn has Friday\nAmerica\/Dawson has Friday\nAmerica\/Dawson_Creek has Friday\nAmerica\/Denver has Friday\nAmerica\/Detroit has Friday\nAmerica\/Dominica has Friday\nAmerica\/Edmonton has Friday\nAmerica\/Eirunepe has Friday\nAmerica\/El_Salvador has Friday\nAmerica\/Fort_Nelson has Friday\nAmerica\/Fortaleza has Friday\nAmerica\/Glace_Bay has Friday\nAmerica\/Goose_Bay has Friday\nAmerica\/Grand_Turk has Friday\nAmerica\/Grenada has Friday\nAmerica\/Guadeloupe has Friday\nAmerica\/Guatemala has Friday\nAmerica\/Guayaquil has Friday\nAmerica\/Guyana has Friday\nAmerica\/Halifax has Friday\nAmerica\/Havana has Friday\nAmerica\/Hermosillo has Friday\nAmerica\/Indiana\/Indianapolis has Friday\nAmerica\/Indiana\/Knox has Friday\nAmerica\/Indiana\/Marengo has Friday\nAmerica\/Indiana\/Petersburg has Friday\nAmerica\/Indiana\/Tell_City has Friday\nAmerica\/Indiana\/Vevay has Friday\nAmerica\/Indiana\/Vincennes has Friday\nAmerica\/Indiana\/Winamac has Friday\nAmerica\/Inuvik has Friday\nAmerica\/Iqaluit has Friday\nAmerica\/Jamaica has Friday\nAmerica\/Juneau has Friday\nAmerica\/Kentucky\/Louisville has Friday\nAmerica\/Kentucky\/Monticello has Friday\nAmerica\/Kralendijk has Friday\nAmerica\/La_Paz has Friday\nAmerica\/Lima has Friday\nAmerica\/Los_Angeles has Friday\nAmerica\/Lower_Princes has Friday\nAmerica\/Maceio has Friday\nAmerica\/Managua has Friday\nAmerica\/Manaus has Friday\nAmerica\/Marigot has Friday\nAmerica\/Martinique has Friday\nAmerica\/Matamoros has Friday\nAmerica\/Mazatlan has Friday\nAmerica\/Menominee has Friday\nAmerica\/Merida has Friday\nAmerica\/Metlakatla has Friday\nAmerica\/Mexico_City has Friday\nAmerica\/Miquelon has Friday\nAmerica\/Moncton has Friday\nAmerica\/Monterrey has Friday\nAmerica\/Montevideo has Friday\nAmerica\/Montserrat has Friday\nAmerica\/Nassau has Friday\nAmerica\/New_York has Friday\nAmerica\/Nipigon has Friday\nAmerica\/Nome has Friday\nAmerica\/Noronha has Friday\nAmerica\/North_Dakota\/Beulah has Friday\nAmerica\/North_Dakota\/Center has Friday\nAmerica\/North_Dakota\/New_Salem has Friday\nAmerica\/Nuuk has Friday\nAmerica\/Ojinaga has Friday\nAmerica\/Panama has Friday\nAmerica\/Pangnirtung has Friday\nAmerica\/Paramaribo has Friday\nAmerica\/Phoenix has Friday\nAmerica\/Port-au-Prince has Friday\nAmerica\/Port_of_Spain has Friday\nAmerica\/Porto_Velho has Friday\nAmerica\/Puerto_Rico has Friday\nAmerica\/Punta_Arenas has Friday\nAmerica\/Rainy_River has Friday\nAmerica\/Rankin_Inlet has Friday\nAmerica\/Recife has Friday\nAmerica\/Regina has Friday\nAmerica\/Resolute has Friday\nAmerica\/Rio_Branco has Friday\nAmerica\/Santarem has Friday\nAmerica\/Santiago has Friday\nAmerica\/Santo_Domingo has Friday\nAmerica\/Sao_Paulo has Friday\nAmerica\/Scoresbysund has Friday\nAmerica\/Sitka has Friday\nAmerica\/St_Barthelemy has Friday\nAmerica\/St_Johns has Friday\nAmerica\/St_Kitts has Friday\nAmerica\/St_Lucia has Friday\nAmerica\/St_Thomas has Friday\nAmerica\/St_Vincent has Friday\nAmerica\/Swift_Current has Friday\nAmerica\/Tegucigalpa has Friday\nAmerica\/Thule has Friday\nAmerica\/Thunder_Bay has Friday\nAmerica\/Tijuana has Friday\nAmerica\/Toronto has Friday\nAmerica\/Tortola has Friday\nAmerica\/Vancouver has Friday\nAmerica\/Whitehorse has Friday\nAmerica\/Winnipeg has Friday\nAmerica\/Yakutat has Friday\nAmerica\/Yellowknife has Friday\nAntarctica\/Casey has Friday\nAntarctica\/Davis has Friday\nAntarctica\/DumontDUrville has Friday\nAntarctica\/Macquarie has Friday\nAntarctica\/Mawson has Friday\nAntarctica\/McMurdo has Friday\nAntarctica\/Palmer has Friday\nAntarctica\/Rothera has Friday\nAntarctica\/Syowa has Friday\nAntarctica\/Troll has Friday\nAntarctica\/Vostok has Friday\nArctic\/Longyearbyen has Friday\nAsia\/Aden has Friday\nAsia\/Almaty has Friday\nAsia\/Amman has Friday\nAsia\/Anadyr has Friday\nAsia\/Aqtau has Friday\nAsia\/Aqtobe has Friday\nAsia\/Ashgabat has Friday\nAsia\/Atyrau has Friday\nAsia\/Baghdad has Friday\nAsia\/Bahrain has Friday\nAsia\/Baku has Friday\nAsia\/Bangkok has Friday\nAsia\/Barnaul has Friday\nAsia\/Beirut has Friday\nAsia\/Bishkek has Friday\nAsia\/Brunei has Friday\nAsia\/Chita has Friday\nAsia\/Choibalsan has Friday\nAsia\/Colombo has Friday\nAsia\/Damascus has Friday\nAsia\/Dhaka has Friday\nAsia\/Dili has Friday\nAsia\/Dubai has Friday\nAsia\/Dushanbe has Friday\nAsia\/Famagusta has Friday\nAsia\/Gaza has Friday\nAsia\/Hebron has Friday\nAsia\/Ho_Chi_Minh has Friday\nAsia\/Hong_Kong has Friday\nAsia\/Hovd has Friday\nAsia\/Irkutsk has Friday\nAsia\/Jakarta has Friday\nAsia\/Jayapura has Friday\nAsia\/Jerusalem has Friday\nAsia\/Kabul has Friday\nAsia\/Kamchatka has Friday\nAsia\/Karachi has Friday\nAsia\/Kathmandu has Friday\nAsia\/Khandyga has Friday\nAsia\/Kolkata has Friday\nAsia\/Krasnoyarsk has Friday\nAsia\/Kuala_Lumpur has Friday\nAsia\/Kuching has Friday\nAsia\/Kuwait has Friday\nAsia\/Macau has Friday\nAsia\/Magadan has Friday\nAsia\/Makassar has Friday\nAsia\/Manila has Friday\nAsia\/Muscat has Friday\nAsia\/Nicosia has Friday\nAsia\/Novokuznetsk has Friday\nAsia\/Novosibirsk has Friday\nAsia\/Omsk has Friday\nAsia\/Oral has Friday\nAsia\/Phnom_Penh has Friday\nAsia\/Pontianak has Friday\nAsia\/Pyongyang has Friday\nAsia\/Qatar has Friday\nAsia\/Qostanay has Friday\nAsia\/Qyzylorda has Friday\nAsia\/Riyadh has Friday\nAsia\/Sakhalin has Friday\nAsia\/Samarkand has Friday\nAsia\/Seoul has Friday\nAsia\/Shanghai has Friday\nAsia\/Singapore has Friday\nAsia\/Srednekolymsk has Friday\nAsia\/Taipei has Friday\nAsia\/Tashkent has Friday\nAsia\/Tbilisi has Friday\nAsia\/Tehran has Friday\nAsia\/Thimphu has Friday\nAsia\/Tokyo has Friday\nAsia\/Tomsk has Friday\nAsia\/Ulaanbaatar has Friday\nAsia\/Urumqi has Friday\nAsia\/Ust-Nera has Friday\nAsia\/Vientiane has Friday\nAsia\/Vladivostok has Friday\nAsia\/Yakutsk has Friday\nAsia\/Yangon has Friday\nAsia\/Yekaterinburg has Friday\nAsia\/Yerevan has Friday\nAtlantic\/Azores has Friday\nAtlantic\/Bermuda has Friday\nAtlantic\/Canary has Friday\nAtlantic\/Cape_Verde has Friday\nAtlantic\/Faroe has Friday\nAtlantic\/Madeira has Friday\nAtlantic\/Reykjavik has Friday\nAtlantic\/South_Georgia has Friday\nAtlantic\/St_Helena has Friday\nAtlantic\/Stanley has Friday\nAustralia\/Adelaide has Friday\nAustralia\/Brisbane has Friday\nAustralia\/Broken_Hill has Friday\nAustralia\/Darwin has Friday\nAustralia\/Eucla has Friday\nAustralia\/Hobart has Friday\nAustralia\/Lindeman has Friday\nAustralia\/Lord_Howe has Friday\nAustralia\/Melbourne has Friday\nAustralia\/Perth has Friday\nAustralia\/Sydney has Friday\nEurope\/Amsterdam has Friday\nEurope\/Andorra has Friday\nEurope\/Astrakhan has Friday\nEurope\/Athens has Friday\nEurope\/Belgrade has Friday\nEurope\/Berlin has Friday\nEurope\/Bratislava has Friday\nEurope\/Brussels has Friday\nEurope\/Bucharest has Friday\nEurope\/Budapest has Friday\nEurope\/Busingen has Friday\nEurope\/Chisinau has Friday\nEurope\/Copenhagen has Friday\nEurope\/Dublin has Friday\nEurope\/Gibraltar has Friday\nEurope\/Guernsey has Friday\nEurope\/Helsinki has Friday\nEurope\/Isle_of_Man has Friday\nEurope\/Istanbul has Friday\nEurope\/Jersey has Friday\nEurope\/Kaliningrad has Friday\nEurope\/Kiev has Friday\nEurope\/Kirov has Friday\nEurope\/Lisbon has Friday\nEurope\/Ljubljana has Friday\nEurope\/London has Friday\nEurope\/Luxembourg has Friday\nEurope\/Madrid has Friday\nEurope\/Malta has Friday\nEurope\/Mariehamn has Friday\nEurope\/Minsk has Friday\nEurope\/Monaco has Friday\nEurope\/Moscow has Friday\nEurope\/Oslo has Friday\nEurope\/Paris has Friday\nEurope\/Podgorica has Friday\nEurope\/Prague has Friday\nEurope\/Riga has Friday\nEurope\/Rome has Friday\nEurope\/Samara has Friday\nEurope\/San_Marino has Friday\nEurope\/Sarajevo has Friday\nEurope\/Saratov has Friday\nEurope\/Simferopol has Friday\nEurope\/Skopje has Friday\nEurope\/Sofia has Friday\nEurope\/Stockholm has Friday\nEurope\/Tallinn has Friday\nEurope\/Tirane has Friday\nEurope\/Ulyanovsk has Friday\nEurope\/Uzhgorod has Friday\nEurope\/Vaduz has Friday\nEurope\/Vatican has Friday\nEurope\/Vienna has Friday\nEurope\/Vilnius has Friday\nEurope\/Volgograd has Friday\nEurope\/Warsaw has Friday\nEurope\/Zagreb has Friday\nEurope\/Zaporozhye has Friday\nEurope\/Zurich has Friday\nIndian\/Antananarivo has Friday\nIndian\/Chagos has Friday\nIndian\/Christmas has Friday\nIndian\/Cocos has Friday\nIndian\/Comoro has Friday\nIndian\/Kerguelen has Friday\nIndian\/Mahe has Friday\nIndian\/Maldives has Friday\nIndian\/Mauritius has Friday\nIndian\/Mayotte has Friday\nIndian\/Reunion has Friday\nPacific\/Apia has Friday\nPacific\/Auckland has Friday\nPacific\/Bougainville has Friday\nPacific\/Chatham has Friday\nPacific\/Chuuk has Friday\nPacific\/Easter has Friday\nPacific\/Efate has Friday\nPacific\/Fakaofo has Friday\nPacific\/Fiji has Friday\nPacific\/Funafuti has Friday\nPacific\/Galapagos has Friday\nPacific\/Gambier has Friday\nPacific\/Guadalcanal has Friday\nPacific\/Guam has Friday\nPacific\/Honolulu has Friday\nPacific\/Kanton has Friday\nPacific\/Kiritimati has Friday\nPacific\/Kosrae has Friday\nPacific\/Kwajalein has Friday\nPacific\/Majuro has Friday\nPacific\/Marquesas has Friday\nPacific\/Midway has Friday\nPacific\/Nauru has Friday\nPacific\/Niue has Friday\nPacific\/Norfolk has Friday\nPacific\/Noumea has Friday\nPacific\/Pago_Pago has Friday\nPacific\/Palau has Friday\nPacific\/Pitcairn has Friday\nPacific\/Pohnpei has Friday\nPacific\/Port_Moresby has Friday\nPacific\/Rarotonga has Friday\nPacific\/Saipan has Friday\nPacific\/Tahiti has Friday\nPacific\/Tarawa has Friday\nPacific\/Tongatapu has Friday\nPacific\/Wake has Friday\nPacific\/Wallis has Friday\nUTC has Friday\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Verifying from cron<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;root@ip-172-31-87-173 ~]# crontab -l\n* * * * FRI echo \"Damn right it is Friday.\" &gt; can_you_believe_it\n0 0 * * SAT rm -f can_you_believe_it\n&#91;root@ip-172-31-87-173 ~]# cat can_you_believe_it\nDamn right it is Friday.\n&#91;root@ip-172-31-87-173 ~]#\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Verifying from a website<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;kedar@nitty-witty.com ~]$ curl -s -I  kedar.vaijanapurkar.in | grep date | cut -c7-9\nFri\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I&#8217;m open to more ideas as you know, doubters gonna doubt.<\/p>\n","protected":false},"excerpt":{"rendered":"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &#8220;Friday&#8221;, so much so that they cannot believe&hellip;\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4,8,377,378],"tags":[504,591,43,427,505,108,590,506],"class_list":["post-2612","post","type-post","status-publish","format-standard","category-just-for-fun","category-mysql","category-mysql-articles","category-mysql-scripts-mysql","tag-friday","tag-friday-proof","tag-fun","tag-mysql","tag-mysql8","tag-stored-procedure","tag-tgif","tag-with-recusive"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &quot;Friday&quot;, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Kedar\"\/>\n\t<meta name=\"google-site-verification\" content=\"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA\" \/>\n\t<meta name=\"msvalidate.01\" content=\"116B62074CBCA1BA99B8CCE09CCF2FB8\" \/>\n\t<meta name=\"keywords\" content=\"friday,friday proof,fun,mysql,mysql8,stored procedure,tgif,with recusive\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Change Is Inevitable | Kedar Vaijanapurkar&#039;s Blog for MySQL, technology and various subjects\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable\" \/>\n\t\t<meta property=\"og:description\" content=\"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &quot;Friday&quot;, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2022-09-24T11:50:04+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-05-20T13:57:14+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable\" \/>\n\t\t<meta name=\"twitter:description\" content=\"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &quot;Friday&quot;, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#article\",\"name\":\"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable\",\"headline\":\"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines\",\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#articleImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"},\"datePublished\":\"2022-09-24T11:50:04+00:00\",\"dateModified\":\"2023-05-20T13:57:14+00:00\",\"inLanguage\":\"en-US\",\"commentCount\":1,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#webpage\"},\"articleSection\":\"Just for fun, MySQL, MySQL-Articles, MySQL-Scripts, Friday, Friday Proof, fun, MySQL, mysql8, stored procedure, TGIF, WITH RECUSIVE\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"name\":\"MySQL-Articles\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"position\":3,\"name\":\"MySQL-Articles\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#listItem\",\"name\":\"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#listItem\",\"position\":4,\"name\":\"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-articles#listItem\",\"name\":\"MySQL-Articles\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#webpage\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants\",\"name\":\"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable\",\"description\":\"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a \\\"Friday\\\", so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/providing-friday-proofs-to-mysql-consultants#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"datePublished\":\"2022-09-24T11:50:04+00:00\",\"dateModified\":\"2023-05-20T13:57:14+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/\",\"name\":\"..::CHANGE is INEVITABLE::..\",\"description\":\"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable","description":"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a \"Friday\", so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to","canonical_url":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants","robots":"max-image-preview:large","keywords":"friday,friday proof,fun,mysql,mysql8,stored procedure,tgif,with recusive","webmasterTools":{"google-site-verification":"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA","msvalidate.01":"116B62074CBCA1BA99B8CCE09CCF2FB8","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#article","name":"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable","headline":"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines","author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"},"image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#articleImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"},"datePublished":"2022-09-24T11:50:04+00:00","dateModified":"2023-05-20T13:57:14+00:00","inLanguage":"en-US","commentCount":1,"mainEntityOfPage":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#webpage"},"isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#webpage"},"articleSection":"Just for fun, MySQL, MySQL-Articles, MySQL-Scripts, Friday, Friday Proof, fun, MySQL, mysql8, stored procedure, TGIF, WITH RECUSIVE"},{"@type":"BreadcrumbList","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/kedar.nitty-witty.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","position":2,"name":"MySQL","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","name":"MySQL-Articles"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","position":3,"name":"MySQL-Articles","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#listItem","name":"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#listItem","position":4,"name":"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines","previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles#listItem","name":"MySQL-Articles"}}]},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author","url":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"WebPage","@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#webpage","url":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants","name":"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable","description":"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a \"Friday\", so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants#breadcrumblist"},"author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"creator":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"datePublished":"2022-09-24T11:50:04+00:00","dateModified":"2023-05-20T13:57:14+00:00"},{"@type":"WebSite","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website","url":"https:\/\/kedar.nitty-witty.com\/blog\/","name":"..::CHANGE is INEVITABLE::..","description":"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","inLanguage":"en-US","publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"}}]},"og:locale":"en_US","og:site_name":"Change Is Inevitable | Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","og:type":"article","og:title":"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable","og:description":"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &quot;Friday&quot;, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to","og:url":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants","article:published_time":"2022-09-24T11:50:04+00:00","article:modified_time":"2023-05-20T13:57:14+00:00","twitter:card":"summary","twitter:title":"Providing Friday Proofs to MySQL Consultants | Scripts Functions Routines | Change Is Inevitable","twitter:description":"In the MySQL world, I am surrounded by some of the best database consultant, it brings them immense joy about having a &quot;Friday&quot;, so much so that they cannot believe that it actually is a Friday. Regardless of what they see on their watches and calendars, it becomes a crucial task of the day to"},"aioseo_meta_data":{"post_id":"2612","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":{"id":"aioseo-article-6385d28a3abad","slug":"article","graphName":"Article","label":"Article","properties":{"type":"BlogPosting","name":"#post_title","headline":"#post_title","description":"#post_excerpt","image":"","keywords":"","author":{"name":"#author_name","url":"#author_url"},"dates":{"include":true,"datePublished":"","dateModified":""}}},"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2022-09-24 11:29:39","updated":"2025-08-16 19:18:27","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\" title=\"MySQL\">MySQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles\" title=\"MySQL-Articles\">MySQL-Articles<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tProviding Friday Proofs to MySQL Consultants | Scripts Functions  Routines\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/kedar.nitty-witty.com\/blog"},{"label":"MySQL","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql"},{"label":"MySQL-Articles","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-articles"},{"label":"Providing Friday Proofs to MySQL Consultants | Scripts Functions  Routines","link":"https:\/\/kedar.nitty-witty.com\/blog\/providing-friday-proofs-to-mysql-consultants"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2612","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=2612"}],"version-history":[{"count":5,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2612\/revisions"}],"predecessor-version":[{"id":2905,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/2612\/revisions\/2905"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=2612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=2612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=2612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}