Answer Posted / avanthi g

Fetch a result row as an associative array, a numeric array, or both
Returns an array that corresponds to the fetched row and moves the internal data pointer ahead.

Example:
MYSQL_NUM returns a numerically indexed array.
$row = mysql_fetch_array($result, MYSQL_NUM);
echo $row[0];

MYSQL_ASSOC returns an associative array.
$row = mysql_fetch_array($result, MYSQL_ASSOC);
echo $row["student_id"];

MYSQL_BOTH returns both.
$row = mysql_fetch_array($result, MYSQL_BOTH)
echo $row[0]." ".$row["name"];

What is datadir?

869

---

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1001

---

What are date and time data types in mysql?

1015

---

Is mysql a nosql database?

1116

---

Which datatype is used for email in mysql?

948

---

What is user in mysql?

880

---

Can we create table in stored procedure?

953

---

Why we use mongodb instead of mysql?

961

---

How does triggers work in mysql?

952

---

What is the query to display top 20 rows?

1013

---

what is the difference between gui testing and database testing? : Mysql dba

1089

---

What are mysql queries?

915

---

What is the difference between procedure and function in mysql?

1013

---

What is mysql used for?

957

---

What is mysql community server?

927

---