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.

How to return query output in xml format?

1088

---

Is mysql connect deprecated?

1021

---

How to rename an existing column in a table?

1115

---

What is the maximum number of records in mysql table?

976

---

Where is the mysql data directory?

991

---

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.

4044

---

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1066

---

What is the difference between a heap table and temporary table?

986

---

How do you restart mysql?

953

---

How does limit work in mysql?

952

---

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)?

2583

---

Is mysql good for large database?

988

---

Can we write pl sql mysql?

984

---

How to use case expression?

1016

---

What is the difference between mysql and pdo?

1059

---