Forum Replies Created
-
AuthorPosts
-
RiteshMember
SQLyog will always issue “CREATE TEMPORARY..” etc. commands. It does not check for privileges.
RiteshMemberYou do not have the permission to connect from a remote host. Ask your host to give you '%' privilege instead of Host specific access.
RiteshMemberThis bug has been fixed in SQLyog 3.62 which we are going to release soon.
RiteshMemberThis bug has been fixed in SQLyog 3.62 which we are going to release soon.
RiteshMemberI 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?
RiteshMemberSQLyog does not add any information on its own.
Are you able to connect to the MySQL server using any other client utilities like the MySQL Command Line tool.
RiteshMemberQuote:appear in the HTML schema generated by MYSQLI 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
RiteshMemberIt seems that you dont have permission to connect from a remote host.
RiteshMemberYou 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.
RiteshMemberQuote: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.
RiteshMemberNope.
This feature is planned for SQLyog Max.
RiteshMemberDownload SQLyog 3.61 and install it in the same folder in which 3.52 is installed. It will automatically upgrade itself to SQLyog 3.61.
RiteshMemberYes !!! To assign PRIMARY KEY property to a column check the corresponding PK checkbox.
Which version of MySQL are your running?
RiteshMemberGreetings
Registered users get “high priority” fixes to critical bugs!
The bug has been fixed in SQLyog 3.62 RC and is available at http://www.webyog.com/sqlyog/SQLyog362.exe
Pls. check it out and confirm.
RiteshMemberCurrently, SQLyog supports ONE WAY synchronization only. All extra rows in the target that are not present in the source are deleted. We are working on making it a 2 way sync process – which poses additional challenges like conflict resolution, etc.
-
AuthorPosts