131 search results

Page 10 out of 14 Pages

• MySQL bugs that affect SQLyog: Nothing happens when clicking the + sign left to a database
  
  Answer:   You experience that nothing happens when you are clicking the + sign left to a Database Icon in the SQLyog Object Browser when connected to ...
  
  
• Purchasing and Licensing: Can I change the registration info after SQLyog was installed?
  
  Answer: Yes! Common reason why you would want to do this are: you misspelled the registration name when purchsing. by mistake you registered ...
  
  
• Data Types and Storage Engines: Problems with TIMESTAMP NOT NULL and MySQL 4.1
  
  Answer:   If you experience problems when using MySQL 4.1 with TIMESTAMP columns declared NOT NULL the reason is simply that SHOW FULL FIELDS returns wrong information ...
  
  
• Database Schema Synchronization: Are the SQLyog SYNC tools case sensitive?
  
  Answer:   No! As of now (SQLyog 5.12) both the SCHEMA SYNC tool and the DATA SYNC tool operate in a case-insensitive way, as far as table names ...
  
  
• MySQL DATA synchronization: Weird errors with DATA SYNC and UCS2 data.
  
  Answer:   MySQL AB has confirmed one or more bug(s) when CHECKSUMs are generated on UCS2 data.The bug is described like: 1) Different results between InnoDB and ...
  
  
• SJA for LINUX: Can I compress (.zip) SQLyog/SJA backups?
  
  Answer:   YES - this option was added in SQLyog 8.4   ...
  
  
• Program versions: Where can I download old program versions?
  
  Answer:   Nowhere!With each new SQLyog version we constantly add features, improve usability, improve performance and - not to forget - fix bugs and add/change code to ...
  
  
• Manipulating data.: Can I use the auto_increment attribute without using that column as a Primary Key.
  
  Answer:   Yes! MySQL allows for that. The rules are:There can only be one auto_increment column in a tableThis column must be defined as a KEYWe ...
  
  
• Foreign Keys/relationships: I have Foreign Keys and they work but there are a lot of weird names
  
  Answer:   To create a Foreign Key/relationship in MySQL you (or SQLyog) must send a CREATE TABLE or ALTER TABLE SQL-statement likealter table ´Test´.´TableName´ add constraint ´ConstraintName´ ...
  
  
• Character Set and Localization Issues: My special characters display as 'noisy' Latin characters in SQLyog!
  
  Answer: Most likely the reason for this is that the install script of the application that is used with the data did not explicitly create databases ...
  
  

<<  previous  1  2  3  4  …  8  9  10  11  12  13  14  next  >>