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 3199

Is SET Command is SQL Statement..?

BitWise,

4 14375

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 3461

What is A BI Ap;plication?

HCL,

1 4163

What is Database?

2 4875

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)?

2509

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?

1908

What is the difference between primary and unique key

CSC,

5 8224

explain GROUPBY & HAVING clause with examples.

2288

date funciton

2 3915

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 3125

What are the critical issues you have resolved in your company

Wipro,

2236

How can you move the master database

IBM,

2044

What is RMS Migrations

Steria,

2395

What is striped backup

Cap Gemini,

2240

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are the method you will follow while sql installing

2360

Can we store images in mysql database?

906

How does mysql store binary data?

959

How to calculate the difference between two time values?

994

Does mysql need a server?

924

Can you shard mysql?

920

Does facebook still use mysql?

932

What is mysql database extension?

1029

How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

1063

How do I view a mysql database?

902

How do I import database through command line?

1004

Are stored procedures precompiled?

984

What is the default password for mysql?

902

What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

1023

What are the 'mysql' command line options?

993

For More Un-Answered { MySQL } Questions Click Here