Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between CHAR and VARCHAR data types?
- 2 Answers
- 8881 Views
- Ramco, I also Faced
- E-Mail Answers
Answer Posted / shekoli
Char is a fixed lenth datatype. Ex: char(7), welcome
but varchar is a variable length datatypes, Ex:
varchar(7),welcome (or) come
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between char and varchar in mysql?
What is unsigned int in mysql?
How do stored procedures work?
How many sql ddl commands are supported by 'mysql'?
How to get a list of all tables in a database?
How do you concatenate strings in mysql?
How can I see mysql database?
can you tell how can you display the maximum salary in sql? : Mysql dba
How do you rename a table?
What does do in mysql?
Can we use mysql and mysqli together?
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 does php communicate with mysql?
What is bigint in mysql?
How many primary keys can be there in a table?
