search

Toms1999 / Mysql-To-Rocks

4 stars 2 forks source link

[feature]mysql2rocks脚本 #1

Open yangtzelsl opened 1 month ago

yangtzelsl commented 1 month ago

请教大佬，使用https://forum.mirrorship.cn/t/topic/4101教程的mysql2rocsk脚本，想改动但不会shell 1.生成的starrocsk表的comment沿用mysql表的comment应该怎么改？如果mysql没有comment给个默认值或空 2.生成的starrocks建表脚本，如果源是不同的库名.表名，建表脚本怎么带上库名.表名 （目前发现是第一个库名不带，其它库名会带） 以上，感谢

yangtzelsl commented 1 month ago

3.上述2的基础，是我希望starrocks保持和mysql相同的库名和表名，所以改动脚本时，我未从rocks_tables读数据，而是直接选择从mysql_tables读数据

yangtzelsl commented 1 month ago

比如我mysql_tables乱序的情况下 alarm.alarm_log gmall.ad_banner alarm.alarm_meta

生成的建表语句就对不上库表名 create database if not exists gmall; create database if not exists alarm; CREATE TABLE alarm_log ( id int(11) NOT NULL COMMENT '序号', alarm_meta_id int(11) NOT NULL COMMENT '元信息表ID', log varchar(65533) COMMENT '消息体', create_time datetime NOT NULL COMMENT '创建时间', update_time datetime NOT NULL COMMENT '更新时间', version int(11) DEFAULT '0' ) ENGINE=MYSQL COMMENT "MYSQL" PROPERTIES ( "host" = "", "port" = "3306", "user" = "root", "password" = "", "database" = "alarm", "table" = "alarm_log "); CREATE TABLE ad_banner ( Id bigint(11) NOT NULL , ad_desc varchar(500) DEFAULT NULL, file_name varchar(500) DEFAULT NULL ) ENGINE=MYSQL COMMENT "MYSQL" PROPERTIES ( "host" = "", "port" = "3306", "user" = "root", "password" = "", "database" = "gmall", "table" = "ad_banner "); CREATE TABLE alarm_meta ( id int(11) NOT NULL COMMENT '序号', name varchar(255) NOT NULL COMMENT '元信息名称', alarm_type_id int(11) NOT NULL COMMENT '告警类型序号', template varchar(65533) COMMENT '消息体', deleted int(2) NOT NULL DEFAULT '0' COMMENT '是否删除，0未删除，1删除', create_time datetime NOT NULL COMMENT '创建时间', update_time datetime NOT NULL COMMENT '更新时间', version int(11) DEFAULT '0' ) ENGINE=MYSQL COMMENT "MYSQL" PROPERTIES ( "host" = "", "port" = "3306", "user" = "root", "password" = "", "database" = "alarm", "table" = "alarm_meta ");