Re: Error in replication with time update 00:60:00
Posted by:
Chydik Sam
Date: September 15, 2011 02:13AM
mysql> SHOW VARIABLES LIKE 'binlog_format';
+---------------+-----------+
| Variable_name | Value |
+---------------+-----------+
| binlog_format | STATEMENT |
+---------------+-----------+
1 row in set (0.00 sec)
mysql> show create table sunrav_tests \g
sunrav_tests | CREATE TABLE `sunrav_tests` (
`test_id` int(4) unsigned NOT NULL auto_increment,
`test_description` text collate utf8_unicode_ci,
`test_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`test_type` tinyint(1) NOT NULL default '0',
`test_author` varchar(255) collate utf8_unicode_ci default NULL,
`test_questions_count` int(11) unsigned NOT NULL default '1',
`test_is_exam_mode` char(1) collate utf8_unicode_ci default 'F',
`test_is_random_answers` char(1) collate utf8_unicode_ci default 'F',
`test_is_time_limit` char(1) collate utf8_unicode_ci default 'F',
`test_time_limit` time NOT NULL default '00:00:00',
`test_is_back` char(1) collate utf8_unicode_ci NOT NULL default 'F',
`test_is_show_score` char(1) collate utf8_unicode_ci default 'T',
`test_is_show_results_message` char(1) collate utf8_unicode_ci default 'T',
`test_is_next_when_right` char(1) collate utf8_unicode_ci default 'F',
`test_is_show_reference` char(1) collate utf8_unicode_ci default 'F',
`test_is_response_on_right` char(1) collate utf8_unicode_ci default 'F',
`test_is_response_on_wrong` char(1) collate utf8_unicode_ci default 'F',
`test_text_of_right_message` varchar(255) collate utf8_unicode_ci default NULL
,
`test_text_of_wrong_message` varchar(255) collate utf8_unicode_ci default NULL
,
`test_is_show_explanation` char(1) collate utf8_unicode_ci default 'F',
`test_concl_type` tinyint(2) unsigned NOT NULL default '0',
`test_is_stat_total` char(1) collate utf8_unicode_ci default 'T',
`test_is_stat_current` char(1) collate utf8_unicode_ci default 'T',
`test_is_stat_rights` char(1) collate utf8_unicode_ci default 'F',
`test_is_stat_time` char(1) collate utf8_unicode_ci default 'F',
`test_media_storage` varchar(255) collate utf8_unicode_ci default NULL,
`test_is_sort_by_theme` char(1) collate utf8_unicode_ci default 'F',
`test_max_count` int(11) default '0',
PRIMARY KEY (`test_id`),
UNIQUE KEY `test_name` (`test_name`)
) ENGINE=MyISAM AUTO_INCREMENT=508 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
ROW_FORMAT=FIXED |
=)