Shulou(Shulou.com)06/01 Report--

MySQL Query Rules

Here is the statement used to create the mysql_query_rules table:

CREATE TABLE mysql_query_rules (

Rule_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL

Active INT CHECK (active IN (0Pol 1)) NOT NULL DEFAULT 0

Username VARCHAR

Schemaname VARCHAR

FlagIN INT NOT NULL DEFAULT 0

Client_addr VARCHAR

Proxy_addr VARCHAR

Proxy_port INT

Digest VARCHAR

Match_digest VARCHAR

Match_pattern VARCHAR

Negate_match_pattern INT CHECK (negate_match_pattern IN (0Pol 1)) NOT NULL DEFAULT 0

Re_modifiers VARCHAR DEFAULT 'CASELESS'

FlagOUT INT

Replace_pattern VARCHAR

Destination_hostgroup INT DEFAULT NULL

Cache_ttl INT CHECK (cache_ttl > 0)

Reconnect INT CHECK (reconnect IN (0Pol 1)) DEFAULT NULL

Timeout INT UNSIGNED

Retries INT CHECK (retries > = 0 AND retries

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.