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 5356

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

1 5454

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

2 6985

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 72500

Explain the difference between BOOL, TINYINT and BIT?

1 5717

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

3793

Explain MySQL architecture?

1 13173

Explain MySQL locks?

1 4844

Explain multi-version concurrency control in MySQL?

2 9092

What are MySQL transactions?

2 4876

What is ACID?

2 5399

Which storage engines support transactions in MySQL?

2 7057

How do you convert to a different table type?

1 3655

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

2 4587

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

Aufait, CSS, Wipro,

4 13669


Post New MySQL Questions

Un-Answered Questions { MySQL }

How to present a past time in hours, minutes and seconds?

762


What is the difference between truncate and delete?

764


What is delimiter $$?

707


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: karthikgdv1206@yahoo.com. Thanks, Kartik T

1955


What is ISAM?

865


How do I start mysql client?

688


What does mysql workbench do?

630


What is mysql uuid?

692


How do I add a column to a table in mysql?

645


How to create a new view in mysql?

705


How does triggers work in mysql?

681


Is mysql running ubuntu?

648


Which statement is used to delete a table in MySQL.

644


What is a mysql model?

671


How does mysql store binary data?

665