Pivot the table in mysql using case
techsolution
January 13, 2021
Table without Pivot : SELECT STATION_V1.ID, STATION_V1.STATE, STATION_V1.DISTRICT, STATION_V1.TEHSIL, STATION_V1.STAT...
Wednesday, January 13, 2021
Saturday, January 9, 2021
ERROR 1264: Out of range value for column 'SOLAR_MAX' at row 1
techsolution
January 09, 2021
UPDATE `aws`.`STATION_DATA` SET `SOLAR_MAX`='1500' WHERE `STATION_DATA_ID`='142' ERROR 1264: 1264: Out of range value for ...
Thursday, January 7, 2021
Error Code: 1452. Cannot add or update a child row: a foreign key constraint fails
techsolution
January 07, 2021
16:17:41 alter table company_station_mapping add constraint FK_COMPANY_STATION_MAPPING_15 FOREIGN KEY (COMPANY_ID) REFERENCES `COMPA...
Wednesday, January 6, 2021
If I shutdown Linux server which run level it will go ?
techsolution
January 06, 2021
If I shutdown Linux server which run level it will go r un level 5 (that mean Power-down state) . root@server#shutdown To shut down the ...
Tuesday, January 5, 2021
Fetch single record from table in mysql
techsolution
January 05, 2021
if you want to fetch record single record from table . STATION_ID DATE_TIME TEMP 1 2020-01-01 00:00:00 ...
Monday, January 4, 2021
MySQL INSERT ON DUPLICATE KEY UPDATE
techsolution
January 04, 2021
INSERT INTO PAYOUT_DATA (STATION_ID ,DATA_DATE ,MIN_TEMP ,MAX_TEMP ,RAIN ,MIN_RH ,MAX_RH ,MAX_WIND) -- VALUES ( select STATION_ID ,...
Tuesday, December 29, 2020
DROP KEY CONSTRAINT IN MYSQL
techsolution
December 29, 2020
Step1 : Firstly you have to take backup current table . create table tb_old like tb_new insert into tb_new select * from tb_old Step2: # ren...
Thursday, December 24, 2020
Shell script for take daily backup in linux
techsolution
December 24, 2020
I want to take database backup daily so i will write shell script for take daily backup of database user="******" pwd="****...
Friday, December 11, 2020
CSV FILE IMPORT AND EXPORT IN MYSQL TABLE USING SHEEL SCRIPT
techsolution
December 11, 2020
I want to import csv file from database using shell script or send mail to receivers #!/bin/bash user='#####' pwd='$$$$$$...
Thursday, November 12, 2020
ssh login proble give error System is booting up. Unprivileged users are not permitted to log in yet
techsolution
November 12, 2020
ssh login problem : I am try taking remote machine but show error like that . "System is booting up. Unprivileged users are not permit...
Saturday, October 31, 2020
Docker
techsolution
October 31, 2020
[root@dev ~]#yum install docker Installed: docker.x86_64 2:1.13.1-162.git64e9980.el7.centos [root@dev ~]# systemctl start do...
Monday, October 5, 2020
MySQL Cursors
techsolution
October 05, 2020
delimiter $$ create procedure sp_emp_details(id int ) begin declare emp_name varchar(20); declare cur1 cursor for select concat(firstname,...
Saturday, October 3, 2020
TRIGGER IN MYSQL
techsolution
October 03, 2020
CREATE TABLE 1 : MYSQL> CREATE TABLE STATION (ID int , STATION_NAME VARCHAR(20),UPDATE_USER VARCHAR(20)); CREATE TABLE 2 : ...
