MySQL Interview Questions
Questions Answers Views Company eMail

what is JOIN? Give example & types of join?

Satyam, iMedia, Millennium, RAM Software,

14 30741

what are the optimization techniques for Query optimization performance issues and faster execution of queries

Infosys, Sierra Atlantica,

2 9569

what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?

Tesco, E2 Solutions,

10 35972




in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 2085

if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?

2 2782

how we can use more then one primary key in Single Table

Systematix,

9 9113

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

Amdocs, MediaSoft,

5 5079

how to find missing numbers between two order numbers; and dates ?

1 4328




How to get full name of monthname ?

4 5898

about join

2 2270

about foregine

2 1753

How to find out the second largest element from mysql table

15 17797

How we can copy one table data into another table whose name same as table but in differ database

8 11389

please give me the answer for this: query which generates the second highest integer in the table?

8 3675

How many tables will create when we create table, what are they?

5 5817


Post New MySQL Questions






Un-Answered Questions { MySQL }

why not null is not allowed at table level

1387


using primary can we relate two table, with out foreign key?

1524


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

971


How can you plan the logshipping before processing?

1114


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.

2256






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

1059


what is mysql optimization in brief?

1132


What is RMS Migrations

1059


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

873


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

3470


What are the critical issues you have resolved in your company

982


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

2741


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 ?

963


What is difference between Sql server and MySql database? It may be silly question but i really dont know.

731


How internally data stores in MyISAM and INNODB table types?

1351