kai.su

7.2 拼接字段 select n_progid||'test' from co_schedule; 去除多余的空格 select trim(' test ');默认去掉两端的空格 select trim(leading 'x' from 'xTomxx'); select trim(trailing 'x' from 'xTomxx'); 别名 select ...

备份数据 [code="java"]copy arc_rolemc(id,mcid,roleid,type) to '/tmp/arc_rolemc.csv' with csv; [/code] 拷贝文件 [code="java"]scp arc_rolemc.csv 172.16.1.101:/tmp/[/code] 恢复数据 [code="java"]copy arc_rolemc(...

在optimize table tablename过程中，强制终止导致表crashed。报错： table '....' is marked as crashed and last (automatic?) repair failed 手工执行修复： repair table tablename; 可以正常访问。...