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 10 for 4) from ·×»»µ¡ÍÑžì;
|