Setting Up DELETE Example
Create and populate table(s) to use in subsequent example(s).
CREATE TABLE my_table (eno INTEGER, edata JSON(100));
INSERT INTO my_table(1, '{"name":"Cameron","age":24}');
Example: Using DELETE Statement
Selectively delete data that meets the criteria.
DELETE my_table WHERE CAST (edata.JSONExtractValue('$.age') AS INTEGER) = 24;
To see the result of the DELETE, run: SELECT * FROM my_table;
*** No rows found
Setting Up ABORT Example
Create and populate table(s) to use in subsequent example(s).
CREATE TABLE my_table (eno INTEGER, edata JSON(100));
INSERT INTO my_table(1, '{"name":"Cameron","age":24}');
Example: Using ABORT Statement
Abort on a portion of the JSON instance.
ABORT 'JSON Abort'
FROM my_table
WHERE CAST (edata.JSONExtractValue('$.age') AS INTEGER) = 24;
Result:
*** Failure 3513 JSON Abort.