emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] Disable fontification when exporting tables


From: Amos Bird
Subject: Re: [O] Disable fontification when exporting tables
Date: Sat, 30 Sep 2017 15:56:37 +0800
User-agent: mu4e 0.9.19; emacs 25.3.1

Thanks!

Nicolas Goaziou <address@hidden> writes:

> Amos Bird <address@hidden> 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,


Amos Bird
address@hidden


reply via email to

[Prev in Thread] Current Thread [Next in Thread]