MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

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...

1 2985

Is SET Command is SQL Statement..?

BitWise,

4 13706

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 3200

What is A BI Ap;plication?

HCL,

1 3792

What is Database?

2 4534

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2264

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1766

What is the difference between primary and unique key

CSC,

5 7578

explain GROUPBY & HAVING clause with examples.

2086

date funciton

2 3628

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 2905

What are the critical issues you have resolved in your company

Wipro,

2039

How can you move the master database

IBM,

1858

What is RMS Migrations

Steria,

2244

What is striped backup

Cap Gemini,

2093

Post New MySQL Questions

Un-Answered Questions { MySQL }

What is auto increment in mysql?

813

What is the maximum number of records in mysql table?

733

If we use sum function in mysql, does it return sum of that row or for that column?

800

What are the method you will follow while sql installing

2209

How to use triggers to track changes in mysql?

730

How to do login in mysql with unix shell.

841

How do I rename a procedure?

712

How would you enter characters as hex numbers?

771

Is mongodb faster than mysql?

780

Is mysql a server?

725

What is a storage engine?

804

How is data stored in mysql?

767

What is orm in mysql?

745

What are Heap tables?

1282

What are different types of queries?

782

For More Un-Answered { MySQL } Questions Click Here