[dennis]

I understand that webyog sends SQL commands unaltered.

The thing is that from time to time (and I can't tell you why or when), some of these

commands go through, I can view the changes but when I go back into webyog, they've

disappeared (comments, table changes).

Question : I haven't used “commit” up to now after using webyog 's alter table functions or

even with my comments.

Should I end all sessions sending a commit to MySQL first ?

Well anyway, at some point we'll put our finder on this problem !

[dennis]

I think you have 2 bugs in your latest 3.62 version :

1.Some of the comments appear when the tables are altered and disappear from the webyog interface after a few connections !

That's a drawback since I spent all day writing those comments !

2.Sometimes a column is rejected by an alter table query for comments. In one session the query is accepted, in other the column

is not accepted.

This makes things unstable.

I'll be trying workarounds will keep you posted. Hopefully, you'll get there before me.

[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.

[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 ?

[Author]

Posts