blob: b27c0ee028cc12212f425a28ff8b4d81df90f496 (
plain)
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
|
drop table if exists t1, t2, t3;
create table t1 (_id int, a int, primary key (_id) using hash);
insert into t1 values(null, 100);
ERROR 23000: Column '_id' cannot be null
insert ignore into t1 values(1,100);
Warnings:
Warning 1265 Data truncated for column '_id' at row 1
insert ignore into t1 values(1,100);
Warnings:
Warning 1265 Data truncated for column '_id' at row 1
insert ignore into t1 values(1,100);
Warnings:
Warning 1265 Data truncated for column '_id' at row 1
insert ignore into t1 values(1,100);
Warnings:
Warning 1265 Data truncated for column '_id' at row 1
select * from t1;
_id a
1 100
2 100
3 100
4 100
select * from t1 where _id = 2;
_id a
2 100
select * from t1 where _id = 20;
_id a
drop table t1;
|