1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
|
query : ****************************
sql : ----------------------------
UPDATE mysql.db SET db.name='new'
------------------------------------
query_type : MYX_QT_UPDATE
options(0) :
tables(1) :
-------------------------------
table "system"."mysql"."db" ()
fullname= "mysql.db"
charset= "utf8"
columns(15) :
column "Host", cs(utf8_bin) is pk
column "Db", cs(utf8_bin) is pk
column "User", cs(utf8_bin) is pk
column "Select_priv", cs(utf8_bin) is not pk
column "Insert_priv", cs(utf8_bin) is not pk
column "Update_priv", cs(utf8_bin) is not pk
column "Delete_priv", cs(utf8_bin) is not pk
column "Create_priv", cs(utf8_bin) is not pk
column "Drop_priv", cs(utf8_bin) is not pk
column "Grant_priv", cs(utf8_bin) is not pk
column "References_priv", cs(utf8_bin) is not pk
column "Index_priv", cs(utf8_bin) is not pk
column "Alter_priv", cs(utf8_bin) is not pk
column "Create_tmp_table_priv", cs(utf8_bin) is not pk
column "Lock_tables_priv", cs(utf8_bin) is not pk
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(0)
clauses(2)
clause (7,16) doesn't end with linebreak
clause_type MYX_QCT_UPDATE_CLAUSE
clause : -------------------------
mysql.db
------------------------------------
clause (20,33) doesn't end with linebreak
clause_type MYX_QCT_SET_CLAUSE
clause : -------------------------
db.name='new'
------------------------------------
subqueries(0)
params_num 0
query : ****************************
sql : ----------------------------
UPDATE mysql.db SET db.name='a' WHERE db.host='b'
------------------------------------
query_type : MYX_QT_UPDATE
options(0) :
tables(1) :
-------------------------------
table "system"."mysql"."db" ()
fullname= "mysql.db"
charset= "utf8"
columns(15) :
column "Host", cs(utf8_bin) is pk
column "Db", cs(utf8_bin) is pk
column "User", cs(utf8_bin) is pk
column "Select_priv", cs(utf8_bin) is not pk
column "Insert_priv", cs(utf8_bin) is not pk
column "Update_priv", cs(utf8_bin) is not pk
column "Delete_priv", cs(utf8_bin) is not pk
column "Create_priv", cs(utf8_bin) is not pk
column "Drop_priv", cs(utf8_bin) is not pk
column "Grant_priv", cs(utf8_bin) is not pk
column "References_priv", cs(utf8_bin) is not pk
column "Index_priv", cs(utf8_bin) is not pk
column "Alter_priv", cs(utf8_bin) is not pk
column "Create_tmp_table_priv", cs(utf8_bin) is not pk
column "Lock_tables_priv", cs(utf8_bin) is not pk
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(0)
clauses(3)
clause (7,16) doesn't end with linebreak
clause_type MYX_QCT_UPDATE_CLAUSE
clause : -------------------------
mysql.db
------------------------------------
clause (20,32) doesn't end with linebreak
clause_type MYX_QCT_SET_CLAUSE
clause : -------------------------
db.name='a'
------------------------------------
clause (38,49) doesn't end with linebreak
clause_type MYX_QCT_WHERE_CLAUSE
clause : -------------------------
db.host='b'
------------------------------------
subqueries(0)
params_num 0
|