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

Answer Posted / amith

999.99 to -99.99. Note that with the negative number the
minus sign is considered one of the digits.

Is This Answer Correct ?    11 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I run mysql on a mac?

456


What is blob and clob?

489


What is mysql ndb?

495


What command is used to delete the data from the table without deleting the table structure?

430


Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4186






What are the steps required to view your mysql database?

579


How to shutdown mysql server?

558


How we can get distinct columns values in mysql?

581


What are mysql data types?

501


What does innodb stand for?

506


How do I setup a mysql database?

449


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


What is RMS Migrations

1940


What storage engines are used in MySQL?

503


What is the current mysql version?

484