my_qsg_fromdf: dataframe or tibble to MySQL insert query string
In obarisk/sqltools: sqltools

Description Usage Arguments Value Examples

dataframe or tibble to MySQL insert query string

1 2	my_qsg_fromdf(dT, tablename, iLength = 1024, tz = Sys.timezone(), Colnames = TRUE)

`dT,`	a tibble
`tablename,`	table name
`iLength,`	max size(row) counts in KB, default = 1024
`tz,`	timezone
`Colnames,`	boolean whether include colnames inside query string, default = TRUE

a tibble of a segmented insert query string

## Not run: 
  require(tidyverse) 
  mytbl <- tibble(a=c(1, 2, 3, 4), b=c('1', '2', '3', '4'), 
    c=c(Sys.Date(), Sys.Date(), Sys.Date(), Sys.Date()))
  my_qsg_fromdf(mytbl, 'tmp') 

## End(Not run)