{"id":313,"date":"2018-03-24T04:28:15","date_gmt":"2018-03-23T22:28:15","guid":{"rendered":"https:\/\/mcqacademy.com\/en\/mcq\/to-update-a-table-using-a-where-clause-wed-write-update-table-set-columnnew-value-where-column-is-not-null\/"},"modified":"2018-03-24T04:28:15","modified_gmt":"2018-03-23T22:28:15","slug":"to-update-a-table-using-a-where-clause-wed-write-update-table-set-columnnew-value-where-column-is-not-null","status":"publish","type":"mcq","link":"https:\/\/mcqacademy.com\/en\/mcq\/to-update-a-table-using-a-where-clause-wed-write-update-table-set-columnnew-value-where-column-is-not-null\/","title":{"rendered":"To update a table using a WHERE clause, we&#8217;d write:  UPDATE table SET column=&#8217;New Value&#8217; WHERE column IS NOT NULL"},"content":{"rendered":"<p>To update a table using a WHERE clause, we&#8217;d write: <code>UPDATE table SET column='New Value' WHERE column IS NOT NULL<\/code><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","topic":[142],"subject":[26],"education_level":[],"class_list":["post-313","mcq","type-mcq","status-publish","hentry","topic-mysql","subject-dbms"],"mcq_note":"To update a table using a WHERE clause, we'd write: <code>UPDATE table SET column='New Value' WHERE column IS NOT NULL<\/code> is correct syntax.","mcq_options":[{"right":"yes","answer":"ture"},{"right":"no","answer":"false"}],"multi_answers":"no","subject_terms":[{"id":26,"title":"Database Management System","slug":"dbms"}],"topic_terms":[{"id":142,"title":"MySQL","slug":"mysql"}],"_links":{"self":[{"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/mcq\/313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/mcq"}],"about":[{"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/types\/mcq"}],"author":[{"embeddable":true,"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/comments?post=313"}],"wp:attachment":[{"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/media?parent=313"}],"wp:term":[{"taxonomy":"topic","embeddable":true,"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/topic?post=313"},{"taxonomy":"subject","embeddable":true,"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/subject?post=313"},{"taxonomy":"education_level","embeddable":true,"href":"https:\/\/mcqacademy.com\/en\/wp-json\/wp\/v2\/education_level?post=313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}