blob: 79f3def432d9c62b4087d926386f4c4c16b0530b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
drop table ìÞÙ¸æñÕè;
create table ìÞÙ¸æñÕè (ÈçäÆɱ text, ÄüƳÍñó¤ varchar, ÇâÉß varchar(16));
create index ìÞÙ¸æñÕèindex1 on ìÞÙ¸æñÕè using btree (ÈçäÆɱ);
create index ìÞÙ¸æñÕèindex2 on ìÞÙ¸æñÕè using hash (ÄüƳÍñó¤);
insert into ìÞÙ¸æñÕè values ('çÙæªäÆ', 'ç®ç®ÒïÊÀ', 'Æ¡A01Äî');
insert into ìÞÙ¸æñÕè values ('êûÝßäÆ', 'ØÂäãÈ´ÓîÄüƳ', 'ÄãB10Äã');
insert into ìÞÙ¸æñÕè values ('ó§ã£äÆ', 'Ó¡ÌÀϴǹȴÓîÄüƳ', 'ØíZ01Ħ');
vacuum ìÞÙ¸æñÕè;
select * from ìÞÙ¸æñÕè;
select * from ìÞÙ¸æñÕè where ÇâÉß = 'ØíZ01Ħ';
select * from ìÞÙ¸æñÕè where ÇâÉß ~* 'Øíz01Ħ';
select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z01_';
select * from ìÞÙ¸æñÕè where ÇâÉß like '_Z%';
select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~ 'ç®ç®Òï[ÙìØ´ÊÀ]';
select * from ìÞÙ¸æñÕè where ÄüƳÍñó¤ ~* 'ç®ç®Òï[ÙìØ´ÊÀ]';
select *, character_length(ÈçäÆɱ) from ìÞÙ¸æñÕè;
select *, octet_length(ÈçäÆɱ) from ìÞÙ¸æñÕè;
select *, position('È´Óî' in ÄüƳÍñó¤) from ìÞÙ¸æñÕè;
select *, substring(ÄüƳÍñó¤ from 3 for 6 ) from ìÞÙ¸æñÕè;
|
