Part 22- Function PostgreSQL
techsolution
August 10, 2021
Function is a set of SQL procedural commands like declarations, assignments, loops, flow-of-control etc. Function have return type and we...
Tuesday, August 10, 2021
Thursday, August 5, 2021
GET DENSE RANK WITHOUT RANK FUNCATION
techsolution
August 05, 2021
set @rownum1:=0; select AREA_ID , @rownum1:=(CASE WHEN (AREA_ID=@Tmax_18) THEN @rownum1+1 ELSE 1 END ) AS num1,(@Tmax_18:=AREA_ID) RANGE_SET...
Monday, August 2, 2021
Load data from mysql
techsolution
August 02, 2021
mysql --local-infile=1 -h localhost -u root -p -e "LOAD DATA INFILE '/var/lib/mysql-files/30daysFcst.csv' INTO TABLE MYDB.30...
Friday, July 30, 2021
2.Python Assignment : FOR LOOP
techsolution
July 30, 2021
Assignment : Program to print the table of the given number . list = [ 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 ] n = 5 for i in list: c...
Sunday, July 25, 2021
PYTHON EXERCISES FOR IF ELSE
techsolution
July 25, 2021
Q1: a = 10 b = "This is python" c = 10.5 print ( type (a)) print ( type (b)) print ( type (c)) Output <class 'int'>...
Saturday, July 24, 2021
SELinux | Enforcing | ls -Z | ps -efZ | restorecon |chcon |Permissive | Booleans | policy | getenforce | SELinux mode temporarily | SELinux policy details
techsolution
July 24, 2021
What is SELinux? It is a one type of security that enhances the security that allows users and administrators more control over which users ...
Configure step by step Nic card | nmap | tracepath | miitool | ifconfig in linux
techsolution
July 24, 2021
# setup (to setup the static network in RHEL - 2, 3, 4, 5 and 6) # nmtui (to setup the static network in GUI mode for RHEL - 7) # nmcli...
Network troubleshoot nmtui | setup | nmcli | dig | host | nslookup | ip route | netstat | hostname | ifconfig | ping
techsolution
July 24, 2021
Q:- How to troubleshoot if the network is not reaching? (i) First check the network cable is connected or not by # ethtool <NIC device...
How to configure bridging or teaming or bonding | TCP and UDP protocol | resolve.conf | /etc/hosts |nmap |run levels of linux
techsolution
July 24, 2021
From RHEL - 6 - What is bonding and how to configure bonding? From RHEL - 7 :- What is link aggregation or bridging or teaming and how to c...
Troubleshoot: Assign the static IP | Set the hostname temporarily and permanently | NIC is notworking
techsolution
July 24, 2021
Q1:-How to assign the static IP address to the NIC card? In RHEL - 6 : # setup (Move the cursor to Network configuration and press Enter key...
Sunday, July 18, 2021
Network | NIC card | Topology | Protocol | IP address | Network configuration | resolve.conf | /etc/hosts
techsolution
July 18, 2021
1.What is Network? Combination of two more computers connected together to share their resources each other by means of communication like c...
Sudo User | Sudo Permissions | Assign the password | who | lastb | lastreboot | df |du | history | find | last -x | w
techsolution
July 18, 2021
Sudo stands for either "substitute user do" or "super user do" (depending upon how you want to look at it). What sudo do...
APACHE VIRTUAL WEB HOSTING | REDIRECT WEBSITE | PORT BASED WEB HOSTING
techsolution
July 18, 2021
HOW TO CONFIGURE VIRTUAL WEB HOSTING [root@dev ~]# vi /etc/httpd/conf.d/ip.conf <VirtualHost 192.168.0.10:80> ServerAdmin root@d...
