linuxlove

Wednesday, September 8, 2021

Part2 :DATE | TIME | ZONE | ADD INTERVAL |EXTRACT HOUR | TIME Data | MINUTE IN POSTGRES

techsolution September 08, 2021

Date : When we are used Date data type it is take 4 byte to store date value .It can mange lowest and highest data date . Example: (a) TI...

mysql

DUPLICATE KEY UPDATE IN MYSQL

techsolution August 25, 2021

Ex: we want to insert in table after delete some data but again insert data in table it is give error duplicate key error . insert ignore e...

postgres

PL/pgSQL in postgres

techsolution August 25, 2021

Declare Variable Q1:- do $$ declare num1 integer:=96; num2 integer:=100; num3 integer; begin num3 = num1 + num2; raise ...

postgres

Part-22 Data Types : CHAR | VARCHAR | TEXT | NUMERIC | NaN | Integer | SERIAL (Auto-increment)

techsolution August 24, 2021

Boolen Type : When we required only single bite data like true or false so we can use 0 for false and 1 true . Ex:1 #create table stock_...

postgres

pl/sql Basic Syntax

techsolution August 24, 2021

Q1: Print simple message do $$ declare message varchar(100):='This is my life'; begin raise notice 'The number of fil...

mysql

MYSQL TABLE

techsolution August 15, 2021

CREATE TABLE `station_v1` ( `ID` int(11) unsigned NOT NULL AUTO_INCREMENT, `IMEI` varchar(55) NOT NULL, `BARCODE` varchar(55) NOT NUL...

postgres

Part 23 : VIEW PostgreSQL

techsolution August 15, 2021

Ex:1 CREATE OR REPLACE VIEW public.geography_columns AS SELECT current_database() AS f_table_catalog, n.nspname AS f_table_schema, c.rel...

postgres

CREATE TABLE | INSERT DATA | VIEW

techsolution August 15, 2021

Ex: - CREATE TABLE public.airports ( latitude double precision, longitude double precision, max double precision, min double precis...

Shell Script

checkDiskSpace.sh

techsolution August 11, 2021

#!/bin/bash EMAIL="italerts@skymetweather.com" "rajish.nair@skymetweather.com" "abhay.pandey@skymetweather.com...

Shell Script

checkCPU.sh

techsolution August 11, 2021

#!/bin/sh processToSeek=$1 EMAIL="italerts@skymetweather.com" MAX=90; DURATION=60 cnt=0; total=0; i=0; initTime=`date +%s` proces...

Shell Script

mail

techsolution August 11, 2021

#!/bin/bash user='db_user' pwd1='DBA%$#321' start_date=$(date +"%Y-%m-%d") end_date=$(date +"%Y-%m-%d") ...

Shell Script

CheckDiskSpace

techsolution August 11, 2021

#!/bin/bash EMAIL="italerts@skymetweather.com" "rajish.nair@skymetweather.com" "abhay.pandey@skymetweather.com...

Tuesday, August 10, 2021

postgres

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...

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...

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...

Python

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...

Python

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'>...

Linux

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 ...

Wednesday, September 8, 2021

Wednesday, August 25, 2021

Tuesday, August 24, 2021

Sunday, August 15, 2021

Wednesday, August 11, 2021

Tuesday, August 10, 2021

Thursday, August 5, 2021

Monday, August 2, 2021

Friday, July 30, 2021

Sunday, July 25, 2021

Saturday, July 24, 2021

About Me

Labels

Contact Form

Search This Blog

Blog Archive

Ad Code

Recent Posts

Pages

Labels

BTemplates.com

linux lover is provide real world problem solution

Recent

Popular

Comments

Follow Us

Subscribe Us

Facebook