{"id":887,"date":"2011-03-28T21:12:07","date_gmt":"2011-03-29T02:12:07","guid":{"rendered":"http:\/\/www.dpriver.com\/blog\/?page_id=887"},"modified":"2011-03-28T21:12:22","modified_gmt":"2011-03-29T02:12:22","slug":"decoding-sql-grammar-%e2%80%94-delete-statement","status":"publish","type":"page","link":"https:\/\/www.dpriver.com\/blog\/list-of-demos-illustrate-how-to-use-general-sql-parser\/decoding-sql-grammar-%e2%80%94-delete-statement\/","title":{"rendered":"Decoding SQL grammar \u2014 delete statement"},"content":{"rendered":"

This demo helps you fully take advantage of the general SQL parser to decode SQL grammar of delete SQL statement.<\/p>\n

Take this SQL for example:<\/p>\n

    \r\ndelete from department\r\nwhere department_name = 'Finance';\r\n<\/pre>\nSQL elements in delete statement decoded by this demo:<\/p>\n\r\ntable: department\r\nwhere clause: department_name = 'Finance'\r\n<\/pre>\nDownload this demo: C# version<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"This demo helps you fully take advantage of the general SQL parser to decode SQL grammar of delete SQL statement. Take this SQL for example: delete from department where department_name = ‘Finance’; SQL elements in delete statement decoded by this demo: table: department where clause: department_name = ‘Finance’ Download this demo: C# version<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":235,"menu_order":130,"comment_status":"closed","ping_status":"open","template":"gsp_feature_page_tt.php","meta":[],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":5}},"yoast_head":"\nHelp you to make better use of General SQL Parser<\/title>\n\n\n\n\n\n\n\n\n\n\n\n