MySQL Interview Questions
Questions Answers Views Company eMail

Which command is used to view the content of the table in mysql?

7

How many columns can you create for an index?

8

What does "i_am_a_dummy flag" do in mysql?

9




What is the usage of "i-am-a-dummy" flag in mysql?

11

What is sqlyog?

9

How many triggers are possible in mysql?

7

Write a query to retrieve a hundred books starting from 20th.

8

In which language mysql has been written?

10




What is a trigger in mysql?

12

What is the difference between database and table?

26

What is the query to display top 20 rows?

30

What is save point in mysql?

28

What is the difference between heap table and temporary table?

25

What are the advantages of myisam over innodb?

26

How to change a password for an existing user via mysqladmin?

27


Post New MySQL Questions






Un-Answered Questions { MySQL }

How to represent ENUMs and SETs internally?

30


What is triggers and how it can be used in mysql?

6


How to get the current date in mysql?

27


How can you make a database as your current database?

11


Write a query to fetch duplicate records from a table using mysql?

11






all the queries used in sql

1610


How to include character strings in sql statements?

10


Describe mysql transaction properties.

10


How we can see all indexes defined for a table in mysql?

7


How to return query output in html format?

13


Explain the difference between procedure and function in mysql?

7


How to enter numeric values as hex numbers?

9


In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

1853


Explain the difference between mysql and mysql interfaces in php?

12


What is the default port for MySQL Server?

34