how many fields can be updated using set in a mysql query?



how many fields can be updated using set in a mysql query?..

Answer / mysql guy

64

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 Answers  


How would you enter characters as hex numbers?

0 Answers  


What is inner join in mysql?

0 Answers  


Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  


Why mysql is used with php?

0 Answers  






What is the use of count function in mysql?

0 Answers  


How do I clear the command in mysql?

0 Answers  


Can we join 3 tables in mysql?

0 Answers  


How do I clear the screen in mysql?

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  


Is there an object-oriented version of MySQL library functions?

1 Answers  


What is append query?

0 Answers  


Categories