Member Avatar for elanch

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

  • 3 Contributors
  • 2 Replies
  • 86 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by QVeen72
Member Avatar for selvaganapathy

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.

Member Avatar for QVeen72

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.