Char is a fixed lenth datatype. Ex: char(7), welcome but varchar is a va

What is the difference between CHAR and VARCHAR data types?

Question Posted / shekoli

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

Please Help Members By Posting Answers For Below Questions

What is the use of concat() in mysql?

973

Write a query to fetch duplicate records from a table using mysql?

915

Can we store pdf files in mysql?

969

What are the differences between binary and varbinary?

1024

What is limit in mysql?

849

What is mysql procedure?

910

Write a query to retrieve a hundred books starting from 20th.

1496

Write a query to display even rows in student table using mysql?

877

What are the non-standard sql commands supported by 'mysql'?

967

How to use rank function in mysql?

956

Write a query to fetch common records between two tables using mysql?

1000

What are the types of queries?

932

What is 1nf 2nf 3nf?

948

Is mariadb better than mysql?

1023

What are the differences between a primary key and foreign key?

1075