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?

2387

why not null is not allowed at table level

Cognizant,

2811

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

2884

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

2181

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

2 4132

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

1697

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

1433

What is the difference between truncate and delete?

DELL,

1278

how to add a new column to an existing table?

MCN Solutions,

1081

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

1079

Which statement is used to delete a table in MySQL.

960

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

1509

Explain about the architecture of MYSQL?

1027

Explain about reporting services of MYSQL?

1131

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 ?

1120

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to decrement dates by 1 in mysql?

1065

What can I do with mysql?

986

How to delete a trigger in mysql?

985

How triggers can be used in mysql?

1070

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?

1972

Where MyISAM table will be stored and also give their formats of storage?

1115

What is mysql in dbms?

1104

How to add a new column to an existing table in mysql?

1046

How to store binary data in mysql?

1051

What do you need to connect php to mysql?

1043

What is slow query log in mysql?

1164

What is text?

1022

How to present a past time in hours, minutes and seconds?

1099

What is the latest version of php and mysql?

1277

What is general log in mysql?

1038

For More Un-Answered { MySQL } Questions Click Here