Skip to content
Fx_demon edited this page Nov 16, 2018 · 11 revisions

注解用法

查询:/*!mycat:dataNode = dn1 / SELECT * FROM cont /!mycat:dataNode = dn1 */ SELECT * FROM cont

插入: /*!mycat:dataNode = dn1 / insert INTO cont (taobaoId,name) VALUES (111,'db1') /!mycat:dataNode = dn2 / insert INTO cont (taobaoId,name) VALUES (111,'db2') /!mycat:dataNode = dn3 */ insert INTO cont (taobaoId,name) VALUES (111,'db3')

查询 /*!mycat:schema = TESTDB */ SELECT * FROM cont ;

Catlet使用 /*!mycat:catlet=io.mycat.catlets.ShareJoin */ select * from cont db1 join cont db2 on b.id=a.days order by a.id ;

**## 分布式数据库-监控 MyCat技术交流 业务合作等 ** ## QQ群 419648337

Clone this wiki locally