MySQL Interview Questions
Questions Answers Views Company eMail

what is JOIN? Give example & types of join?

Satyam, iMedia, Millennium, RAM Software,

14 31030

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

Infosys, Sierra Atlantica,

2 9654

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 36116




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 2131

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 2827

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

Systematix,

9 9226

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

Amdocs, MediaSoft,

5 5159

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

1 4381




How to get full name of monthname ?

4 5968

about join

2 2316

about foregine

2 1804

How to find out the second largest element from mysql table

15 18011

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

8 11594

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

8 3746

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

5 5895


Post New MySQL Questions






Un-Answered Questions { MySQL }

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

3519


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

1568


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

1097


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

765


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

1718






How internally data stores in MyISAM and INNODB table types?

1388


What is RMS Migrations

1105


why not null is not allowed at table level

1420


Explain the architecture models of SQL Server?

1229


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?

819


all the queries used in sql

1463


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

1013


What are the critical issues you have resolved in your company

1028


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

908


How can you move the master database

836