MySQL Interview Questions
Questions Answers Views Company eMail

What is the difference between the primary and unique key in mysql?

64

What is the difference between having and where clause in mysql? Explain

68

Explain the difference between primary key and candidate key in mysql?

88




How to control the max size of a heap table?

74

How to display top 10 rows in mysql?

69

Is mysql case-sensitive?

68

How triggers can be used in mysql?

76

What are the advantages of mysql?

71




How to create table with same structure of student table in mysql?

69

Write a query to fetch common records between two tables using mysql?

73

What is the use of concat() in mysql?

70

What are the difference between now and current_date in mysql?

81

How to change the database engine in mysql?

68

How to get a version of mysql?

74

In mysql, what is the default storage engine?

77


Post New MySQL Questions






Un-Answered Questions { MySQL }

What are the functions in mysql?

38


What are the two types of queries?

36


What are views in mysql?

43


What is the difference between mysql and oracle?

44


How can I create database in mysql?

41






How to write after insert event update trigger on the same table in mysql?

45


Write a query to count the number of rows of a table in mysql.

78


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

704


Can you rename a database in mysql?

34


What is the use of procedure in mysql?

36


How do I connect to mysql database?

40


What are Heap tables?

81


What are the applications required to support mysql?

67


What is max connection in mysql?

39


Where is mysql password stored?

38