What is the difference between mysql_connect() and
mysql_pconnect()?

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.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data directory in mysql?

474


What is ndb in mysql?

515


Is mysqli faster than mysql?

474


Write a query to fetch duplicate records from a table using mysql?

496


What are the different column comparison operators in mysql?

477






How many tables we can create in mysql database?

486


How will you export tables as an xml file in mysql?

458


How can an index be declared in mysql?

456


I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1476


How do I create a mysql database?

483


How do you insert a table?

494


Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

481


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

1734


What are all the Common SQL Function?

563


What is flush privileges in mysql?

514