What are different TEXT data types in MySQL?



What are different TEXT data types in MySQL?..

Answer / hrindows@gmail.com

Different text data types in MySQL include:
• TINYTEXT,
• TEXT,
• MEDIUMTEXT and
• LONGTEXT.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

What is a delimiter in mysql?

0 Answers  


How to delete a table.

0 Answers  


The structure of table view buyers is as follows: +----------------+-------------+------+-----+---------+----- -----------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+----- -----------+ | user_pri_id | int(15) | | PRI | NULL | auto_increment | | userid | varchar(10) | YES | | NULL | | +----------------+-------------+------+-----+---------+----- -----------+ the value of user_pri_id the last row 2345 then What will happen in the following conditions? Condition1: Delete all the rows and insert another row then. What is the starting value for this auto incremented field user_pri_id , Condition2: Delete the last row(having the field value 2345) and insert another row then. What is the value for this auto incremented field user_pri_id

2 Answers  


What is a text delimiter?

0 Answers  


Can mysql handle big data?

0 Answers  


Is there a free mysql?

0 Answers  


How do you name a table?

0 Answers  


How to store values to array from mysql database in php?

0 Answers  


What is difference between mysql and mysqli?

0 Answers  


Is mysql a programming language?

0 Answers  


What is an index? How can an index be declared in mysql?

0 Answers  


What are HEAP tables in MySQL?

1 Answers  


Categories