Differentiate between FLOAT and DOUBLE?
Answer / shiwanshu
Float() contain only the 2 decimal fraction value after the decmal point. e.g 2.23
Double() contain long fraction value after decimal point 23.999889...
Is This Answer Correct ? | 0 Yes | 0 No |
How do you control the max size of a HEAP table?
How to increment dates by 1 in mysql?
What is mysql optimization?
How can I create table in mysql?
Can we store files in mysql?
Is mysql a 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
How can we get total number of records by query in mysql?
What?s the default port for MySQL Server?
What is the difference between unix timestamps and mysql timestamps?
How to dump a table to a file with 'mysqldump'?
How do I start and stop mysql on windows?