| 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 ìÞÙ¸æñÕè; |