Skip to content
Snippets Groups Projects

sql insert example

  • Clone with SSH
  • Clone with HTTPS
  • Embed
  • Share
    The snippet can be accessed without any authentication.
    Authored by Tobiah Nott

    add's mary's info into table

    Edited
    mary.sql 859 B
    INSERT into graves('name','geoCode','lat','long','info','picPath') VALUES ('Mary Grant', 'FCD 45. 25', '51.58247', '-3.01658', 'Aged 5217th November 1868Mary Grant was bayonetted outside her home in Newport by soldiers of 23rd Royal Welsh Fusiliers following a ‘riot’ outside the town hall during the elections.A large crowd had gathered outside the town hall where tensions were high, windows were being smashed and the mayor ordered the soldiers to break up the crowd. The crowd split with one section heading north towards Baneswell, as the crowd were being chased by the soldiers with their bayonets drawn along Baneswell Road, Mary Grant was attempting to step into their home but was stabbed as the soldiers ran went by and was killed instantly, her son Charles also received a fatal wound that led to his death seven months later. (Aged 27)', NULL)
    • image

      correctly inserts with sqlite

      Edited by Tobiah Nott
    0% Loading or .
    You are about to add 0 people to the discussion. Proceed with caution.
    Finish editing this message first!
    Please register or to comment