MySQL Interview questions


Total available count: 24
Subject - Databases
Subsubject - MySQL

How to display top 50 rows?

In MySql, the top 50 rows are displayed by using the following query,

SELECT * FROM?LIMIT 0,50;

 




Next 5 interview question(s)

1
How MySQL Optimizes DISTINCT?
2
Where MyISAM table will be stored and also give their formats of storage?
3
What is the difference between mysql_fetch_array and mysql_fetch_object?
4
What is the difference between BLOB AND TEXT?
5
Is Mysql query case sensitive?