4-Index Maintenance
techsolution
April 08, 2022
Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts
Friday, April 8, 2022
2-Hash-index
techsolution
April 08, 2022
Index High Strategies for high Performance
Part 3: Point in Time Recovery in MySQL
techsolution
April 08, 2022
Frequency & Location & Copy Data one server to other Server & Best time of Day for Backup & Restore
Part 2: Script for Backup & Restore in MySQL
techsolution
April 08, 2022
Part 3 MySQL Point in Time Recovery
Part 1: MySQL Backup & Recovery Fundamental
techsolution
April 08, 2022
Part 2 :Script for Backup & Restore in MySQL
Part 2 : Query_Optimization Performance Tuning in MySQL
techsolution
April 08, 2022
Part 3 Query_Optimization Performance Tuning in MySQL
Part 1 : Query_Optimization in MySQL
techsolution
April 08, 2022
Part 2 : Query_Optimization Performance Tuning in MySQL
How to configure MY.CNF file in MySQL
techsolution
April 08, 2022
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock #pid-file=/db/mysql/mysql.pid innodb_file_per_table=1 innodb_flush_method=...
Wednesday, February 9, 2022
MYSQL CHEET SHEET FOR INTERVIEWS
techsolution
February 09, 2022
STRING FUNCTION : SELECT CONCAT('MySQL','CONCAT'); select length('MYSQL'); : 5 select left('MYSQL',2);...
Monday, October 25, 2021
SQL Query and concept Interview question and answer
techsolution
October 25, 2021
Q: What is Normalization. Ans. Normalization is a database design technique to remove redundant data. Example :Dept table : Id First nam...
Saturday, September 25, 2021
Mysql funcation
techsolution
September 25, 2021
How to create function in mysql many examples DELIMITER $$ CREATE DEFINER=`skyaws`@`%` FUNCTION `calRh1730ForDS`(_data_date DATE,_stationI...
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...
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...
Sunday, January 24, 2021
How to add primary or unique and foreign key in mysql
techsolution
January 24, 2021
1. Primary Key : #insert uniqe value CREATE TABLE STATION (ID INT ,STATION_NAME varchar(11),DATA_DATE DATETIME,PRIMARY KEY (ID)); #uniqe v...
Wednesday, January 13, 2021
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...
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 ...
