MySQL Interview Questions
Questions Answers Views Company eMail

What are some good ideas regarding user security in MySQL?

2 2869

Explain the difference between MyISAM Static and MyISAM Dynamic?

1 7143

What does myisamchk do?

1 2518




Explain advantages of InnoDB over MyISAM?

1 6439

Explain advantages of MyISAM over InnoDB?

1 4434

What are HEAP tables in MySQL?

1 10195

How do you control the max size of a HEAP table?

1 5921

What are CSV tables?

1 4239




Explain federated tables?

Tech Mahindra,

3 5761

What is SERIAL data type in MySQL?

Aspire,

3 39920

What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?

2 8777

If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

ABC,

2 3971

Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.

1 1929

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 3295

Explain data type TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP .

Zensar,

2 7180


Post New MySQL Questions






Un-Answered Questions { MySQL }

why not null is not allowed at table level

1403


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

1617


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

2010


all the queries used in sql

1451


what is mysql optimization in brief?

1163






suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

987


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

991


what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

275


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

959


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.

2307


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

1595


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

892


How can you move the master database

820


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

2761


how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

1077