{"id":120,"date":"2006-01-06T19:10:32","date_gmt":"2006-01-06T13:40:32","guid":{"rendered":"http:\/\/chiragmehta.info\/chirag\/2006\/01\/06\/important-sql-commands-for-2006\/"},"modified":"2006-01-06T19:10:32","modified_gmt":"2006-01-06T13:40:32","slug":"important-sql-commands-for-2006","status":"publish","type":"post","link":"https:\/\/www.chiragmehta.info\/chirag\/2006\/01\/06\/important-sql-commands-for-2006\/","title":{"rendered":"IMPORTANT SQL commands for 2006"},"content":{"rendered":"<p><em>Ack : ~ Manoj Patel<\/em><\/p>\n<p>SELECT  happiness,  prosperity  FROM    life  WHERE  year >=    2006 ;    <\/p>\n<p>UPDATE    life    SET    failure_flag = &#8220;NO&#8221; ,  success_flag = &#8220;YES&#8221;;<br \/>\nINSERT  INTO  life  VALUES  (&#8220;friends&#8221;,&#8221;dreams&#8221;) ;<br \/>\nDELETE    sorrows  FROM    life;<br \/>\nGRANT    smile  TO    all ;<br \/>\nREVOKE  enemity  FROM  all;<br \/>\nALTER  TABLE  life  ADD  dreams  CHAR(INFINITY);<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ack : ~ Manoj Patel SELECT happiness, prosperity FROM life WHERE year >= 2006 ; UPDATE life SET failure_flag = &#8220;NO&#8221; , success_flag = &#8220;YES&#8221;; INSERT INTO life VALUES (&#8220;friends&#8221;,&#8221;dreams&#8221;) ; DELETE sorrows FROM life; GRANT smile TO all ; REVOKE enemity FROM all; ALTER TABLE life ADD dreams CHAR(INFINITY);<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[4],"class_list":["post-120","post","type-post","status-publish","format-standard","hentry","tag-fun","post-preview"],"_links":{"self":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":0,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}