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

In order to see the data from the table the most common type of SQL statement executed in most database environments is the query, or SELECT statement. Select statements retrieval requests data from tables in a database. You can issue a simple SELECT statement that is designed to retrieve all data from the table.



 
by Dinesh Thakur Category: Servlet with MySql Database

The JDBC specification related API in the form of java.sql package.



 
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

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

This function will show to the result according to Where Query in mysql.

 
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

This Function Will Return the substring as specified.

 
by Dinesh Thakur Category: Servlet with MySql Database

The Function 'DATE_SUB' will subtract the date with required Interval.

 
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.

 

Page 6 of 24



About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.