How to Use 1=1 & 1=2 in SQL Query

Learn about the risks and techniques of using "1=1" and "1=2" in SQL queries. Explore how these conditions are exploited in SQL injection attacks, understanding the difference between true and false logical conditions.

Query and Description

SELECT *
INTO EMP_COPY
FROM emp
WHERE 1=1;

Description

This query will create the same table with data.

SELECT *
INTO EMP_COPY_2
FROM emp
WHERE 1=2;

Description

This query will create the same table without data.