Answer Posted / sumit

In mysql_pconnect(), ‘p’ stands for persistance connection.

when connecting, the function would try to find a (persistent) connection that’s already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.


mysql_connect() function, every time it is opening and closing the database connection.

How to run a sql statement?

977

---

Can you rename a database in mysql?

960

---

Is mysql still popular?

875

---

Is mysql easy to learn?

891

---

How do you restart mysql?

860

---

How to make a copy values from one column to another in mysql?

985

---

What are the 'mysql' command line arguments?

961

---

write a command to view the content of the table

864

---

What is the maximum no of columns a table can have?

872

---

What is the use of mysqli_num_rows?

874

---

What does "i_am_a_dummy flag" do in mysql?

910

---

Should I use pdo or mysqli?

859

---

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

1581

---

What is the difference between unix timestamp and mysql timestamp?

1006

---

How do I setup mysql?

860

---