Sign Up Login


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category
MySQL Interview Questions
Questions Answers Views Company eMail

what if you really want to store the timestamp data, such as the publication date of the article?

 2 5363

What happens if a table has one column defined as TIMESTAMP?

 1 5455

If you specify the data type as DECIMAL (5,2), what?s the range of values that can go in this table?

 2 6990

Explain the difference between FLOAT, DOUBLE and REAL.

Yahoo,

14 72517

Explain the difference between BOOL, TINYINT and BIT?

 1 5723

How to enable or disable a row of a table using MySQL in struts?

 3796

Explain MySQL architecture?

 1 13178

Explain MySQL locks?

 1 4847

Explain multi-version concurrency control in MySQL?

 2 9105

What are MySQL transactions?

 2 4882

What is ACID?

 2 5403

Which storage engines support transactions in MySQL?

 2 7062

How do you convert to a different table type?

 1 3660

How do you index just the first four bytes of the column?

 2 4599

What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?

Aufait, CSS, Wipro,

4 13685

Post New MySQL Questions

Un-Answered Questions { MySQL }

What does mysql workbench do?

635

Can you tell which of the following where clauses is faster?

624

What is InnoDB?

753

How to determine the location of the data directory?

679

What is the default port number of mysql?

682

What are the difference between mongodb and mysql?

914

What are mysql queries?

677

What is text?

701

What is use command in mysql?

717

What is the current root password of mysql?

642

What is pdo connection?

622

What is a text delimiter?

681

How to use triggers to track changes in mysql?

653

How to get current MySQL version?

771

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

1358

For More Un-Answered { MySQL } Questions Click Here