Skip to content

Instantly share code, notes, and snippets.

SELECT * FROM date
WHERE
('2016-12-01' BETWEEN start AND end)
OR
('2016-12-31' BETWEEN start AND end)
OR
(start >= '2016-12-01' AND end <= '2016-12-30');
#!/bin/sh
KEYSDIR=(変換対象鍵を配置するディレクトリ)
mkdir ${KEYSDIR}/gen 2>/dev/null
mkdir ${KEYSDIR}/raw 2>/dev/null
mkdir ${KEYSDIR}/openssh 2>/dev/null
for file in `find $KEYSDIR -maxdepth 1 -name '*.pub' -type f`; do
FNAME_EXT="${file##*/}"
if [ -d file ]; then
continue;
fi
<?php
/**
* 列データ
* 列ごとの設定です。この配列をJSONに変換してJSに渡します。
*/
$columns = array(
array('field' => 'name', 'caption' => 'Name', 'size' => '50%', 'sortable' => true,),
array(
'field' => 'total', 'caption' => 'total', 'size' => '50%', 'sortable' => true,
/**