what is the difference between between and in operators in mysql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What is not null in mysql?

0 Answers  


Define REGEXP?

0 Answers  


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers  


What is pragma exception?

0 Answers  


Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

3 Answers   TCS,


What is the maximum number of columns per table?

0 Answers  


What is the difference between b-tree and hash indexes?

0 Answers  


Where is the myisam table stored?

0 Answers  


How do I restore a mysql database?

0 Answers  


What is mysql community server?

0 Answers  


How do you start and stop MySQL on Windows?

3 Answers  


How can we convert between Unix & MySQL timestamps?

0 Answers  


Categories