Path:/zh-CN/docs/2.1/data-operate/transaction
连接: jdbc:mysql://127.0.0.1:9030?useUnicode=true&characterEncoding=utf8&useTimezone=true&useSSL=false&allowPublicKeyRetrieval=true&useLocalSessionState=true
sql:
CREATE TABLE dt (
id INT(11) NOT NULL,
name VARCHAR(50) NULL,
score INT(11) NULL
) ENGINE=OLAP
UNIQUE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
"replication_num" = "1"
);
select * from dt;
BEGIN;
INSERT INTO dt (id, name, score) VALUES (1, "Emily", 25), (2, "Benjamin", 35), (3, "Olivia", 28), (4, "Alexander", 60), (5, "Ava", 17);
INSERT INTO dt VALUES (6, "William", 69), (7, "Sophia", 32), (8, "James", 64), (9, "Emma", 37), (10, "Liam", 64);
COMMIT;
Path:/zh-CN/docs/2.1/data-operate/transaction
连接: jdbc:mysql://127.0.0.1:9030?useUnicode=true&characterEncoding=utf8&useTimezone=true&useSSL=false&allowPublicKeyRetrieval=true&useLocalSessionState=true
sql:
CREATE TABLE
dt(idINT(11) NOT NULL,nameVARCHAR(50) NULL,scoreINT(11) NULL) ENGINE=OLAP
UNIQUE KEY(
id)DISTRIBUTED BY HASH(
id) BUCKETS 1PROPERTIES (
"replication_num" = "1"
);
select * from dt;
BEGIN;
INSERT INTO dt (id, name, score) VALUES (1, "Emily", 25), (2, "Benjamin", 35), (3, "Olivia", 28), (4, "Alexander", 60), (5, "Ava", 17);
INSERT INTO dt VALUES (6, "William", 69), (7, "Sophia", 32), (8, "James", 64), (9, "Emma", 37), (10, "Liam", 64);
COMMIT;