create table t1 (a int, KEY (a))ENGINE=NDB;
insert into t1 values (1);
insert into t1 values (2);
insert into t1 values (3);
update t1 set a=a+2 where a=2;
update t1 set a=a+2 where a=3;
create table t2 (word varchar(20), KEY(word))ENGINE=NDB;
load data infile '../std_data_ln/words.dat' into table t2;
select * from t1;
a
1
5
4
select * from t2;
word
Ababa
Aberdeen
abaft
abated
Abbott
abed
abducted
Abe
abase
abbreviate
abduct
Abelson
abandons
abasement
aback
abater
abating
Abel
Abelian
Abernathy
abandons
abandoning
abandoned
Abba
abandonment
Aaron
abandon
abandonment
abased
abatement
abductors
abash
aberration
abdomens
abducts
abduction
abandon
Aarhus
Aaron
abandoning
abases
abdomen
abductions
abbeys
abbreviated
abandoned
abashes
aberrant
abates
Aarhus
abbe
abdominal
abate
abbreviations
Abby
abbreviates
abasing
abbot
aback
abatements
abaft
abashing
Ababa
abbreviation
abasements
abbots
abbreviating
abashed
abbey
abductor
flush logs;
flush logs;
drop table t1;
drop table t2;
select * from t1;
a
1
5
4
select * from t2;
word
abashes
abbreviating
abbeys
Abelson
abed
abbe
abasements
abates
abased
Abel
abandon
abbreviates
abdominal
abash
abaft
abandon
abandoning
abbey
abbots
Abby
abase
abandonment
abandoned
abater
abbreviations
Ababa
abbot
abandons
abasement
aberration
abasing
Abbott
abductions
Aaron
abate
abases
aback
abandoned
aberrant
abbreviation
abatement
Aarhus
abashed
abdomens
Abelian
abbreviated
abducted
abdomen
abandons
abductor
abating
abaft
abducts
aback
abandoning
Aberdeen
abductors
abduct
abatements
Aaron
abandonment
abduction
Ababa
Aarhus
abated
Abe
Abernathy
abbreviate
Abba
abashing
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `a` int(11) DEFAULT NULL,
  KEY `a` (`a`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
SHOW CREATE TABLE t2;
Table	Create Table
t2	CREATE TABLE `t2` (
  `word` varchar(20) DEFAULT NULL,
  KEY `word` (`word`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1
drop table t1;
drop table t2;