MySQL Interview Questions
Questions Answers Views Company eMail

what is JOIN? Give example & types of join?

Satyam, iMedia, Millennium, RAM Software,

14 30491

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

Infosys, Sierra Atlantica,

2 9499

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 35850

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 2056

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 2737

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


9 9021

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

Amdocs, MediaSoft,

5 5024

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

1 4295

How to get full name of monthname ?

4 5842

about join

2 2233

about foregine

2 1716

How to find out the second largest element from mysql table

15 17627

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

8 11180

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

8 3605

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

5 5764

Post New MySQL Questions

Un-Answered Questions { MySQL }

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


What are the method you will follow while sql installing


How can you get your MySQL root password, if you lost it?


What is RMS Migrations


i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?


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


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END


How can you move the master database


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


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


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


what is mysql optimization in brief?

1101 to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?


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


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.