File: insert_statements.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (18 lines) | stat: -rw-r--r-- 416 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
INSERT INTO kv VALUES ('A');

INSERT INTO kv (v) VALUES ('a');

INSERT INTO kv (k) VALUES ('nil1');

INSERT INTO kv (k) VALUES ('nil2');

INSERT INTO kv VALUES ('nil3', NULL);

INSERT INTO kv VALUES ('nil4', NULL);

INSERT INTO kv (k,v) VALUES ('a', 'b'), ('c', 'd');

-- RETURNING
INSERT INTO t (a) VALUES (10) RETURNING b;
INSERT INTO t VALUES (7, 8) RETURNING (SELECT 1);
INSERT INTO t VALUES (7, 8) RETURNING z;