# \#mysql

**URL:** https://discourse.julialang.org/tag/mysql/26.md

[Latest](https://discourse.julialang.org/latest.md) · [Categories](https://discourse.julialang.org/categories.md) · [Tags](https://discourse.julialang.org/tags.md)

---

## [What package to use for simple SQL query in different types of database](https://discourse.julialang.org/t/what-package-to-use-for-simple-sql-query-in-different-types-of-database/57868)

<div class="topic-metadata">

**Author:** [@Laco\_Kovac](https://discourse.julialang.org/u/Laco_Kovac)\
**Replies:** 13\
**Last updated:** [June 14, 2024, 12:18pm UTC](https://discourse.julialang.org/t/what-package-to-use-for-simple-sql-query-in-different-types-of-database/57868 "2024-06-14T12:18:25Z")

</div>

I need to execute simple SQL (e.g. SELECT \* FROM table) and fetch the returned data, but the database could be 1 of 4 types: PostgreSQL, MySQL, MariaDB and MS SQL Server. Ideally, I would like to use a package which dea…

---

## [Batch insertion using MySQL.jl](https://discourse.julialang.org/t/batch-insertion-using-mysql-jl/115938)

<div class="topic-metadata">

**Author:** [@tom-plaa](https://discourse.julialang.org/u/tom-plaa)\
**Replies:** 1\
**Last updated:** [June 21, 2024, 12:58pm UTC](https://discourse.julialang.org/t/batch-insertion-using-mysql-jl/115938 "2024-06-21T12:58:56Z")

</div>

I am trying to change some functions that insert into my MariaDB database so that they will work in batches instead of row-by-row. I am having somewhat of a hard time because I don’t really understand how to prepare stat…

---

## [UndefRefError - Trying access variable inside for](https://discourse.julialang.org/t/undefreferror-trying-access-variable-inside-for/106963)

<div class="topic-metadata">

**Author:** [@th.simoes](https://discourse.julialang.org/u/th.simoes)\
**Replies:** 0\
**Last updated:** [November 30, 2023, 8:30pm UTC](https://discourse.julialang.org/t/undefreferror-trying-access-variable-inside-for/106963 "2023-11-30T20:30:10Z")

</div>

I’m using DBInterface and MySQL to interact with my MySQL database, but my function is stucking into a strange error. This function below works well, but is slow and inefficient: function insertNewDebDataIntoDatabase(d…

---

## [DBInterface or MySQL.jl problem?](https://discourse.julialang.org/t/dbinterface-or-mysql-jl-problem/97084)

<div class="topic-metadata">

**Author:** [@Ronneesley](https://discourse.julialang.org/u/Ronneesley)\
**Replies:** 2\
**Last updated:** [April 5, 2023, 2:26am UTC](https://discourse.julialang.org/t/dbinterface-or-mysql-jl-problem/97084 "2023-04-05T02:26:25Z")

</div>

Hello, When I execute two queries, the first result becomes random. Given the database: create database test; use test; create table person ( id int auto\_increment, name varchar(100), primary key (id) ); create …

---

## [Save data into mysql database in batch mode on transaction basis](https://discourse.julialang.org/t/save-data-into-mysql-database-in-batch-mode-on-transaction-basis/95838)

<div class="topic-metadata">

**Author:** [@Sandy45](https://discourse.julialang.org/u/Sandy45)\
**Replies:** 2\
**Last updated:** [March 13, 2023, 4:43am UTC](https://discourse.julialang.org/t/save-data-into-mysql-database-in-batch-mode-on-transaction-basis/95838 "2023-03-13T04:43:13Z")

</div>

I am trying to load data(from df) into mysql database in batch mode, Loading should be on single transaction and data should be rolled back if load fails at any stage during batch processing. I’ve coded currently by usin…

---

## [TLS Version is not supported MySQL error](https://discourse.julialang.org/t/tls-version-is-not-supported-mysql-error/84422)

<div class="topic-metadata">

**Author:** [@Mitch](https://discourse.julialang.org/u/Mitch)\
**Replies:** 7\
**Last updated:** [July 28, 2022, 12:05pm UTC](https://discourse.julialang.org/t/tls-version-is-not-supported-mysql-error/84422 "2022-07-28T12:05:59Z")

</div>

Hi everyone, I have an Azure MySQL Database I’m trying to connect to using: DBInterface.connect(MySQL.Connection, host, user, pass, db = dbname); host, user, pass and dbname are string inputs. I’m receiving the error…

---

## [Configurate database connection (APP created with Genie)](https://discourse.julialang.org/t/configurate-database-connection-app-created-with-genie/71918)

<div class="topic-metadata">

**Author:** [@fms-1988](https://discourse.julialang.org/u/fms-1988)\
**Replies:** 9\
**Last updated:** [November 23, 2021, 9:07pm UTC](https://discourse.julialang.org/t/configurate-database-connection-app-created-with-genie/71918 "2021-11-23T21:07:02Z")

</div>

I bootstrapped an APP using Genie. I chose the MySQL DB. I edited the db/connection.yml file as required: env: ENV\["GENIE\_ENV"\] dev: adapter: MySQL database: db host: localhost username: felipe password:…

---

## [Searching for updated database tutorial](https://discourse.julialang.org/t/searching-for-updated-database-tutorial/70421)

<div class="topic-metadata">

**Author:** [@miko](https://discourse.julialang.org/u/miko)\
**Replies:** 2\
**Last updated:** [October 27, 2021, 7:41am UTC](https://discourse.julialang.org/t/searching-for-updated-database-tutorial/70421 "2021-10-27T07:41:03Z")

</div>

It seems that Julia database tutorials that are on the web are outdated. Are there any simple examples of Julia and, say, MySQL.jl usage?

---

## [SSL with MYSQL.jl](https://discourse.julialang.org/t/ssl-with-mysql-jl/37928)

<div class="topic-metadata">

**Author:** [@victora](https://discourse.julialang.org/u/victora)\
**Replies:** 0\
**Last updated:** [April 20, 2020, 8:58pm UTC](https://discourse.julialang.org/t/ssl-with-mysql-jl/37928 "2020-04-20T20:58:31Z")

</div>

Hello everyone - I have been trying unsuccessfully to connect to a mysql db in a jupyter notebook with the following: ( using JuliaPro install ) # connecting to mysql using MySQL, DBInterface, Tables, DataFrames conn = …

---

## [MySQL.jl Not Installing](https://discourse.julialang.org/t/mysql-jl-not-installing/37622)

<div class="topic-metadata">

**Author:** [@dburch](https://discourse.julialang.org/u/dburch)\
**Replies:** 3\
**Last updated:** [April 18, 2020, 4:42pm UTC](https://discourse.julialang.org/t/mysql-jl-not-installing/37622 "2020-04-18T16:42:11Z")

</div>

I am not able to install the MySQL.jl package. I am using Julia version 1.0.5. Here is the error: (v1.0) pkg\> add MySQL Resolving package versions... ERROR: Error when installing package LibSSH2\_jll: HTTP.ExceptionRequ…

---

## [JDBC 2 Concurrent Connections](https://discourse.julialang.org/t/jdbc-2-concurrent-connections/37608)

<div class="topic-metadata">

**Author:** [@dburch](https://discourse.julialang.org/u/dburch)\
**Replies:** 1\
**Last updated:** [April 18, 2020, 1:04pm UTC](https://discourse.julialang.org/t/jdbc-2-concurrent-connections/37608 "2020-04-18T13:04:22Z")

</div>

I am able to use JDBC to connect to an Oracle DB or a MySQL DB. It works great. Now I am trying to connect to both databases at the same time. How do I do that? Can I use two different drivers at the same time? Here’s a…

---

## [Problem with MySQL](https://discourse.julialang.org/t/problem-with-mysql/29313)

<div class="topic-metadata">

**Author:** [@Andrea\_Pagnani](https://discourse.julialang.org/u/Andrea_Pagnani)\
**Replies:** 2\
**Last updated:** [September 30, 2019, 11:17am UTC](https://discourse.julialang.org/t/problem-with-mysql/29313 "2019-09-30T11:17:04Z")

</div>

Dearests, I have a connect problem with MySQL.jl. I’m writing a module that do some custom queries to a local mysql database. It looks like: module PfamDatabaseTools global connection = MySQL.connect("127.0.0.1","myna…

---

## [MySQL error while precompling](https://discourse.julialang.org/t/mysql-error-while-precompling/885)

<div class="topic-metadata">

**Author:** [@Christopher\_Fisher](https://discourse.julialang.org/u/Christopher_Fisher)\
**Replies:** 10\
**Last updated:** [April 15, 2017, 2:56pm UTC](https://discourse.julialang.org/t/mysql-error-while-precompling/885 "2017-04-15T14:56:57Z")

</div>

Hi all- I am using Julia .5 on Ubuntu 16.04. When I try to use MySQL I get the following message. Is there something else I need to configure? Thanks, Chris ERROR: LoadError: LoadError: MYSQL library not found in ma…

---

## [Just added AnyChart JS Charts integration template for data visualization with Julia and MySQL](https://discourse.julialang.org/t/just-added-anychart-js-charts-integration-template-for-data-visualization-with-julia-and-mysql/1202)

<div class="topic-metadata">

**Author:** [@andreykh](https://discourse.julialang.org/u/andreykh)\
**Replies:** 2\
**Last updated:** [December 30, 2016, 7:55am UTC](https://discourse.julialang.org/t/just-added-anychart-js-charts-integration-template-for-data-visualization-with-julia-and-mysql/1202 "2016-12-30T07:55:27Z")

</div>

We at AnyChart JS Charts have just released a series of 20+ integration templates to help web developers add interactive charts, maps and dashboards to HTML5 apps faster with various popular technology stacks. In partic…