Hi all!
Can any one explain what is the purpose of
WHERE 1=2"
What the statement means. in below code?
query = "SELECT * FROM project WHERE 1=2"
Thanks in advance
Regards,
Elanch
elanch
0
Newbie Poster
Recommended Answers
Jump to PostHi,
This WHERE 1 = 2 is probably using for Copying the Structure of the Table into another one. That is creating a new table by the existing table without copying the records. because the condition 1 = 2 is always false.
All 2 Replies
selvaganapathy
31
Posting Pro
Hi,
This WHERE 1 = 2 is probably using for Copying the Structure of the Table into another one. That is creating a new table by the existing table without copying the records. because the condition 1 = 2 is always false.
QVeen72
104
Posting Shark
Hi,
It is basically used to Open Recordset / Or Get the Table Structure without any Records.. As when 1 will never be equal to 2, No Records are retireived.. but you get the table structure..
Regards
Veena
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.