As we know, both the functions are used to search a string from the arguments provided in them but there are some significant differences between them as follows −FIND_IN_SET() −  function uses the string list that is itself a string containing the substring separated by commas. Whereas, FIELD() function contains ... Read More

In this case, it means we are providing an empty string as an argument to the ASCII() function. It will return 0 on providing empty string.Examplemysql> Select ASCII(''); +-----------+ | ASCII('') | +-----------+ |     0     | +-----------+ 1 row in set (0.00 sec)

As we know that GROUP BY clause in a SELECT statement can divide the result set, returned by MySQL, in groups. Now if we want to return only some specific groups then need to apply filtering criteria at the group level. It can be done by using HAVING clause inside ... Read More

A reserved word is a word that cannot be used as an identifier, such as the name of a variable, function, or label – it is "reserved from use". This is a syntactic definition, and a reserved word may have no meaning.There are a total of 95 reserved words in ... Read More

Internet Standards refer to all the documented requirements both in technology as well as methodology pertaining to the Internet. The standardization process has three steps. The documentation laid down in a step is called the maturity level. There were previously three maturity levels but are merged to form only two ... Read More

The constructor for the string class in python, ie, str can be used to convert a number to a string in python. For example, i = 10050 str_i = str(i) print(type(str_i))This will give the output:But if you want something that converts integers to words like 99 to ninety-nine, you have ... Read More

You can handle exception inside a Python for loop just like you would in a normal code block. This doesn't cause any issues. For example, for i in range(5):    try:       if i % 2 == 0:          raise ValueError("some error")       ... Read More

The dictionary consists of a number of buckets. Each of these buckets containsthe hash code of the object currently stored (that is not predictable from the position of the bucket due to the collision resolution strategy used)a pointer to the key objecta pointer to the value objectThis sums up to ... Read More

You can pretty print a dict in python using the pprint library. The pprint module provides a capability to “pretty-print” arbitrary Python data structures in a form which can be used as input to the interpreter. You can use it as followsExamplea = {    'bar': 22,    'foo': 45 ... Read More

You can convert Python dictionary keys/values to lowercase by simply iterating over them and creating a new dict from the keys and values. For example, def lower_dict(d):    new_dict = dict((k.lower(), v.lower()) for k, v in d.items())    return new_dict a = {'Foo': "Hello", 'Bar': "World"} print(lower_dict(a))This will give the ... Read More