SQL
Structured Query Language
-
How to find FK constraints rule in any schema in MySQL ?
constraints rule can be ‘RESTRICT’ OR ‘SET NULL’ OR ‘CASCADE’ SELECT distinct table_name FROM information_schema .referential_constraints WHERE constraint_schema = ‘<DB… Read More
-
ACID Properties
ACID Properties ACID properties are an important concept for databases or data sharing techniques. The acronym stands for Atomicity, Consistency,… Read More
-
How to compare 2 table structure in MySQL
Scenario 1: Following query displays whether the differences exists or not. SELECT IF(COUNT(1)>0,’Differences’,’No Differences’) Comparison FROM ( SELECT column_name,ordinal_position, data_type,column_type,COUNT(1)… Read More
-
How to move a column to first in mysql ?
Use the following query: ALTER TABLE table_name CHANGE COLUMN column_name column_name INTEGER NOT NULL AUTO_INCREMENT FIRST; INTEGER NOT NULL AUTO_INCREMENT… Read More
-
How to write a SQL JOIN query based on multiple condition ?
This is tricky to understand, Let me try to explain in simpler way. Here two tables are joining based on… Read More
Techiehints Software 