Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- Notification Services
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115347 views)
- Error no. 2003: Can't connect... (52073 views)
- Error no. 1251: "Client does not support authentication..." (48079 views)
- Error no. 1045: "Connection denied..." (41320 views)
- SQLyog Version History (39926 views)
- What is HTTP-tunneling? (29273 views)
- Error No. 2005: Unknown MySQL server host... (28329 views)
- What Is SSH and SSH-tunneling? (25479 views)
- Why are Stored Procedures not created when I import ... (23444 views)
- Do I need PHP to use SQLyog with MySQL? ... (21508 views)
Latest FAQs
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
MySQL bugs that affect SQLyog
Timestamp defined "ON UPDATE CURRENT_TIMESTAMP" updates incorrectly.
It has been reported that with MySQL 5.1.x and the INNODB storage engine the "ON UPDATE CURRENT_TIMESTAMP" clause for TIMESTAMP types is not functional! Sometimes such timestamp for a row will update even if there is no change in any other column.
Refer to: http://bugs.mysql.com/bug.php?id=29310
MyISAM tables work as expected/as documented. It is not known if any 3rd party engines are affected.
Probably all MySQL 5.1 versions before 5.1.21 are affected by this bug.
Tags: -
Related entries:
- SQLyog Version History
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
- What Storage Engines are supported by SQLyog?
- What is the difference between MySQL server replication and SQLyog synchronization?
- I only changed one row of data, but SQLyog wants to update more rows in the database. Why?
Last update: 2007-07-04 05:45
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ