Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- TEXT: no validation, no path queries CREATE TABLE log1 (data TEXT); INSERT INTO log1 VALUES ('not valid json'); -- works! -- JSON: validated at insert CREATE TABLE log2 (data JSON); INSERT INTO log2 VALUES ('not valid json'); -- ERROR
Result
Open