MySQL Forums
Forum List  »  Replication

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 |

=)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error in replication with time update 00:60:00
911
September 15, 2011 02:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.