Skip to content

Instantly share code, notes, and snippets.

@jujhars13

jujhars13/wonky-insert-script.sh

Created November 21, 2022 11:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jujhars13/7ac35538d4620f5570d60c50419c0c5d to your computer and use it in GitHub Desktop.
Save jujhars13/7ac35538d4620f5570d60c50419c0c5d to your computer and use it in GitHub Desktop.
Download ZIP
insert into sqlite demo
Raw
wonky-insert-script.sh
#!/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