This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

what is the meaning of "1=1" in sql statement

 
Nakata kokuyo
Ranch Hand
Posts: 467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi, expert here , can someone pls explain what is "1=1" means in SQL statemnet , if you don't mind, kindly pls give some sample ....thank you very much for guidance
 
Manish Sridharan
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi dear,
'1=1' are conditions used in where clause. it is taken as always true condition. Similarly statement like '1=2'or 1=3 etc means condition is false. this statement are used generally where we want to copy structure of the wxisting table but not the content of the table.
suppose we hava table emp(name,age). and it has data also.
we can fire query as
"create table emp1 as select name, age from emp where 1=2;"

Hope u have got ur answer
bye
 
Anil Kumar Saha
Ranch Hand
Posts: 111
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This type of trick can used to hack a Database, popularly known as SQL Injection.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic