sqlness-cli 0.6.1

SQLNESS command line tool
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

-- https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
DROP TABLE IF EXISTS animals;

affected_rows: 0

CREATE TABLE animals (
     id MEDIUMINT NOT NULL AUTO_INCREMENT,
     name CHAR(30) NOT NULL,
     PRIMARY KEY (id)
);

affected_rows: 0

INSERT INTO animals (name) VALUES
    ('dog'),('cat'),('penguin'),
    ('lax'),('whale'),('ostrich');

affected_rows: 6

SELECT * FROM animals;

id,name,
Some("1"),Some("dog"),
Some("2"),Some("cat"),
Some("3"),Some("penguin"),
Some("4"),Some("lax"),
Some("5"),Some("whale"),
Some("6"),Some("ostrich"),