forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Definition mismatch for Timestamp field
- This topic is empty.
Viewing 0 reply threads
-
AuthorPosts
-
-
March 28, 2005 at 5:38 pm #17243
Ritesh
MemberIn v3.23.54, a simple table definition is given as:
Code:CREATE TABLE `TableName1` (
`id` int(11) NOT NULL auto_increment,
`t` timestamp(14) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAMIn 4.1.9, the same table definition is given as:
Code:CREATE TABLE `tablename1` (
`id` int(11) NOT NULL auto_increment,
`t` timestamp NULL default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAMIf you notice, the column t is having different definitions i.e. timestamp(14) and timestamp across multiple MySQL versions. We plan to fix this issue in one of the future version of SJA.
Currently the only solution is to use same MySQL versions for both source and target.
-
-
AuthorPosts
Viewing 0 reply threads
- You must be logged in to reply to this topic.