As we know that certain objects within MySQL are known as identifiers. These objects include a database, table, index, column, alias, view, stored procedure, partition, tablespace etc. Identifiers are stored using Unicode (UTF-8). The maximum length of each type of identifier is given in the following table:Sr. No.IdentifierMaximum Length (characters)1Database642Table643Column644Index645Constraint646Stored ... Read More

You can understand it using an example where a Boss class is defined in payroll package.package payroll; public class Boss {    public void payEmployee(Employee e) {       e.mailCheck();    } }if the Employee class is not in the payroll package? The Boss class must then use one ... Read More

MySQL exact-value arithmetic can handle overflow occurs during numerical expression assessment because overflow occurs depends on the range of the operands. The values used in arithmetic expressions changed to other data type can put away the overflow.For example, after converting the BIGINT Maximum value to DECIMAL while adding 1 to ... Read More

Cross-origin resource sharing (CORS) is a mechanism to allows the restricted resources from another domain in a web browserFor suppose, if you click on HTML5- video player in html5 demo sections. it will ask camera permission. if user allows the permission then only it will open the camera or else ... Read More

You can try to run the following code to detect a web worker feature available in a web browser:           Big for loop                      function myFunction(){             if (Modernizr.webworkers) ... Read More

Some characters are reserved in HTML and they have special meaning when used in HTML document. For example, you cannot use the greater than and less than signs or angle brackets within your HTML text because the browser will treat them differently and will try to draw a meaning related ... Read More

To allow HTML5 input type = ”number” to accept dashes, use a regular expression.Add the regular expression in the pattern attribute as shown below.[ 0 - 9 ] + ([ - \, ] [0 - 9] + ) ? "Add it to the code now:input type = "text" pattern = ... Read More

To filter search results, use the element. The header should be in the section of the search results:    Search results                                                                      

You can go for using either NULLIF or COALESCE function to serve your requirement.NULLIF (expression, expression"): This function will return the same type whatever is specified as the first expression.Basically, NULLIF returnsThe first expression if the two expressions are not equal.NULL of type of first expressions if the expressions are ... Read More

You can use a SWITCH CASE statement to handle your scenario. This is a good choice if you know well in advance what all properties are required and what is not required. Also, it will let you to unit test your code.Otherwise, you can go for a collection like a ... Read More