MySQL Interview Questions
Questions Answers Views Company eMail

Which command is used to view the content of the table in mysql?

471

How many columns can you create for an index?

466

What does "i_am_a_dummy flag" do in mysql?

480

What is the usage of "i-am-a-dummy" flag in mysql?

652

What is sqlyog?

596

How many triggers are possible in mysql?

490

Write a query to retrieve a hundred books starting from 20th.

943

In which language mysql has been written?

845

What is a trigger in mysql?

527

What is the difference between database and table?

551

What is the query to display top 20 rows?

591

What is save point in mysql?

501

What is the difference between heap table and temporary table?

600

What are the advantages of myisam over innodb?

548

How to change a password for an existing user via mysqladmin?

549


Post New MySQL Questions

Un-Answered Questions { MySQL }

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

1133


How do I remove a user from mysql?

544


What is the command used to create a database using php and mysql?

633


What is the difference between unix timestamps and mysql timestamps?

487


How to create a table?

530






What is clob in mysql

462


What is data type for image in mysql?

435


What is difference between mysql and mysql server?

449


What is mysql default port number?

518


How does php communicate with mysql?

459


What are the difference between now and current_date in mysql?

622


What is mysql data directory? How to determine the location of the data directory?

511


What is the difference between the LIKE and REGEXP operators?

518


What is full text indexing in mysql?

453


How show all tables in mysql query?

460