TINYTEXT

MySQL

Example

CREATE TABLE Sample (
    ID INT AUTO_INCREMENT,
    Description TINYTEXT,
    PRIMARY KEY (ID)
);

INSERT INTO Sample (Description)
VALUES ('Tinytext example');

Output

Query OK, 1 row affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

Explanation

In the example code, a table named Sample is created with two columns: ID and Description. The ID column is an integer type and the primary key of the table. The Description column is of TINYTEXT type, which can contain up to 255 characters. Then, a new record is inserted into the table with the description ‘Tinytext example’. The output shows the result of these SQL commands, confirming the creation of the table and the successful insertion of a new record.