| drop table ÓËãCÓÃÕZ; |
| create table ÓËãCÓÃÕZ (ÓÃÕZ text, ·Ö©`¥É varchar, 俼1A¤À¤è char(16)); |
| create index ÓËãCÓÃÕZindex1 on ÓËãCÓÃÕZ using btree (ÓÃÕZ); |
| create index ÓËãCÓÃÕZindex2 on ÓËãCÓÃÕZ using hash (·Ö©`¥É); |
| insert into ÓËãCÓÃÕZ values('¥³¥ó¥Ô¥å©`¥¿¥Ç¥£¥¹¥×¥ì¥¤','CA01ÉÏ'); |
| insert into ÓËãCÓÃÕZ values('¥³¥ó¥Ô¥å©`¥¿¥°¥é¥Õ¥£¥Ã¥¯¥¹','·ÖB10ÖÐ'); |
| insert into ÓËãCÓÃÕZ values('¥³¥ó¥Ô¥å©`¥¿¥×¥í¥°¥é¥Þ©`','ÈËZ01ÏÂ'); |
| vacuum ÓËãCÓÃÕZ; |
| select * from ÓËãCÓÃÕZ; |
| select * from ÓËãCÓÃÕZ where ·Ö©`¥É = 'ÈËZ01ÏÂ'; |
| select * from ÓËãCÓÃÕZ where ·Ö©`¥É ~* 'ÈËz01ÏÂ'; |
| select * from ÓËãCÓÃÕZ where ·Ö©`¥É like '_Z01_'; |
| select * from ÓËãCÓÃÕZ where ·Ö©`¥É like '_Z%'; |
| select * from ÓËãCÓÃÕZ where ÓÃÕZ ~ '¥³¥ó¥Ô¥å©`¥¿[¥Ç¥°]'; |
| select * from ÓËãCÓÃÕZ where ÓÃÕZ ~* '¥³¥ó¥Ô¥å©`¥¿[¥Ç¥°]'; |
| select *,character_length(ÓÃÕZ) from ÓËãCÓÃÕZ; |
| select *,octet_length(ÓÃÕZ) from ÓËãCÓÃÕZ; |
| select *,position('¥Ç' in ÓÃÕZ) from ÓËãCÓÃÕZ; |
| select *,substring(ÓÃÕZ from 10 for 4) from ÓËãCÓÃÕZ; |
