Insert into a database

Added by iNTERFACEWARE

Use conn:execute() to insert data into a database table

Source Code
   -- connect to a SQLite database
   conn = db.connect{
      api = db.SQLITE,
      name = 'test',
      live = true
   }   
      
   -- insert data into a database table
   conn:execute('INSERT INTO Patient (FirstName, LastName) VALUES("Fred", "Smith")')
Description
Use conn:execute() to insert data into a database table