プログラム
フォルダー構造
$ tree -a
.
├── .env
├── config_mariadb.jl
└── maria_delete.jl
maria_delete.jl
#! /usr/bin/julia
#
# maria_delete.jl
#
# Feb/24/2023
# --------------------------------------------------------------------
using MySQL
include("config_mariadb.jl")
# --------------------------------------------------------------------
println(stderr,"*** 開始 ***")
key_in = ARGS[1]
println(key_in)
host, user, password, data_base = config_mariadb_proc()
conn =DBInterface.connect(MySQL.Connection, host, user, password)
command = "delete from " * data_base * ".cities where id = '" * key_in * "'"
println(command)
#
results = DBInterface.execute(conn,command)
println(results)
#
DBInterface.close!(conn)
#
println(stderr,"*** 終了 ***")
# --------------------------------------------------------------------
.env
config_mariadb.jl
はこちら
Julia: MariaDB のバージョンを表示
確認したバージョン
$ julia -v
julia version 1.8.5