“use strict” directive enables a strict operating context/mode for the code. This helps us to identify potential exceptions and makes debugging easier. In strict mode, we are notified about code that would trigger some weird behavior or fail silently. To enable the strict mode for the whole script, add the string “use strict” at the top of the script.
Remove items from a list. We can provide a
Change/replace value at a specific index of a list. For the command to work there should be an existing list, with some items and we can only change items that are already set(have an index). Both positive and negative indexes will work for this command. Index is zero(0) based. So the first item is considered at index Zero(0).
LPOP removes the first element from the Left/HEAD of the list and then returns it. Count is an optional argument provided for the command, this is used to pop multiple items. If the list has no element left after executing the LPOP command, then the list is deleted after the item(s) popped.
LMPOP command pops one or more items from list(s). This operation can be performed on multiple lists. In case of multiple lists, the pop operation will be performed on the first non-empty list. This command is useful when we have multiple lists serving similar purposes, and we want to pop items from any of the lists if there are items in it.
Get the index of item(s) in the list, which matches the provided item. Operation can be performed starting from the HEAD or from the TAIL. This command is useful for checking the position/index of an item in the list, and also useful for checking the existence of an item in the list. Index of the list item is Zero based. The first item is at index Zero(0). If the command does not return (nil). Instead, return some index value (can be zero) which means the item exists in the list.
JSON data type is introduced in MySQL 5.7.8. Here are the methods we can use to create/modify/search JSON type columns in MySQL.
Insert an element in the list, before or after a specific element. This command does not insert an element at a specific position/index of the list. It searches for the reference element(pivot), and after the pivot element is found then the new element is inserted before/after that specific element. So finding the pivot element is important. If the pivot/reference is not found then the command fails.
Get the length of a list. We get zero as a result for a non-existing list and an exception is thrown for a wrong data type.
Get an element from a list at a specific index. Time complexity of this command is O(N). Here N is the number of items that we have to go through to get the specified index. In the case of positive indexing, the counting starts from the HEAD/Left. In the case of negative indexing, the counting starts from the TAIL/Right end.