You are here:   HomeJava Servlet
by Dinesh Thakur Category: Servlet with MySql Database

This function 'Like' (R%) will found the desired Criteria according to Condition.

In order to select rows that match a particular character pattern we use the LIKE operator. This character matching operation is called as wildcard search. The following symbols are used for matching the pattern % (percentage). This symbol represents any sequence of zero or more characters. _ (underscore) this symbol is used for any single character search. The % and _ symbols can be used in any combination with literal characters.

 
by Dinesh Thakur Category: Servlet with MySql Database

When a database is updated with each Statement object, by default, it will automatically commit the changes (permanently) to the database immediately. In general, to complete a transaction, it is required that one or more statements be executed. Thus, there are situations where a commit statement is needed after execution of more than one statement. In Java, the Connection object performs transaction control. The Connection object provides a method setAutoCommit (boolean value) to specify whether a transaction (or a set of transactions) should commit automatically or manually. By default, it is set to auto-commit mode. The syntax for this is the following:



 
by Dinesh Thakur Category: Servlet with MySql Database

This Function 'Date_Diff' will subtract the Two Dates.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function will convert each pair of hexadecimal digits to a character.

 
by Dinesh Thakur Category: Servlet with MySql Database

The Function 'DATE_FORMAT' will use to see the format of the date.

 
by Dinesh Thakur Category: Servlet with MySql Database

The function 'ASCII'(American standard code for interface and interchange) use to get the numeric value of left most character of a string.

 
by Dinesh Thakur Category: Servlet with MySql Database

ODBC (open database connectivity) is an open specification given by x-open company that contains a set of rules and guidelines to develop ODBC drivers for different.



 
by Dinesh Thakur Category: Servlet with MySql Database

The Function 'COALESCE' will show the first non-NULL arguments.

 
by Dinesh Thakur Category: Servlet with MySql Database

This function 'ELT' will return the String at index Number.

 
by Dinesh Thakur Category: Servlet with MySql Database

This Function Will Return the substring as specified.

 

Page 6 of 24

What's New and Popular





Search Content







Advance Courses



Basic Courses



Advertise with Us