set readwrite_splitting hint source = [auto / write] | 针对当前连接,设置读写分离的路由策略(自动路由或强制到写库) | set readwrite_splitting hint source = write | RAL |
set sharding hint database_value = yy | 针对当前连接,设置 hint 仅对数据库分片有效,并添加分片值,yy:数据库分片值 | set sharding hint database_value = 100 | RAL |
add sharding hint database_value xx = yy | 针对当前连接,为表 xx 添加分片值 yy,xx:逻辑表名称,yy:数据库分片值 | add sharding hint database_value t_order= 100 | RAL |
add sharding hint table_value xx = yy | 针对当前连接,为表 xx 添加分片值 yy,xx:逻辑表名称,yy:表分片值 | add sharding hint table_value t_order = 100 | RAL |
clear hint | 针对当前连接,清除 hint 所有设置 | clear hint | RAL |
clear [sharding hint / readwrite_splitting hint] | 针对当前连接,清除 sharding 或 readwrite_splitting 的 hint 设置 | clear readwrite_splitting hint | RAL |
show [sharding / readwrite_splitting] hint status | 针对当前连接,查询 sharding 或 readwrite_splitting 的 hint 设置 | show readwrite_splitting hint status | RAL |