Yes, you can use the LOWER() or LCASE() from MySQL to convert a string to lowercase. Both methods can be used to convert the string into lowercase.Here is the syntax of LOWER() −lower(‘yourStringValue);Or you can use LCASE().The syntax is as follows −lcase(‘yourStringValue);Let us see an example of LOWER(). The query is as follows −mysql> select lower('JOhN');Here is the output −+---------------+ | lower('JOhN') | +---------------+ | john | +---------------+ 1 row in set (0.00 sec)Let us see an example of LCASE(). The query is as follows −mysql> select lcase('JOhN');The following is the ... Read More

Whenever you retrieve datetime from a table, the datetime gives ‘YYYY-MM-DD’ format. If you want to change the output, then you need to use in-built date_format() from MySQL.The syntax is as follows −SELECT DATE_FORMAT(yourDatetimeColumnName, yourFormat) as anyVariableName from yourTableName;To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table UserDateFormat -> ( -> ProductId int, -> ProductDeliverDate datetime -> ); Query OK, 0 rows affected (0.93 sec)Insert some records in the table using insert command. The ... Read More

To create a HashMap, use the HashMap class −HashMap hm = new HashMap();Add elements to the HashMap in the form of key-value pair −hm.put("Bag", new Integer(1100)); hm.put("Wallet", new Integer(700)); hm.put("Belt", new Integer(600));The following is an example to create HashMap and add key-value pair −Example Live Demoimport java.util.*; public class Demo {    public static void main(String args[]) {       // Create a hash map       HashMap hm = new HashMap();       // Put elements to the map       hm.put("Bag", new Integer(1100));       hm.put("Wallet", new Integer(700));       hm.put("Belt", new Integer(600)); ... Read More

CDSL stands for Central Depository Services India Ltd and NSDL stands for National Securities Depository Ltd. Depository refers to an organization which holds the stocks of investors and shareholders. NSDL and CDSL are the two apex depositories in India. Just like banks take care of cash and deposits, they hold bonds, stocks etc for the shareholders in electronic form.Functioning of CDSL and NSDLWe need not send share certificates physically for transfers like in the old days, the NSDL and CDSL help to convert and hold shares in the Demat form. Since their establishment, we received huge contributions from both these ... Read More

The NavigableMap pollLastEntry() method remove and returns a key-value mapping associated with the greatest key in this map.Let us first create a NavigableMap and add some elements to it −NavigableMap n = new TreeMap(); n.put(5, "Tom"); n.put(9, "John"); n.put(14, "Jamie"); n.put(1, "Tim"); n.put(4, "Jackie"); n.put(15, "Kurt"); n.put(19, "Tiger"); n.put(24, "Jacob");Now, use the following method −n.pollLastEntry();The following is an example to implement the pollLastEntry() method −Example Live Demoimport java.util.*; public class Demo {    public static void main(String[] args) {       NavigableMap n = new TreeMap();       n.put(5, "Tom");       n.put(9, "John");       n.put(14, ... Read More

Technology is the application of scientific knowledge for practical purposes, especially in industry. It may be also called as the "advances in computer science.” This technology has actually tamed us. It was thought as a matrix allowing us to connect to the world. But, it has made us the lone ranger.Let Us Look at Some General Terms and FactsNomophobia: The feeling of not having cell phones with you, but still one feels that he carries a phone and this is called Nomophobia. Now, it happens with all of us! We feel that we own a phone every now and then.The ... Read More

Suppose the LIMIT is 4 and OFFSET is 6 then it will return the rows from 7 to 10 i.e. will end with row 10. The LIMIT 4 and OFFSET 6 returns row 7, 8, 9, 10.You can understand the above concept by implementing LIMIT and OFFSET. Let us create a table.mysql> create table LimitOffsettable -> ( -> Id int -> ); Query OK, 0 rows affected (0.60 sec)Let us insert some records in the table. The query is as follows −Mysql> insert into LimitOffsettable values(1); Query OK, 1 row affected ... Read More

In MySQL, there is no way to truncate with condition. You cannot use truncate statement with where clause.If you want the condition, use delete command −DELETE FROM yourTableName WHERE youCondition;The above syntax is fine but if you want a faster solution, then DELETE is not good in comparison to Truncate. The advantage with truncate is that it does not write to the logs.Let us create a table. The query to create a table is as follows −mysql> create table DeleteDemo -> ( -> Id int, -> Name varchar(100) ... Read More

To select data where a field has min value, you can use aggregate function min(). The syntax is as follows.SELECT *FROM yourTableName WHERE yourColumnName=(SELECT MIN(yourColumnName) FROM yourTableName);To understand the above syntax, let us create a table. The query to create a table is as follows.mysql> create table MinValueDemo -> ( -> ProductId int, -> ProductName varchar(100), -> ProductPrice int -> ); Query OK, 0 rows affected (0.77 sec)Insert some records in the table using insert command. The query is as follows.mysql> insert into MinValueDemo values(1, 'product-1', 4500); Query OK, 1 row affected (0.14 sec) mysql> insert into MinValueDemo values(2, ... Read More

The Crocodylidae, which includes the "true" crocodiles; the Alligatoridae, which includes the alligator and the caimans; and the Gavialidae, which contains only the gharial are the three groups of crocodilians. Crocodiles are large reptiles which are amphibians. They are found in Asia, Africa, America, and Australia. Alligators are also large reptiles of the family Alligatoridae, members of the order Crocodylia. Alligators are native to the United States and China only. Although these two species look similar, they are different in many ways.There are basically five characteristics with the help of which you can differentiate them from each other. So what ... Read More