mysql_json

mysql_json copied to clipboard

integer limited to 7 characters?

1

Exemple environnement: ``` CREATE TABLE `temp` ( `data` text, `index` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `temp` (`data`, `index`) VALUES ('{\"entry1\":\"string1\", \"entry2\":2232372}',1), ('{\"entry1\":\"string1\", \"entry2\":22323721}',1), ('{\"entry1\":\"string2\", \"entry2\":\"22323721\"}',1); ```...

alexalouit

add a function json_valid which returns true if the argument is valid json

1

I found that my queries were incomplete unless I could differentiate between an invalid object and an object that didn't have the property I was looking for. The code could...

db48x