what is JOIN? Give example & types of join?

iMedia, Millennium, RAM Software, Satyam,

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

Infosys, Sierra Atlantica,

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

E2 Solutions, Tesco,

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.

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?

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

Systematix,

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

Amdocs, MediaSoft,

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

How to get full name of monthname ?

about join

about foregine

How to find out the second largest element from mysql table

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

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

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