Re: ACFinder テスト中

このトピックの投稿一覧へ

なし Re: ACFinder テスト中

msg# 1.7
depth:
1
前の投稿 - 次の投稿 | 親投稿 - 子投稿.1 .2 .3 | 投稿日時 2011.01.07 14:35
OhYeah!  管理人   投稿数: 983 オンライン
下記 URL に spec.bunrui 更新クエリーを公開しました。ACFinder もこちらを取得するようにしてください。
http://macs.o-ya.net/data/spec.bunrui.qry

なお、データ更新と spec.bunrui.qry の更新が同時の場合は、先に spec.bunrui.qry を実行してからデータ更新すれば OK です。spec.bunrui.qry のみ更新された場合は、spec.bunrui.qry 実行後に m_kihon テーブルの koka フィールドの更新をするようにしてください。

m_kihon 更新サンプル
--/d
drop table if exists t_kihon;
create temp table t_kihon as select bango, seibun1, seibun2, seibun3, seibun4, seibun5, '' as koka, 0 as kokaid0, 0 as kokaid1, 0 as kokaid2, 0 as kokaid3, 0 as kokaid4, 0 as kokaid5 from m_kihon;
update t_kihon set kokaid1 = (select kokaid from spec.bunrui where seibun1 = seibun) where ifnullstr(seibun1, '') <> '';;
update t_kihon set kokaid2 = (select kokaid from spec.bunrui where seibun2 = seibun) where ifnullstr(seibun2, '') <> '';
update t_kihon set kokaid3 = (select kokaid from spec.bunrui where seibun3 = seibun) where ifnullstr(seibun3, '') <> '';
update t_kihon set kokaid4 = (select kokaid from spec.bunrui where seibun4 = seibun) where ifnullstr(seibun4, '') <> '';
update t_kihon set kokaid5 = (select kokaid from spec.bunrui where seibun5 = seibun) where ifnullstr(seibun5, '') <> '';
update t_kihon set kokaid0 = kokaid1 | kokaid2 | kokaid3 | kokaid4 | kokaid5;
update t_kihon set kokaid0 = (select kokaid from spec.koka where koka = '展着') where kokaid0 = 0;
update t_kihon set koka = concat('・',
  (select koka from spec.koka where kokaid = kokaid0 & 3),
  (select koka from spec.koka where kokaid = kokaid0 & 4),
  (select koka from spec.koka where kokaid = kokaid0 & 8),
  (select koka from spec.koka where kokaid = kokaid0 & 16),
  (select koka from spec.koka where kokaid = kokaid0 & 32),
  (select koka from spec.koka where kokaid = kokaid0 & 64),
  (select koka from spec.koka where kokaid = kokaid0 & 128),
  (select koka from spec.koka where kokaid = kokaid0 & 256),
  (select koka from spec.koka where kokaid = kokaid0 & 512),
  (select koka from spec.koka where kokaid = kokaid0 & 1024),
  (select koka from spec.koka where kokaid = kokaid0 & 2048),
  (select koka from spec.koka where kokaid = kokaid0 & 4096),
  (select koka from spec.koka where kokaid = kokaid0 & 8192),
  (select koka from spec.koka where kokaid = kokaid0 & 16384),
  (select koka from spec.koka where kokaid = kokaid0 & 32768)
);
update m_kihon set koka = (select koka from t_kihon where bango = m_kihon.bango);
drop table if exists t_kihon;
投票数:0 平均点:0.00

投稿ツリー

  条件検索へ