Forum Replies Created
-
AuthorPosts
-
Ritesh
MemberSQLyog will always issue “CREATE TEMPORARY..” etc. commands. It does not check for privileges.
Ritesh
MemberYou do not have the permission to connect from a remote host. Ask your host to give you '%' privilege instead of Host specific access.
Ritesh
MemberThis bug has been fixed in SQLyog 3.62 which we are going to release soon.
Ritesh
MemberThis bug has been fixed in SQLyog 3.62 which we are going to release soon.
Ritesh
MemberI 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?
Ritesh
MemberSQLyog 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.
Ritesh
MemberQuote: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
Ritesh
MemberIt seems that you dont have permission to connect from a remote host.
Ritesh
MemberYou 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.
Ritesh
MemberQuote: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.
Ritesh
MemberNope.
This feature is planned for SQLyog Max.
Ritesh
MemberDownload 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.
Ritesh
MemberYes !!! To assign PRIMARY KEY property to a column check the corresponding PK checkbox.
Which version of MySQL are your running?
Ritesh
MemberGreetings
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.
Ritesh
MemberCurrently, 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