Mysql funcation
techsolution
September 25, 2021
How to create function in mysql many examples DELIMITER $$ CREATE DEFINER=`skyaws`@`%` FUNCTION `calRh1730ForDS`(_data_date DATE,_stationI...
Saturday, September 25, 2021
Monday, September 20, 2021
Which command help us to find the used commands in Linux system?
techsolution
September 20, 2021
HISOTRY Command In linux there is a very useful command to show that have been recently used. The command is simply called history, In o...
Thursday, September 16, 2021
Part-19 Data Types :- UUID | JSON | HSTORE | ARRAY | User-defined
techsolution
September 16, 2021
UUID: value is 128-bit quantity generated by an algorithm that make it unique it relies on the third-party modules It is specific algorithm...
Sunday, September 12, 2021
Part 1 : CREATE TABLE DECLARE VARIABLE & Alter table IN POSTGRES
techsolution
September 12, 2021
CREATE TABLE public.aic_user_mapping ( id integer NOT NULL DEFAULT nextval('aic_user_mapping_id_seq'::regclass), user_id integer...
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...
Wednesday, August 25, 2021
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...
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 ...
Tuesday, August 24, 2021
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_...
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...
Sunday, August 15, 2021
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...
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...
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...
Wednesday, August 11, 2021
checkDiskSpace.sh
techsolution
August 11, 2021
#!/bin/bash EMAIL="italerts@skymetweather.com" "rajish.nair@skymetweather.com" "abhay.pandey@skymetweather.com...
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...
techsolution
August 11, 2021
#!/bin/bash user='db_user' pwd1='DBA%$#321' start_date=$(date +"%Y-%m-%d") end_date=$(date +"%Y-%m-%d") ...
CheckDiskSpace
techsolution
August 11, 2021
#!/bin/bash EMAIL="italerts@skymetweather.com" "rajish.nair@skymetweather.com" "abhay.pandey@skymetweather.com...
