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?

2336

why not null is not allowed at table level

Cognizant,

2759

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

2831

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

2119

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

2 4029

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

1634

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

1387

What is the difference between truncate and delete?

DELL,

1191

how to add a new column to an existing table?

MCN Solutions,

1021

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

1012

Which statement is used to delete a table in MySQL.

910

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

1455

Explain about the architecture of MYSQL?

981

Explain about reporting services of MYSQL?

1069

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 ?

1066

Post New MySQL Questions

Un-Answered Questions { MySQL }

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

940

What is meant by decimal (5,2)?

1027

How does mysql store binary data?

959

Is mongodb faster than mysql?

953

How do you create a schema?

953

How to use in conditions?

1012

How do I select a database in mysql?

1069

How show all tables in mysql query?

935

How does triggers work in mysql?

961

Can we create table in stored procedure?

955

What is the difference between mysql_fetch_assoc and mysql_fetch_array?

1070

Is mysql an oracle product?

845

What is clob in mysql

940

How to delete an existing column in a table?

948

How to make a copy values from one column to another in mysql?

1035

For More Un-Answered { MySQL } Questions Click Here