Comments in a SCHEMA HTML document

[dennis]

Hi,

The subject is about comments to be exported with a schema, not SQL comments.

At table level, inserting a comment is possible using the advanced table properties.

However, the number of available characters is too small to make a real comment.

Furthermore, I can't find how to add comments to the columns (the “extra” field ?)

Question 1 : How can the table comment be made longer ?

Question 2 : How can a column comment be made ?

Question 3 : Why won't the standard SQL comment insert commands in SQL mode work such as :

COMMENT ON TABLE TABLE1 IS 'This is the first table';

Thanks in advance because we need to quickly generate good schema documentation.

Denis

[Ritesh]

Quote:

Question 1 : How can the table comment be made longer ?

This is a limitation of MySQL as it supports very few characters for Table comments.

Quote:

in SQL mode work such as : COMMENT ON TABLE TABLE1 IS 'This is the first table';

The SQL command is not supported in MySQL.

[Shadow]

As far as I'm concerned, the fields' extra column is not for comments, but for displaying additional information about the given field, such as whethet it is auto increment or not. Correct me, if I'm wrong, fields cannot be commented.

[Ritesh]

You cannot add comments to columns in 3.23.x. In MySQL 4.1, you can do it using the following command –

CREATE TABLE test(

id int NOT NULL auto_increment COMMENT 'this is a comment',

PRIMARY KEY (id)

) TYPE=MyISAM;

I am not sure about 4.0.x. I will revert back tomorrow.

[dennis]

Ritesh wrote on Nov 4 2003, 05:36 PM:

You cannot add comments to columns in 3.23.x. In MySQL 4.1, you can do it using the following command –

CREATE TABLE test(

id int NOT NULL auto_increment COMMENT 'this is a comment',

PRIMARY KEY (id)

) TYPE=MyISAM;

I am not sure about 4.0.x. I will revert back tomorrow.

Ok. If a comment can be added to a column through the SQL “COMMENT” command in version 4.1.,

does it appear in the HTML schema generated by MYSQL ?

[Ritesh]

Quote:

appear in the HTML schema generated by MYSQL

I think you mean SQLyog.

As of SQLyog 3.61, the comment column is not added in the generated schema. This will be implemented in SQLyog 3.7 wherein you will have option in Create/Alter Table dialog to add/modify comments.

HTH

[dennis]

Hi,

We're in kind of a hurry here to produce documentation on a complex database.

Is there anyway we could get our hands on a beta version of 3.7. ?

Is there a workaround to add comments with 3.6. (we downloaded a test version of Webyog and

then purchased a license but have 3.52) and get a schema.html out ?

Is there any other way or software to get this done ?

We're kind of under pressure.

Thanks for any help.

[Ritesh]

I have no idea about other software.

Can you give me your email address. Maybe we will be able to send you a special release that will have this feature?

[Author]

Posts