From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
To: Amos Bird <amosbird@gmail.com>
Cc: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>
Subject: Re: Disable fontification when exporting tables
Date: Sat, 30 Sep 2017 09:49:13 +0200 [thread overview]
Message-ID: <87a81clj7q.fsf@nicolasgoaziou.fr> (raw)
In-Reply-To: <877ewgskar.fsf@gmail.com> (Amos Bird's message of "Sat, 30 Sep 2017 15:43:56 +0800")
Amos Bird <amosbird@gmail.com> writes:
> | QueryID | SQL Text | Query Time (Seconds) | Query Time Hot (Seconds) |
> |---------+-----------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+--------------------------|
> | Q0 | SELECT avg(c1) from (select Year, Month, count(*) as c1 from ontime group by Year, Month); | 1.27 | 0.13 |
> | Q1 | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC; | 1.23 | 0.21 |
> | Q2 | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE DepDelay>10 AND Year >= 2000 AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC; | 1.4 | 0.25 |
> | Q3 | SELECT Origin, count(*) AS c FROM ontime WHERE DepDelay>10 AND Year >= 2000 AND Year <= 2008 GROUP BY Origin ORDER BY c DESC LIMIT 10; | 5.2 | 0.29 |
> | Q4 | SELECT Carrier, count(*) FROM ontime WHERE DepDelay>10 AND Year = 2007 GROUP BY Carrier ORDER BY count(*) DESC; | 1.0 | 0.09 |
> | Q5 | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE Year = 2007 GROUP BY Carrier ORDER BY Carrier; | 0.12 | 0.04 |
> | Q6 | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE Year >= 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier; | 0.42 | 0.26 |
>
> that is, it contains = characters which breaks the verbatim markup.
Then use `code' markup:
~SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE Year >= 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier;~
which is more appropriate than `verbatim' for SQL code anyway.
> Is there a way to specify the whole column to be verbatim?
No, there isn't.
Regards,
next prev parent reply other threads:[~2017-09-30 7:49 UTC|newest]
Thread overview: 9+ messages / expand[flat|nested] mbox.gz Atom feed top
2017-09-27 8:29 Disable fontification when exporting tables Amos Bird
2017-09-28 18:51 ` Nicolas Goaziou
2017-09-29 2:08 ` Amos Bird
2017-09-29 19:38 ` Nicolas Goaziou
2017-09-30 1:13 ` Amos Bird
2017-09-30 7:36 ` Nicolas Goaziou
2017-09-30 7:43 ` Amos Bird
2017-09-30 7:49 ` Nicolas Goaziou [this message]
2017-09-30 7:56 ` Amos Bird
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87a81clj7q.fsf@nicolasgoaziou.fr \
--to=mail@nicolasgoaziou.fr \
--cc=amosbird@gmail.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).