How can you handle the –secure-file-priv in mysql?

960

---

Can you tell the difference between ereg_replace() and eregi_replace()?

1049

---

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

904

---

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1034

---

What are the ways in which you can retrieve data in the result set of mysql using php?

1003

---

Can you tell few best practices to be followed for optimization in sql?

934

---

How can you take the backup and restore a mysql database using php?

968

---

How to copy data from one server to another using php?

1060

---

Where is the myisam table stored?

975

---

Can you tell the difference between $message and $$message?

988

---

How can you validate emails using a single query?

910

---

Can you tell what are various ways to create an index?

898

---

Can you tell a way to know the number of days between the two given dates in php?

1112

---

Can you tell how to find the number of rows in a resultset using php?

914

---

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

1005

---