forked from xin497668869/binlog2sql_java
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathupdateInitTestSingle.sql
More file actions
17 lines (12 loc) · 2.71 KB
/
Copy pathupdateInitTestSingle.sql
File metadata and controls
17 lines (12 loc) · 2.71 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
DELETE FROM `test2`.`flashback_test_common`;
DELETE FROM `test2`.`test_flashback_test_common`;
INSERT INTO `test2`.`flashback_test_common`(`bigint_`, `varchar_`, `char_`, `date_`, `datetime_`, `time_`, `double`,
`int_`, `tinyint_`, `smallint_`, `text_`, `timestamp_`, `blob`)
VALUES (1111, 'varcharr', 'charr', '2019-02-01', '2019-02-01 18:41:44', '12:00:00', 1.24, 111, 22, 11, '222',
'2019-02-01 18:41:47',
0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61703FE8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D6170133F3F760A3F00025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC13F603F000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000B6F7065726174696F6E4964737200146A6176612E6D6174682E426967496E74656765728CFC3F3F3F030006490008626974436F756E744900096269744C656E67746849001366697273744E6F6E7A65726F427974654E756D49000C6C6F776573745365744269744900067369676E756D5B00096D61676E69747564657400025B42787200106A6176612E6C616E672E4E756D62657286AC3F0B94E03F00007870FFFFFFFFFFFFFFFFFFFFFF3FFFFF3F00000001757200025B42ACF3173F08543F0000787000000008016B4C3F800000787800);
INSERT INTO `test2`.`test_flashback_test_common`(`bigint_`, `varchar_`, `char_`, `date_`, `datetime_`, `time_`, `double`,
`int_`, `tinyint_`, `smallint_`, `text_`, `timestamp_`, `blob`)
VALUES (1111, 'varcharr', 'charr', '2019-02-01', '2019-02-01 18:41:44', '12:00:00', 1.24, 111, 22, 11, '222',
'2019-02-01 18:41:47',
0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61703FE8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D6170133F3F760A3F00025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC13F603F000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000B6F7065726174696F6E4964737200146A6176612E6D6174682E426967496E74656765728CFC3F3F3F030006490008626974436F756E744900096269744C656E67746849001366697273744E6F6E7A65726F427974654E756D49000C6C6F776573745365744269744900067369676E756D5B00096D61676E69747564657400025B42787200106A6176612E6C616E672E4E756D62657286AC3F0B94E03F00007870FFFFFFFFFFFFFFFFFFFFFF3FFFFF3F00000001757200025B42ACF3173F08543F0000787000000008016B4C3F800000787800);