blob: c782b45fdf90c33382df5b895cd1efb188b4fb7e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
SET @rowid = ROUND(RAND() * <num_stress_rows>);
START TRANSACTION;
UPDATE t1 SET b = 'changed' WHERE id=@rowid;
SELECT b FROM t1 WHERE id=@rowid;
b
changed
COMMIT;
START TRANSACTION;
DELETE FROM t1 WHERE id=@rowid;
INSERT INTO t1 (id, b) VALUES (@rowid, 'newly_inserted');
SELECT b FROM t1 WHERE id=@rowid;
b
newly_inserted
COMMIT;
CREATE TABLE tw_<conn_nr> AS SELECT * FROM t1;
DROP TABLE tw_<conn_nr>;
|
