How to bind ip address in redis server

vim /etc/host

vim /etc/redis/redis.conf

change bind ip address propertiy in above files

How to add prefix to a number like (1=001)

String.format("%03d", yournumber);

example: 
System.out.println(String.format("%010d", 211))
output: 0000000211

How to make every first letter of word capitalize in mysql

CREATE FUNCTION CAP_FIRST(input VARCHAR(255))
RETURNS VARCHAR(255)
DETERMINISTIC
BEGIN
DECLARE len INT;
DECLARE i INT;
SET len   = CHAR_LENGTH(input);
SET input = LOWER(input);
SET i = 0;
WHILE (i < len) DO
IF (MID(input,i,1) = ‘ ‘ OR i = 0) THEN
IF (i < len) THEN
SET input = CONCAT(
LEFT(input,i),
UPPER(MID(input,i + 1,1)),
RIGHT(input,len – i – 1)
);
END IF;
END IF;
SET i = i + 1;
END WHILE;
RETURN input;
END;

 

——————————-

select CAP_FIRST(name) from college;

How to open pdf file in new window in JSF

<code>
<h:commandLink styleClass=”link-stock”
ajax=”false” immediate=”false” target=”_blank” >
<h:outputText value=”#{msg[‘pds.godownwisestock’]}” />

<p:fileDownload  contentDisposition=”inline” value=”#{applicationBean.downloadStockAsPDF}” />
</h:commandLink></code>

how to show and edit maximum number of connections in data base

mysql> SET GLOBAL max_connections = 5000;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW VARIABLES LIKE “max_connections”;
+—————–+——-+
| Variable_name | Value |
+—————–+——-+
| max_connections | 5000 |
+—————–+——-+
1 row in set (0.00 sec)

How to get Information Schema for process list

If we want to Get Full Information

select ID,USER,Time,host,db,COMMAND from INFORMATION_SCHEMA.PROCESSLIST where COMMAND = ‘Query’ and user=’dev’ and db=’prod_dump’;

(or )

show processlist;