R SQLite CRUD - Create, Insert, Update, Delete - Querying databases using R programming language

R SQLite CRUD - Create, Insert, Update, Delete - Querying databases using R programming language.

# get packages

# create database connection

# drop table if exists

dbExecute(customerdb, "DROP table customers")

# create table

dbExecute(customerdb, "CREATE TABLE customers (id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT, last_name TEXT, email TEXT)")
dbGetQuery(customerdb, "SELECT * FROM customers")

# insert record

dbExecute(customerdb,
"INSERT INTO customers (first_name, last_name, email)

# update record

dbExecute(customerdb,
"UPDATE customers SET first_name='UpdatedAnkan' WHERE id=1" )
dbGetQuery(customerdb, "SELECT * FROM customers")

# delete record

dbExecute(customerdb,
"DELETE from customers WHERE id=1" )
dbGetQuery(customerdb, "SELECT * FROM customers")

Details of code and presentation file is available on my Github Account @

[StefanoVerugi]

to me, a beginner, this is the best video on the subject, thanks

[richardjones]

Nice clear explanation of exactly what I was looking for. Thanks.