insert_into_db: To insert new values inside the MySQL table

Description Usage Arguments Value

View source: R/database_functions.R

Description

To insert new values inside the MySQL table

Usage

1
2
3
4
5
6
7
8
insert_into_db(
  table_name,
  values,
  db_name = default_db_name,
  host_name = default_host_name,
  host_password = default_host_password,
  host_ip = default_host_ip
)

Arguments

table_name

A string which contains the MySQL table name where the data has to be inserted

values

A tbl_df/tbl/data.frame which is the same structure as the MySQL table

db_name

A string which contains the name of the database

host_name

A string which contains the username to access the database

host_password

A string which contains the password to access the database

host_ip

A string which contains the host address of the database

Value

Returns the result obtained after the insert, NULL if the data was inserted successfully


vedhav/shipdashboard documentation built on Jan. 1, 2021, 12:37 p.m.