mysql-es
qinzhao168
梦想 在远处 呐喊
展开
-
mysql load data to elasticsearch 脚本
安装 elasticsearch-jdbc-2.3.2.0 必须的!/bin/bashset -e bin=/home/baimu/elasticsearch-jdbc-2.3.2.0/bin lib=/home/baimu/elasticsearch-jdbc-2.3.2.0/lib echo ‘{ “type” : “jdbc”, “jdbc” : { “url” : “jdbc:m原创 2017-06-21 17:08:50 · 308 阅读 · 0 评论 -
mysql alter 语句用法,添加、修改、删除字段等
修改表名:ALTER TABLE admin_user RENAME TO a_use增加主键alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id); 修改ID为自增,并设置为主键alter table bran原创 2017-08-14 23:15:04 · 1048 阅读 · 0 评论 -
Navicat for MySQL出现1030-Got error 28 from storage engine错误
错误现象:E1127 10:21:06.516066 77530 ci_flows.go:201] ListFlowsAndLastBuild get data from database failed:Error 1030: Got error 28 from storage engineE1127 10:21:06.516104 77530 ci_flows.go:42] CiFlow原创 2017-11-27 10:42:46 · 1497 阅读 · 0 评论