TEXT character string with variable length, maximum 2^16-1 characters : Text Type « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Text Type

TEXT character string with variable length, maximum 2^16-1 characters

  
mysql>
mysql>
mysql> CREATE TABLE employee(
    ->     id INT,
    ->     eName VARCHAR(10),
    ->     comments Text
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table employee;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

1. TEXT and BLOB Data Type Sizes and Upper Limits (in Bytes)
2.Create a table with TEXT type column