What is current version of mysql?

0 Answers  

---

Explain the different types of constraints?

0 Answers  

---

What is a deterministic function?

0 Answers  

---

How many primary keys can be there in a table?

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  

---

---

Where is mysql used?

0 Answers  

---

What are the 'mysql' command line options?

0 Answers  

---

How to get data from mysql in php?

0 Answers  

---

when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  

---

How do I delete a table in mysql workbench?

0 Answers  

---

What is the difference between timestamp and datetime in mysql?

0 Answers  

---

What are the objects can be created using CREATE statement?

0 Answers  

---