Skip to content

Instantly share code, notes, and snippets.

@jujhars13
Created November 21, 2022 11:08
Show Gist options
  • Save jujhars13/7ac35538d4620f5570d60c50419c0c5d to your computer and use it in GitHub Desktop.
Save jujhars13/7ac35538d4620f5570d60c50419c0c5d to your computer and use it in GitHub Desktop.
insert into sqlite demo
#!/bin/bash
echo "SELECT * FROM people" | sqlite3 person.sqlite
echo "INSERT INTO people (firstName,lastName)
VALUES
('john', 'marsden-"{$RANDOM_ID}"')
" | sqlite3 person.sqlite
echo "SELECT * FROM people" | sqlite3 person.sqlite
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment