paip.输入法编程增加码表类型

paip.输入法编程---增加码表类型


作者Attilax ,  EMAIL:1466519819@qq.com
来源:attilax的专栏
地址:http://blog.csdn.net/attilax

查询是否已经有这个码表。
--------------
 select * from gaopinzi  where jpcpcye='jpcye'

记录最后码表ID
---------------------
select * from gaopinzi    order by id  desc limit 500

导入码表
------------

确定码表范围
--------------
select * from gaopinzi    order by id  desc limit 500

得到一个范围,比如288423--338410

设置类型
------------
 UPDATE gaopinzi
SET lang='chinese',jpcpcye='jpcye'
WHERE
 id >= 288423
AND id <= 338410
AND lang IS NULL
AND jpcpcye IS NULL
AND gudin =0
AND ord IS NULL
AND del IS NULL
AND dely IS NULL


确定检查
------------
select * from gaopinzi   WHERE
 id >= 288420
AND id <= 338419

原文地址:https://www.cnblogs.com/attilax/p/15199577.html