File: loans_2_overwrite.sql

package info (click to toggle)
zsv 1.3.0-1
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 49,160 kB
  • sloc: ansic: 175,811; cpp: 56,301; sh: 3,623; makefile: 3,048; javascript: 577; cs: 90; awk: 70; python: 41; sql: 15
file content (9 lines) | stat: -rw-r--r-- 341 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
 
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE overwrites(row int, column int, value text);
INSERT INTO overwrites VALUES(10,4,'hello1');
INSERT INTO overwrites VALUES(10,2,'hello2');
INSERT INTO overwrites VALUES(8,3,'hello3');
INSERT INTO overwrites VALUES(8,15,'hello4');
INSERT INTO overwrites VALUES(8,99999,'never');
COMMIT;