What is the purpose of 'comment' keyword in MySQL?

Viewed 2471

I have found there is the 'comment' keyword in MySQL.(not comment syntax like /* */, #)

But I do not know the reason why there is the 'comment' keyword.

If there is the following table, how could I use the 'comment'?

create table Employee(
    id int not null auto_increment,
    create_dt date comment 'the date when employee was hired'
    salary int comment 'salary in EUR',
    primary key (id)
) comment 'The employee table of company AA';
1 Answers
Related