* NEW [nanomq_rule_engine.conf] update configure file.
## Select the message from the terminal whose username is 'abc', and the output will be all available fields:
+SELECT qos, username, clientid FROM "#" WHERE username = 'abc'
-SELECT qos, username, clientid FROM "#"
-## WHERE username = 'abc'
-
-## Select the message sent from the terminal whose clientid is 'abc', and the output will have only one field of cid.
-## Note that the cid variable is defined in the SELECT statement, so it can be used in the WHERE statement:
-
-SELECT clientid as cid FROM "#" WHERE cid = 'abc'
-
-## Select the message sent from the terminal whose username is 'abc', and the output will have only one field of cid.
-## Note that although only one field of cid is selected in the SELECT statement, all available fields in the message publishing event (such as clientid, username, etc.) can still be used in the WHERE statement:
-
-SELECT clientid as cid FROM "#" WHERE username = 'abc'
-
-## But the following SQL statement will not work, because the variable xyz is neither an available field in the message publishing event nor defined in the SELECT statement:
-
-SELECT clientid as cid FROM "#" WHERE xyz = 'abc'
-
-SELECT * FROM "t/a"
+SELECT * FROM "t/#"
-SELECT * FROM "t/a","t/b"
+SELECT username FROM "#" WHERE username='Steven'
-SELECT * FROM "t/#"
+SELECT clientid FROM "$events/session_subscribed" WHERE topic = 't/#' and qos = 1
SELECT qos, username, clientid FROM "t/#"
-SELECT username FROM "#" WHERE username='Steven'
+## TODO unsupport format for now
+## Select the message sent from the terminal whose clientid is 'abc', and the output will have only one field of cid.
+## Note that the cid variable is defined in the SELECT statement, so it can be used in the WHERE statement:
-SELECT payload FROM "#" WHERE payload.x = 1
+## SELECT clientid as cid FROM "#" WHERE cid = 'abc'
-SELECT payload FROM "#" WHERE payload.x.y = 1
+## SELECT clientid FROM "$events/session_subscribed" WHERE topic =~ 't/#' and qos = 1
-SELECT peername as ip_port FROM "$events/client_connected" WHERE clientid = 'c1'
+## SELECT payload FROM "#" WHERE payload.x = 1
-SELECT clientid FROM "$events/session_subscribed" WHERE topic = 't/#' and qos = 1
+## SELECT payload FROM "#" WHERE payload.x.y = 1
-SELECT clientid FROM "$events/session_subscribed" WHERE topic =~ 't/#' and qos = 1
+## SELECT * FROM "t/a","t/b"
-SELECT qos, username, clientid FROM "t/#"
+## Select the message sent from the terminal whose username is 'abc', and the output will have only one field of cid.
+## Note that although only one field of cid is selected in the SELECT statement, all available fields in the message publishing event (such as clientid, username, etc.) can still be used in the WHERE statement:
+## SELECT clientid as cid FROM "#" WHERE username = 'abc'
+
+## But the following SQL statement will not work, because the variable xyz is neither an available field in the message publishing event nor defined in the SELECT statement:
+## SELECT clientid as cid FROM "#" WHERE xyz = 'abc'
## TODO multi line parse
## SELECT
