difference between MYSQL_NUM AND MYSQL_ASSOC. MYSQL

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

Question Posted / deepak sakure

Answer Posted / deepak sakure

difference between MYSQL_NUM AND MYSQL_ASSOC.
MYSQL_NUM returns a numerically indexed array.
MYSQL_ASSOC returns an associative array.

Is This Answer Correct ?

20 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is mysqlcheck do?

1011

What are the purposes of using enum and set data types?

931

How to dump a table from a database.

1012

Write a query to find duplicate rows in table?

898

Define REGEXP?

1092

What is the password of mysql?

959

What is dblink?

885

Why use mysql procedures?

977

How to get last inserted id after insert data from a table in mysql?

974

How do I setup a mysql database?

969

What is difference between inner vs self vs cross?

952

how we will Show selected records sorted in an ascending (asc) or descending (desc).

977

Where does mysql store data?

869

What is ibdata1?

895

What is a join in mysql?

901