s4

changeset 766:d39c915daeda

find changesets by author, revision, files, or words in the commit message
Ensure tmp_q table to be temporary
author HIROSE Yuuji <yuuji@gentei.org>
date Sun, 07 Jun 2020 20:44:27 +0900
parents 41e443a925c8
children 891f1f5a8153
files s4-blog.sh
diffstat 1 files changed, 1 insertions(+), 0 deletions(-) [+]
line diff
     1.1 --- a/s4-blog.sh	Sun Jun 07 07:33:12 2020 +0900
     1.2 +++ b/s4-blog.sh	Sun Jun 07 20:44:27 2020 +0900
     1.3 @@ -838,6 +838,7 @@
     1.4      query <<-EOF > $bd/$rid/all-text-1stline-$rid.csv
     1.5  	.mode csv
     1.6  	.head 1
     1.7 +	CREATE TEMPORARY TABLE IF NOT EXISTS tmp_q("user", "TEXT");
     1.8  	.import $outcsv tmp_q
     1.9  	SELECT * FROM tmp_q;
    1.10  	.mode list