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
|
query : ****************************
sql : ----------------------------
select 1, User, Host
from mysql.user
where User='root'
group by Host
order by Host;
------------------------------------
!query_is_editable(query,1)
------------------------------------
query_type : MYX_QT_SELECT
options(0) :
tables(1) :
-------------------------------
table "system"."mysql"."user" ()
fullname= "mysql.user"
charset= "latin1"
columns(33) :
column "Host", cs(latin1_bin) is pk
column "User", cs(latin1_bin) is pk
column "Password", cs(latin1_bin) is not pk
column "Select_priv", cs(latin1_swedish_ci) is not pk
column "Insert_priv", cs(latin1_swedish_ci) is not pk
column "Update_priv", cs(latin1_swedish_ci) is not pk
column "Delete_priv", cs(latin1_swedish_ci) is not pk
column "Create_priv", cs(latin1_swedish_ci) is not pk
column "Drop_priv", cs(latin1_swedish_ci) is not pk
column "Reload_priv", cs(latin1_swedish_ci) is not pk
column "Shutdown_priv", cs(latin1_swedish_ci) is not pk
column "Process_priv", cs(latin1_swedish_ci) is not pk
column "File_priv", cs(latin1_swedish_ci) is not pk
column "Grant_priv", cs(latin1_swedish_ci) is not pk
column "References_priv", cs(latin1_swedish_ci) is not pk
column "Index_priv", cs(latin1_swedish_ci) is not pk
column "Alter_priv", cs(latin1_swedish_ci) is not pk
column "Show_db_priv", cs(latin1_swedish_ci) is not pk
column "Super_priv", cs(latin1_swedish_ci) is not pk
column "Create_tmp_table_priv", cs(latin1_swedish_ci) is not pk
column "Lock_tables_priv", cs(latin1_swedish_ci) is not pk
column "Execute_priv", cs(latin1_swedish_ci) is not pk
column "Repl_slave_priv", cs(latin1_swedish_ci) is not pk
column "Repl_client_priv", cs(latin1_swedish_ci) is not pk
column "Create_view_priv", cs(latin1_swedish_ci) is not pk
column "Show_view_priv", cs(latin1_swedish_ci) is not pk
column "ssl_type", cs(latin1_swedish_ci) is not pk
column "ssl_cipher", cs((null)) is not pk
column "x509_issuer", cs((null)) is not pk
column "x509_subject", cs((null)) is not pk
column "max_questions", cs((null)) is not pk
column "max_updates", cs((null)) is not pk
column "max_connections", cs((null)) is not pk
pk_columns_num(0) :
relationship_type=MYX_QTRT_NONE
null relation
-------------------------------
pk_columns_added_num 0
columns(3)
column "<<nil>>"."<<nil>>"."<<nil>>" ."1" (alias: 1, is_pk: 0)
column "<<nil>>"."<<nil>>"."<<nil>>" ."User" (alias: User, is_pk: 0)
column "<<nil>>"."<<nil>>"."<<nil>>" ."Host" (alias: Host, is_pk: 0)
clauses(5)
clause (7,22) ends with linebreak
clause_type MYX_QCT_SELECT_CLAUSE
clause : -------------------------
1, User, Host
------------------------------------
clause (27,39) ends with linebreak
clause_type MYX_QCT_FROM_CLAUSE
clause : -------------------------
mysql.user
------------------------------------
clause (45,58) ends with linebreak
clause_type MYX_QCT_WHERE_CLAUSE
clause : -------------------------
User='root'
------------------------------------
clause (67,73) ends with linebreak
clause_type MYX_QCT_GROUP_CLAUSE
clause : -------------------------
Host
------------------------------------
clause (82,87) doesn't end with linebreak
clause_type MYX_QCT_ORDER_CLAUSE
clause : -------------------------
Host;
------------------------------------
subqueries(0)
params_num 0
|