sql insert example
The snippet can be accessed without any authentication.
Authored by
Tobiah Nott
add's mary's info into table
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)
Please register or sign in to comment