Skip to content

如何修改Inception_backup_information表的sql_statement字段设置成longtext #73

@apaul030515

Description

@apaul030515

使用inception进行大批量插入的时候,可以审核通过,并执行成功。
但在备份的时候,会报 Data too long for column 'sql_statement' at row 1,
是否可以改一下原始表的字段信息?
还是只能产生这个表之后,事后改动?

CREATE TABLE $_$Inception_backup_information$_$ (
opid_time varchar(50) NOT NULL,
start_binlog_file varchar(512) DEFAULT NULL,
start_binlog_pos int(11) DEFAULT NULL,
end_binlog_file varchar(512) DEFAULT NULL,
end_binlog_pos int(11) DEFAULT NULL,
sql_statement text,
host varchar(64) DEFAULT NULL,
dbname varchar(64) DEFAULT NULL,
tablename varchar(64) DEFAULT NULL,
port int(11) DEFAULT NULL,
time timestamp NULL DEFAULT NULL,
type varchar(20) DEFAULT NULL,
PRIMARY KEY (opid_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions