MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

What is the difference between mysql_fetch_array and mysql_fetch_object?

Following are the differences between mysql_fetch_array and mysql_fetch_object,

mysql_fetch_array() -  Returns a result row as an associated array or a regular array from the database.
mysql_fetch_object -  Returns a result row as an object from the database.




Next 5 interview question(s)

1
What is the difference between BLOB AND TEXT?
2
Is Mysql query case sensitive?
3
How can you see all indexes defined for a table?
4
How do you login to MySql using Unix shell?
5
What is the difference between primary key and candidate key?