MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

Explain the architecture models of SQL Server?

2325

why not null is not allowed at table level

Cognizant,

2752

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

2823

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

2110

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 4019

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

1625

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

1381

What is the difference between truncate and delete?

DELL,

1181

how to add a new column to an existing table?

MCN Solutions,

994

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

1007

Which statement is used to delete a table in MySQL.

904

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1448

Explain about the architecture of MYSQL?

974

Explain about reporting services of MYSQL?

1061

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

1061

Post New MySQL Questions

Un-Answered Questions { MySQL }

What are date and time data types in mysql?

1015

What is key in mysql?

888

How to convert numeric values to character strings?

1050

how to Return total number of rows.

1004

Can mysql and mariadb coexist?

1084

How do you create a primary key?

995

How do I kill a mysql connection?

897

How do you insert a table?

924

How do you determine the location of mysql data directory?

932

How do you connect MySQL database with PHP?

975

How to drop an existing view in mysql?

918

How to create a table?

986

What is mysql optimization?

905

How can you calculate the sum of any column of a table?

1044

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.

3950

For More Un-Answered { MySQL } Questions Click Here