What is the difference between mysql_connect() and
mysql_pconnect()?
Answer Posted / amita
mysql_connect everytime open a new connection to the database
while using mysql_pconnect , the function would first try to
find a (persistent) link 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...
the connection to the SQL server will not be closed when the
execution of the script ends. Instead, the link will remain
open for future use.
| Is This Answer Correct ? | 72 Yes | 4 No |
Post New Answer View All Answers
How to return query output in xml format?
Is mysql connect deprecated?
How to rename an existing column in a table?
What is the maximum number of records in mysql table?
Where is the mysql data directory?
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.
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
What is the difference between a heap table and temporary table?
How do you restart mysql?
How does limit work in mysql?
1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?
Is mysql good for large database?
Can we write pl sql mysql?
How to use case expression?
What is the difference between mysql and pdo?