20 lines
366 B
Plaintext
20 lines
366 B
Plaintext
CREATE TABLE t1 (
|
|
a int PRIMARY KEY,
|
|
b varchar(32),
|
|
c int NOT NULL
|
|
) ENGINE = NDB;
|
|
INSERT INTO t1 VALUES
|
|
(1, "MySQL Server with NDB", 3),
|
|
(3, "The third row", 9),
|
|
(37, "And of course number 37", 37);
|
|
SELECT a FROM t1 WHERE c > 8 ORDER by c;
|
|
a
|
|
3
|
|
37
|
|
ALTER TABLE t1 ALGORITHM=INPLACE, ADD INDEX c_idx1(c);
|
|
SELECT a FROM t1 WHERE c > 8 ORDER by c;
|
|
a
|
|
3
|
|
37
|
|
DROP TABLE t1;
|