forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Synchronization Bug
- This topic is empty.
-
AuthorPosts
-
-
May 8, 2003 at 12:36 pm #14219
CalEvans
MemberHave you tried it the other way? Switch the databases?
And key is the proper SQL term in this case, not Index.
=C=
-
May 8, 2003 at 1:41 pm #14220
bass
Memberwhen I switch the DB i noticed that sqlyog dislpays
a property of first DB on the second DB window.
and so sqlyog confus the DB's and doesn't the right changes:
sample:
table1 has uniqe key 'key1' (as First Database)
table2 has key 'key1' (as second Database)
sqlyog displays uniqe key on the second DB window !!!
…and so, when I click on “<<< Sync (Clipboard" (I want change key1 of table1 into normal key), it generate: alter table 'db'.'table1' drop key 'key1', add unique key 'key1' ('field1') this generates the same key that table1 had before the alter-query Hope this helps, bass
-
May 8, 2003 at 1:43 pm #14221
Ritesh
MemberClick Sync ( Clipboard ) for the second database 😀
-
May 8, 2003 at 1:48 pm #14222
Ritesh
MemberWhat I meant to say is instead of switching the database in the dropdown combo box, click on the Sync ( Clipboard ) for the second database
HTH
-
May 8, 2003 at 1:49 pm #14223
bass
MemberI did it !! That's the problem!
-
May 8, 2003 at 1:54 pm #14224
bass
Member…there is the same problem in both ways….
the gernerated sql statement changes the key propertys
for the wrong table… 😉
-
May 8, 2003 at 2:22 pm #14225
bass
Member…and for CalEvans:
sorry my question but when KEY is the proper SQL Statement….
why I can't found it on mysql documentation?!?!?!?
whats the differences between INDEX and KEY ???
[url=”http://http://www.mysql.com/doc/en/ALTER_TABLE.html”%5Dmysql documentation[/url]
-
May 8, 2003 at 2:23 pm #14226
-
May 8, 2003 at 3:29 pm #14227
Ritesh
MemberCan you send me the SQL Batch script for both the databases, so that we can reproduce the bug ( if there are any ) out here :huh:
-
-
AuthorPosts
- You must be logged in to reply to this topic.