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... Read More
ERROR 1264: Out of range value for column 'SOLAR_MAX' at row 1 techsolution January 09, 2021UPDATE `aws`.`STATION_DATA` SET `SOLAR_MAX`='1500' WHERE `STATION_DATA_ID`='142' ERROR 1264: 1264: Out of range value for ... Read More
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... Read More
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 ... Read More
Fetch single record from table in mysql techsolution January 05, 2021if you want to fetch record single record from table . STATION_ID DATE_TIME TEMP 1 2020-01-01 00:00:00 ... Read More
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 ,... Read More
DROP KEY CONSTRAINT IN MYSQL techsolution December 29, 2020Step1 : 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... Read More
Shell script for take daily backup in linux techsolution December 24, 2020I want to take database backup daily so i will write shell script for take daily backup of database user="******" pwd="****... Read More
CSV FILE IMPORT AND EXPORT IN MYSQL TABLE USING SHEEL SCRIPT techsolution December 11, 2020I want to import csv file from database using shell script or send mail to receivers #!/bin/bash user='#####' pwd='$$$$$$... Read More
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... Read More
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... Read More
MySQL Cursors techsolution October 05, 2020delimiter $$ create procedure sp_emp_details(id int ) begin declare emp_name varchar(20); declare cur1 cursor for select concat(firstname,... Read More
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 : ... Read More