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
How do I run mysql on a mac?
What is blob and clob?
What is mysql ndb?
What command is used to delete the data from the table without deleting the table structure?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What are the steps required to view your mysql database?
How to shutdown mysql server?
How we can get distinct columns values in mysql?
What are mysql data types?
What does innodb stand for?
How do I setup a mysql database?
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
What is RMS Migrations
What storage engines are used in MySQL?
What is the current mysql version?