diff options
| author | mistachkin <mistachkin@noemail.net> | 2015-04-07 21:16:40 +0000 |
|---|---|---|
| committer | mistachkin <mistachkin@noemail.net> | 2015-04-07 21:16:40 +0000 |
| commit | 151c75ad89cd946ca22eaddc8ac1a9bb0fb5a1b6 (patch) | |
| tree | 2b5b2643551441f4b1235e89644444de77566cb9 /src | |
| parent | 48cc29a9ac5a167ca37d9ff17b2cd652d08fd6f3 (diff) | |
| download | sqlite-151c75ad89cd946ca22eaddc8ac1a9bb0fb5a1b6.tar.gz sqlite-151c75ad89cd946ca22eaddc8ac1a9bb0fb5a1b6.zip | |
Enhance the shell export to support emitting column names in 'insert' mode when headers are enabled.
FossilOrigin-Name: 6e504cd00b148b5acca73f039a20b8acc85dc2f0
Diffstat (limited to 'src')
| -rw-r--r-- | src/shell.c | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/src/shell.c b/src/shell.c index cfaa2a4cf..b263de926 100644 --- a/src/shell.c +++ b/src/shell.c @@ -989,7 +989,16 @@ static int shell_callback( case MODE_Insert: { p->cnt++; if( azArg==0 ) break; - fprintf(p->out,"INSERT INTO %s VALUES(",p->zDestTable); + fprintf(p->out,"INSERT INTO %s",p->zDestTable); + if( p->showHeader ){ + fprintf(p->out,"("); + for(i=0; i<nArg; i++){ + char *zSep = i>0 ? ",": ""; + fprintf(p->out, "%s%s", zSep, azCol[i]); + } + fprintf(p->out,")"); + } + fprintf(p->out," VALUES("); for(i=0; i<nArg; i++){ char *zSep = i>0 ? ",": ""; if( (azArg[i]==0) || (aiType && aiType[i]==SQLITE_NULL) ){ |