Output the mysql query results in rmarkdown

Question

I am getting crazy because I have written a sql query under the RMySQL package in a rmarkdown document and I dont get the output of the query in the document, but yes in the code editor. I want to know how to get the output in the my document.

I need help because I search much around the web and I found nothing.

Hi there, can you please clarify a few things. Which editor are you using, and why are you expecting to see the results of a query in a static markdown document? Is it simply that you want to write a query in the editor and have the editor replace it with the results? — Clint, Nov 28 '16 at 21:28
Hi =). I was using rstudio and I was written in rmarkdown, and I want that outputs me the result and the query in the result document =). — Raul Contreras, Nov 29 '16 at 08:04

score 0 · Answer 1 · answered Nov 29 '16 at 10:15

0

You want to use the code chunk feature instead of inline code, as detailed in the documentation for rmarkdown here:

Code Chunks

This differs from inline code, in that the results can be put in the document as well as the query itself.

answered Nov 29 '16 at 10:15

Clint

6,133
2
27
48

I posted an image in web, I have, in fact, written a code chunk but I dont get the output of the sentence: http://es.tinypic.com/view.php?pic=2rc9avn&s=9#.WD1hu-bhCM8. Here is what I want to make, thanks for the help =) – Raul Contreras Nov 29 '16 at 11:10
@RaulContreras try adding the Include=True option as mentioned on the page. – Clint Nov 29 '16 at 12:23
When I pass this option happens that not ouputs me the chunk but also the result – Raul Contreras Nov 29 '16 at 13:09
@RaulContreras so you only want the results and not the SQL query? – Clint Nov 29 '16 at 13:47
I want both of them, the result and the query – Raul Contreras Nov 29 '16 at 15:04
@RaulContreras as per the documentation I provided, it looks like you need include=true and echo=true – Clint Nov 29 '16 at 15:09

Output the mysql query results in rmarkdown

1 Answers1