2
ERROR: table "ͪߩѦ���" does not exist
3
create table ͪߩѦ��� (��� text, ���ڵ� varchar, ���1A�� char(16));
4
create index ͪߩѦ���index1 on ͪߩѦ��� using btree (���);
5
create index ͪߩѦ���index2 on ͪߩѦ��� using hash (���ڵ�);
6
insert into ͪߩѦ��� values('��ǻ�͵��÷���', 'ѦA01߾');
7
insert into ͪߩѦ��� values('��ǻ�ͱ��Ƚ�', '��B10��');
8
insert into ͪߩѦ��� values('��ǻ�����α���', '��Z01��');
11
��� | ���ڵ� | ���1a��
12
------------------+----------+------------
14
��ǻ�ͱ��Ƚ� | ��B10�� |
15
��ǻ�����α��� | ��Z01�� |
18
select * from ͪߩѦ��� where ���ڵ� = '��Z01��';
19
��� | ���ڵ� | ���1a��
20
------------------+----------+------------
21
��ǻ�����α��� | ��Z01�� |
24
select * from ͪߩѦ��� where ���ڵ� ~* '��z01��';
25
��� | ���ڵ� | ���1a��
26
------------------+----------+------------
27
��ǻ�����α��� | ��Z01�� |
30
select * from ͪߩѦ��� where ���ڵ� like '_Z01_';
31
��� | ���ڵ� | ���1a��
32
------------------+----------+------------
33
��ǻ�����α��� | ��Z01�� |
36
select * from ͪߩѦ��� where ���ڵ� like '_Z%';
37
��� | ���ڵ� | ���1a��
38
------------------+----------+------------
39
��ǻ�����α��� | ��Z01�� |
42
select * from ͪߩѦ��� where ��� ~ '��ǻ��[���]';
43
��� | ���ڵ� | ���1a��
44
------------------+----------+------------
46
��ǻ�ͱ��Ƚ� | ��B10�� |
49
select * from ͪߩѦ��� where ��� ~* '��ǻ��[���]';
50
��� | ���ڵ� | ���1a��
51
------------------+----------+------------
53
��ǻ�ͱ��Ƚ� | ��B10�� |
56
select *,character_length(���) from ͪߩѦ���;
57
��� | ���ڵ� | ���1a�� | character_length
58
------------------+----------+------------+------------------
59
��ǻ�͵��÷��� | ѦA01߾ | | 8
60
��ǻ�ͱ��Ƚ� | ��B10�� | | 7
61
��ǻ�����α��� | ��Z01�� | | 8
64
select *,octet_length(���) from ͪߩѦ���;
65
��� | ���ڵ� | ���1a�� | octet_length
66
------------------+----------+------------+--------------
67
��ǻ�͵��÷��� | ѦA01߾ | | 16
68
��ǻ�ͱ��Ƚ� | ��B10�� | | 14
69
��ǻ�����α��� | ��Z01�� | | 16
72
select *,position('��' in ���) from ͪߩѦ���;
73
��� | ���ڵ� | ���1a�� | position
74
------------------+----------+------------+----------
75
��ǻ�͵��÷��� | ѦA01߾ | | 4
76
��ǻ�ͱ��Ƚ� | ��B10�� | | 0
77
��ǻ�����α��� | ��Z01�� | | 0
80
select *,substring(��� from 3 for 4) from ͪߩѦ���;
81
��� | ���ڵ� | ���1a�� | substring
82
------------------+----------+------------+-----------
83
��ǻ�͵��÷��� | ѦA01߾ | | �͵���
84
��ǻ�ͱ��Ƚ� | ��B10�� | | �ͱ���
85
��ǻ�����α��� | ��Z01�� | | �����α�