add_blob_column | R Documentation |
Add named empty blob column to SQLite database
add_blob_column(column_name, table_name, conn)
column_name |
A string of the name of the BLOB column. |
table_name |
A string of the name of the existing table. |
conn |
A SQLite connection object. |
Modified SQLite database.
conn <- DBI::dbConnect(RSQLite::SQLite(), ":memory:") DBI::dbWriteTable(conn, "Table1", data.frame(IntColumn = c(1L, 2L))) DBI::dbReadTable(conn, "Table1") add_blob_column("BlobColumn", "Table1", conn) DBI::dbReadTable(conn, "Table1") DBI::dbDisconnect(conn)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.