美文网首页
关于cratedb的一些记录

关于cratedb的一些记录

作者: 可爸 | 来源:发表于2019-05-24 14:55 被阅读0次

reference -> https://crate.io/docs/crate/reference/en/latest/general/dql/fulltext.html

--create table t5 (name string, index ft_name using fulltext(name) with (analyzer = 'my_pinyin'));

select * from t5 where match(ft_name, 'm') and match(ft_name, 'n') order by _score asc;

upsert
--insert into t03 (id,name) values (1, 'jack') on conflict (id) do update set name = 'role' ;

upsert 老版本
insert into t02 (id,name,name2) values (1, 'ff', 'ff2') on duplicate key update name = 'fuck', name2 = 'fuck2';

--https://crate.io/docs/crate/reference/en/latest/general/ddl/fulltext-indices.html
--https://crate.io/docs/crate/reference/en/latest/general/ddl/analyzers.html
--https://crate.io/docs/clients/python/en/latest/sqlalchemy.html#object

相关文章

网友评论

      本文标题:关于cratedb的一些记录

      本文链接:https://www.haomeiwen.com/subject/xswgzqtx.html