Let us first create a −mysql> create table DemoTable1418    -> (    -> EmployeeCode text    -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert −mysql> insert into DemoTable1418 values('EMP-2110/Carol'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1418 values('EMP-1900/David'); ... Read More

To order, use ORDER BY and to fetch only the 2nd ordered record, use MySQL LIMIT and set offset as well. Let us first create a −mysql> create table DemoTable1417    -> (    -> CustomerId int NOT NULL AUTO_INCREMENT PRIMARY KEY,    -> CustomerName varchar(20),    -> ShippingDate date ... Read More

For this, you can use SUBSTRING_INDEX(). Let us first create a −mysql> create table DemoTable1416    -> (    -> StudentCode varchar(100)    -> ); Query OK, 0 rows affected (1.56 sec)Insert some records in the table using insert −mysql> insert into DemoTable1416 values('101/John/Smith'); Query OK, 1 row affected (0.13 ... Read More

For this, use EXTRACT(), that would allow you to extract specific month records. For example, to add all the prices in January (irrespective of the year).Let us first create a −mysql> create table DemoTable1415    -> (    -> ProductPurchaseDate date,    -> ProductPrice int    -> ); Query OK, ... Read More

For this, use MySQL MIN(). Let us first create a −mysql> create table DemoTable1414    -> (    -> BookTitle varchar(40),    -> BookPrice int    -> ); Query OK, 0 rows affected (0.82 sec)Insert some records in the table using insert −mysql> insert into DemoTable1414 values('Deep dive using java', ... Read More

The fastest and easiest way is to use the MySQL BETWEEN keyword. Let us first create a −mysql> create table DemoTable1413    -> (    -> EmployeeName varchar(20),    -> EmployeeJoiningDate datetime    -> ); Query OK, 0 rows affected (0.45 sec)Insert some records in the table using insert −mysql> ... Read More

For this, use Regular Expression in MySQL as in the below syntax −select * from yourTableName where yourColumnName regexp '^[^ ]+[ ]+[^ ]+$';The above query will work when the two words are separated by a space. Let us first create a −mysql> create table DemoTable1412    -> (    -> ... Read More

For this, use FIND_IN_SET() in MySQL and use the value from a custom variable. Let us first create a −mysql> create table DemoTable1411    -> (    -> Value int    -> )    -> ; Query OK, 0 rows affected (0.50 sec)Insert some records in the table using insert ... Read More

To mask data fields, use CONCAT() along with REPEAT(). Here, we will mask data fields with #. Let us first create a −mysql> create table DemoTable1410    -> (    -> Password varchar(80)    -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert ... Read More

The event.namespace property in jQuery is used to return the custom namespace when the event was triggered.SyntaxThe syntax is as follows −event.namespaceExampleLet us now see an example to implement the jQuery event.namespace property −    $(document).ready(function(){       $("p").on("custom.demoNamespace", function(event){          alert(event.namespace); ... Read More