Menus

Sunday 10 December 2017

MySql Boolean Data type field create


MySql BOOLEAN or TINYINT


MySQL provides BOOLEAN or BOOL as the synonym of TINYINT(1).

Example 1
Create job table  with boolean data type.



After save job table structure.



Example 2


CREATE TABLE tasks (
    id INT PRIMARY KEY AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    completed BOOLEAN
)


No comments:

Post a Comment