MySQL Interview Questions
Questions Answers Views Company eMail

what if you really want to store the timestamp data, such as the publication date of the article?

2 3523

What happens if a table has one column defined as TIMESTAMP?

1 3837

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

2 5057

Explain the difference between FLOAT, DOUBLE and REAL.


14 55908

Explain the difference between BOOL, TINYINT and BIT?

1 4232

How to enable or disable a row of a table using MySQL in struts?


Explain MySQL architecture?

1 11008

Explain MySQL locks?

1 3219

Explain multi-version concurrency control in MySQL?

2 6655

What are MySQL transactions?

2 3139

What is ACID?

2 3305

Which storage engines support transactions in MySQL?

2 4529

How do you convert to a different table type?

1 2287

How do you index just the first four bytes of the column?

2 2888

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

Wipro, CSS, Aufait,

4 10493

Post New MySQL Questions

Un-Answered Questions { MySQL } to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?


explain GROUPBY & HAVING clause with examples.


I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.


How to define numeric 9(3) in db2 table without decimal point??


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?


How to set the time zone for MySQL to particular country time?


What is striped backup


How can you plan the logshipping before processing?


What are the method you will follow while sql installing


what is mysql optimization in brief?


What is RMS Migrations


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: Thanks, Kartik T


How internally data stores in MyISAM and INNODB table types?


What are the critical issues you have resolved in your company


Explain the architecture models of SQL Server?