tag
一. tag
{$SchemaName} : SchemaName
{$TableName} : TableName
{$EventType} : event type; insert,update,delete,sql,commit
{$Timestamp} : now timestamp
{$BinlogTimestamp} : Binlog timestamp
{$BinlogFileNum} : The binlog file number
{$BinlogPosition} : The binlog position
{$fieldName} : the field value
{$fieldName[‘key1’][0][‘key3’]} :
Example:
FieldName : my_json
DataType: json
Data :
{“testK”: [{“Bool”: false, “Null”: null, “Time”: “2020-05-31 23:21:30”, “Int32”: -2147483648, “Int64”: -9223372036854775808, “String”: “ss”, “Uint32”: 4294967295, “Uint64”: 18446744073709551615, “Float64”: 526637.46}]}
{$my_json[‘testK’][0][‘Time’]} => 2020-05-31 23:21:30