Skip to main content

Questions tagged [sql]

{sql} is about questions related to the SQL language and TeX.

Filter by
Sorted by
Tagged with
7 votes
4 answers
307 views

LaTeX listings package: SQL comments defined by '--'

I am not able to both Change the color of comments marked by --, AND DO NOT replace hyphens (-) by the minus (−) sign. A MRE follows. \documentclass{report} \usepackage{xcolor} \usepackage{listings}...
Esteban Zimanyi's user avatar
3 votes
1 answer
895 views

What are good ways to convert SQL query results into a LaTeX table?

Background I'm doing some data analysis on a large dataset on a local SQL server. A substantial proportion of that analysis is tabular stuff: frequency tables and the like which summarize various ...
logjammin's user avatar
  • 215
4 votes
2 answers
822 views

Is any TeX able to load data from SQL database?

I am still a novice in this field, writing only basic papers with Tex. Altough my question may still lay beyond my practice I would like to ask if any Tex is able to load data (texts and pictures ...
John's user avatar
  • 41
2 votes
1 answer
100 views

Accessing sqlite3 with xparse (under XeLaTeX)

I was very happy when I read egreg's 2019 Addendum about how to launch a shell script from LaTeX and grab the output. But when I tried to use it to connect with a SQLite database, I got a LaTeX3 error....
yannis's user avatar
  • 2,013
0 votes
0 answers
118 views

How connect nlatexdb with database hosted with XAMPP?

I'm trying to connect with a database I create with XAMPP. I think it's mysql, and tried MySql.Data.MySqlClient, but not connect. Gives Unable to find the requested .Net Framework Data Provider. It ...
Jean Pimenta's user avatar
0 votes
0 answers
1k views

Undefined control sequence error in lstlisting

I trying to add SQL code in my document. I used the following piece of code. \documentclass[12pt]{article} \usepackage{amsmath, amssymb,amsthm,verbatim} \usepackage{color} \usepackage{xcolor} \...
deb's user avatar
  • 101
1 vote
1 answer
297 views

Bold keyword in listing, but deletekeywords does not seem to work

I'm using the lstlisting package to write down the SQL queries. However, the word character appear in bold, because it is considered a keyword. I added it to the list of keyword to remove ...
Paulo Rodrigo Martins's user avatar
0 votes
1 answer
3k views

include sql files and use minted for highlighting

I write in latex a documentation about a database project. I would like to include some sql files in my latex document and highlight this files with minted. My initial approach is the following, ...
Volker Raschek's user avatar
1 vote
0 answers
222 views

Can't use SQL to format date in LuaLaTeX with LuaSQL & passing parameters to compiler

I am working on a LuaLaTeX example where date has to be transferred from my database using Lua and then compiled using LuaLaTeX. I am using LuaSQL to do all this and this is the minimal working ...
71GA's user avatar
  • 3,573
1 vote
1 answer
3k views

Modify the lstlisting frame and properties

This is my options for the lstlisting ambient: \lstset{language=SQL,frame=ltrb, keywordstyle=\ttfamily\color{OliveGreen}, identifierstyle=\ttfamily\color{CadetBlue}\bfseries, ...
user avatar
1 vote
1 answer
398 views

pgfplots with SQL data

I was wondering whether it is possible to retrieve data directly from SQL to generate *.dat file and draw plots with pgfplots, like for example: \documentclass{article} \usepackage{pgfplots} \...
unmark1's user avatar
  • 469