1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
drop table ͪߩъ¿ëŸî;
create table ͪߩъ¿ëŸî (¿ëŸî text, ÝÂןÄÚµå varchar, ºñ°í1A¶ó±ž char(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 4) from ͪߩъ¿ëŸî;
|