In C++ the scope resolution operator i.e. :: is used for global variables, whereas in C# it is related to namespaces.If you have a type that share an identifier in different namespace, then to identify them use the scope resolution operator.For example, to reference System.Console class, use the global namespace ... Read More

To find the count of elements of Hashtable class, use the Count property. Firstly, set the Hashtable class with elements −Hashtable ht = new Hashtable(); ht.Add("One", "Tom"); ht.Add("Two", "Jack"); ht.Add("Three", "Peter"); ht.Add("Four", "Russel"); ht.Add("Five", "Brad"); ht.Add("Six", "Bradley"); ht.Add("Seven", "Steve"); ht.Add("Eight", "David");Now, count the number of elements using the Count ... Read More

When QUOTE() function used with WHERE clause then the output depends upon the comparison values returned by WHERE clause. Following example will exhibit it −Examplemysql> Select Name, ID, QUOTE(Subject)AS Subject from Student WHERE Subject = 'History'; +-------+------+-----------+ | Name  | ID   | Subject   | +-------+------+-----------+ | Aarav ... Read More

Actually for using MySQL TRIM() function we must have to know the string which we want to trim from the original string. This becomes the major drawback of TRIM() in the cases where we want to trim the strings having different values. For example, suppose we want to get the ... Read More

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

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