MySQL provides us with a bunch of functions and operators that allow us to search JSON documents for various things, such as specific values, paths, keys, etc.
Here are seven functions and three operators that search JSON documents in MySQL.
Continue readingIf you get an error that reads “WRONGTYPE Operation against a key holding the wrong kind of value” when using the ZCOUNT command in Redis, it’s probably because you’re passing a key with the wrong data type.
To fix this issue, be sure that the key you pass to the ZCOUNT command holds a sorted set.
If you’re getting error Msg 6855 in SQL Server that reads “Inline schema is not supported with FOR XML PATH“, it’s because you’re trying to add an inline schema to an XML document that you’re generating using PATH mode with the FOR XML clause.
As the message alludes to, PATH mode doesn’t support the ability to create an inline schema when using the FOR XML clause.
To fix this issue, either use a different mode to generate the XML with an inline schema (specifically, use either AUTO or RAW mode), or don’t generate an inline schema at all.
If you’re getting SQL Server error Msg 529 that reads something like Explicit conversion from data type int to date is not allowed, it’s because you’re trying to perform an explicit data type conversion that’s not permitted.
SQL Server doesn’t allow certain conversions. If you try to perform such a conversion, you’ll get this error.
Continue readingMySQL provides us with a bunch of functions that can modify JSON values. Here are ten functions that we can use to modify JSON values in MySQL.
Continue readingIn MySQL, we have several options when it comes to extracting data from JSON documents. Below are six methods we can use to do this.
Continue readingIn SQL Server, we can use the sp_sequence_get_range stored procedure to generate a range of sequence numbers from a sequence object.
If you get an error that reads “WRONGTYPE Operation against a key holding the wrong kind of value” when using the ZADD command in Redis, it’s probably because you’re trying to update a key that contains the wrong data type.
To fix this issue, be sure to only use the ZADD command against sorted sets if the key already exists. If the key doesn’t already exist, then you shouldn’t get this error.
MySQL includes some inbuilt functions that can be used to create JSON values, such as JSON arrays, JSON objects, or a quoted string literal.
Here are seven functions that allow us to create JSON values in MySQL.
Continue readingOne common use case for sequences in SQL Server is to use them to number the results of a query. For example, we can add a column that has a number that increments with each row, similar to a row counter (but with a sequence that we define).
Continue reading