# Searching for updated database tutorial
**URL:** https://discourse.julialang.org/t/searching-for-updated-database-tutorial/70421
**Category:** New to Julia
**Tags:** mysql, tutorials
**Created:** [October 26, 2021, 6:05pm UTC](https://discourse.julialang.org/t/searching-for-updated-database-tutorial/70421 "2021-10-26T18:05:19Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@miko](https://discourse.julialang.org/u/miko)
#### Post date: [October 26, 2021, 6:05pm UTC](https://discourse.julialang.org/t/searching-for-updated-database-tutorial/70421/1 "2021-10-26T18:05:19Z")
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?
---
### Author:  [@zweiglimmergneis](https://discourse.julialang.org/u/zweiglimmergneis)
#### Post date: [October 26, 2021, 8:09pm UTC](https://discourse.julialang.org/t/searching-for-updated-database-tutorial/70421/2 "2021-10-26T20:09:37Z")
Hi Miko, if you are looking for first steps…
```julia
julia> using MySQL, DataFrames
julia> dbconn = DBInterface.connect(MySQL.Connection, "127.0.0.1", "wiag", "secret pwd", db = "wiag2")
```
This opens a database connection on host 127.0.0.1 (localhost) for user “wiag” identified with “secret pwd” on database “wiag2”. Then you can use the connection for queries or any other SQL-statement:
```julia
julia> sql = "SELECT id, givenname, familyname FROM person LIMIT 12"
julia> df_p = DBInterface.execute(dbconn, sql) |> DataFrame;
julia> df_p
12×3 DataFrame
Row │ id givenname familyname
│ Int32 String String?
─────┼──────────────────────────────
1 │ 80 Ortlieb Brandis
2 │ 81 Jean Bourgeois
3 │ 82 Louis Bourbon
4 │ 83 Radbod missing
5 │ 84 Egilbert missing
6 │ 85 Adelbold missing
7 │ 86 Alfrid missing
8 │ 87 Hunger missing
9 │ 88 Liudger missing
10 │ 89 Eginhard missing
11 │ 90 Alberich missing
12 │ 91 Friedrich missing
```
The result of the query is used here to create a `DataFrame`.
As an alternative you may want to iterate over the result set:
```julia
julia> qi = DBInterface.execute(dbconn, sql);
julia> for row in qi
println(row[:id], " ", row[:givenname])
end
80 Ortlieb
81 Jean
82 Louis
83 Radbod
84 Egilbert
85 Adelbold
86 Alfrid
87 Hunger
88 Liudger
89 Eginhard
90 Alberich
91 Friedrich
```
---
### Author:  [@miko](https://discourse.julialang.org/u/miko)
#### Post date: [October 27, 2021, 7:41am UTC](https://discourse.julialang.org/t/searching-for-updated-database-tutorial/70421/3 "2021-10-27T07:41:03Z")
Thank you!