Answer Posted / salil

SELECT max( t1.col )
FROM `table` t1
WHERE t1.col < (SELECT max( t2.col ) FROM `table` t2);

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3982

---

What is the purpose of mysql database?

921

---

What is 'mysqladmin' in mysql?

1038

---

Can I use mariadb instead of mysql?

926

---

Is mysql is a programming language?

998

---

How many groups of data types?

988

---

How do I select a database in mysql workbench?

1019

---

In mysql, what is the default storage engine?

1013

---

What is cursor in mysql?

902

---

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

1643

---

What is the current root password of mysql?

922

---

Can you tell which of the following where clauses is faster?

913

---

What is localhost in mysql?

1009

---

How to enter Characters as HEX Numbers?

1017

---

How to decrement dates by 1 in mysql?

1013

---