近期访问
`LicenseApp`.`DomainList`
`NorenAccordComapnyData`.`BalanceSheet`
`LicenseApp`.`RequestList`
`NorenAccordComapnyData`.`CashFlow`
`NorenDB`.`UserDetails`
`information_schema`.`PARTITIONS`
`NorenDB`.`PayoutUpdates`
`NorenDB`.`OrderHistory`
`NorenDB`.`ClientDetails`
`LicenseApp`.`ProductList`
表收藏夹
`information_schema`.`INNODB_CMP_PER_INDEX_RESET`
`mysql`.`help_topic`
`phpmyadmin`.`pma__pdf_pages`
`NorenUplDB_test`.`SchedRMSPayInOutUpdates`
`NorenDB`.`AccountExchDetails`
新建
cm9vdA==.YWNjZXNzX2RhdGFfbWFyaWFkYg==
cm9vdA==.YWNjZXNzX2RhdGFfbWFyaWFkYg==
0
access_data_mariadb
cm9vdA==.Q2hhaW5z
cm9vdA==.Q2hhaW5z
0
Chains
cm9vdA==.RXhjaENvcnBEYXRh
cm9vdA==.RXhjaENvcnBEYXRh
0
ExchCorpData
cm9vdA==.RXhjaE5ld3NEYXRh
cm9vdA==.RXhjaE5ld3NEYXRh
0
ExchNewsData
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.TGljZW5zZUFwcA==
cm9vdA==.TGljZW5zZUFwcA==
0
LicenseApp
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.Tm9yZW5BY2NvcmRDb21hcG55RGF0YQ==
cm9vdA==.Tm9yZW5BY2NvcmRDb21hcG55RGF0YQ==
0
NorenAccordComapnyData
cm9vdA==.Tm9yZW5CbG9ja0Z1bmRzQVNCQQ==
cm9vdA==.Tm9yZW5CbG9ja0Z1bmRzQVNCQQ==
0
NorenBlockFundsASBA
cm9vdA==.Tm9yZW5EQg==
cm9vdA==.Tm9yZW5EQg==
0
NorenDB
cm9vdA==.Tm9yZW5EQkNvbXBhbnlEYXRh
cm9vdA==.Tm9yZW5EQkNvbXBhbnlEYXRh
0
NorenDBCompanyData
cm9vdA==.Tm9yZW5EQklwb0RhdGE=
cm9vdA==.Tm9yZW5EQklwb0RhdGE=
0
NorenDBIpoData
cm9vdA==.Tm9yZW5EaW9uTmV3c0RhdGE=
cm9vdA==.Tm9yZW5EaW9uTmV3c0RhdGE=
0
NorenDionNewsData
cm9vdA==.Tm9yZW5GZWVkRGF0YQ==
cm9vdA==.Tm9yZW5GZWVkRGF0YQ==
0
NorenFeedData
cm9vdA==.Tm9yZW5JbnN0aVZ3YXA=
cm9vdA==.Tm9yZW5JbnN0aVZ3YXA=
0
NorenInstiVwap
cm9vdA==.Tm9yZW5Mc05ld3M=
cm9vdA==.Tm9yZW5Mc05ld3M=
0
NorenLsNews
cm9vdA==.Tm9yZW5UUERC
cm9vdA==.Tm9yZW5UUERC
0
NorenTPDB
cm9vdA==.Tm9yZW5VcGxEQl90ZXN0
cm9vdA==.Tm9yZW5VcGxEQl90ZXN0
0
NorenUplDB_test
cm9vdA==.Tm9yZW5Vc2VyQXBpS2V5
cm9vdA==.Tm9yZW5Vc2VyQXBpS2V5
0
NorenUserApiKey
cm9vdA==.Tm9yZW5VdGlsZXNfdGVzdA==
cm9vdA==.Tm9yZW5VdGlsZXNfdGVzdA==
0
NorenUtiles_test
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==
cm9vdA==.cGhwbXlhZG1pbg==
0
phpmyadmin
cm9vdA==.dGVzdA==
cm9vdA==.dGVzdA==
0
test
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: localhost
»
数据库: NorenDB
结构
SQL
搜索
查询
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
多表查询
通过示例查询
*
acct_id
exch_seg
exch_seg_acct_id
partic_id
enabled
*
user_count
noren_time_stamp
*
client_id
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
*
acct_id
creation_date
noren_time_stamp
mob_num
display_precision
dp_type
dp_id
broker_id
region
acct_name
src_user_id
email_id
pan_num
addr
acct_type
status
office_addr
addr_city
addr_state
gender
occupation
exch_acct_id
family_id
*
acct_id
product
holding_qty
collateral_qty
collateral_mode
hair_cut
close_price
is_collateral
interop_key
interop_exch_seg
user_id
broker_id
region
family_id
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
broker_collateral_qty
broker_hair_cut
upload_price
*
ITS_EXCH_ID
ITS_MKT_TYPE
ITS_BOOK_TYPE
ITS_INSTRUMENT_TYPE
ITS_SYMBOL
ITS_SERIES
ITS_CLIENT_ID
ITS_CP_ID
ITS_PRO_CLI
ITS_EXCH_ORD_NO
ITS_EXCH_TRD_NO
ITS_BUY_SELL_IND
ITS_TRD_ORD_QTY
ITS_TRD_ORD_PRICE
ITS_TRD_ORD_TIME
ITS_TRD_ORD_MOD_TIME
ITS_ORD_ORDER_TIME
ITS_USER_ID
ITS_TRD_STATUS
ITS_ISIN_CD
ITS_SEM_DESC
ITS_NOVA_PARTY_ID
ITS_CASII_PARTY_ID
ITS_CLIENT_ORD_REF_NO
ITS_BRANCH_ID
ITS_AUCTION_PART_TYPE
ITS_AUCTION_SETT_NO
ITS_SETT_PERIOD
ITS_TRANS_TYPE
ITS_OPPOSITE_MEMB_ID
ITS_OPPOSITE_TRADER_ID
ITS_SHORT_SELL_FLG
ITS_SUPER_ID
ITS_CHANNEL_TYPE
ITS_DEALER_ID
ITS_BOOK_ID
*
entity_id
profile_name
segment
exch_seg
product
family_risk
cash
turnover_limit
pending_order_limit
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
payin
payout
daylong_cash
uncleared_cash
broker_collateral
brokerage_perc_eq_margin
brokerage_perc_eq_intraday
brokerage_perc_eq_cac
brokerage_perc_eq_hl
brokerage_perc_eq_bo
brokerage_perc_der_margin
brokerage_perc_der_intraday
brokerage_perc_der_hl
brokerage_perc_der_bo
brokerage_perc_fx_margin
brokerage_perc_fx_intraday
brokerage_perc_fx_hl
brokerage_perc_fx_bo
brokerage_perc_com_margin
brokerage_perc_com_intraday
brokerage_perc_com_hl
brokerage_perc_com_bo
brokerage_flat_perc
from_segment
from_exch_seg
from_product
aux_daylong_cash
aux_uncleared_cash
aux_broker_collateral
*
req_status
user_sess_id
last_attempt_count
device_pin_flag
user_privilege
login_proc_id
access_type
user_id
noren_time_stamp
last_login_time
ui_dev_code
addl_src_info
*
req_status
user_sess_id
last_attempt_count
device_pin_flag
user_privilege
login_proc_id
access_type
user_id
noren_time_stamp
last_login_time
ui_dev_code
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
cust_firm
partic_id
pan_num
qty_to_fill
price_to_fill
rej_reason
cancelled_qty
total_fill_qty
exch_time_stamp
exch_nsecs
fill_price
fill_avg_price
trigger_price
disc_qty
exch_ord_num
fill_id
ord_remarks
fill_time
trading_symbol_leg_2
trans_type_leg_2
trading_symbol_leg_3
trans_type_leg_3
trading_symbol_leg_4
trans_type_leg_4
token_leg_2
token_leg_3
token_leg_4
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
qty_to_fill_leg_4
price_to_fill_leg_4
fill_leg
total_fill_qty_leg_2
total_fill_qty_leg_3
total_fill_qty_leg_4
fill_avg_price_leg_2
fill_avg_price_leg_3
fill_avg_price_leg_4
lot_size
price_precision
qty_precision
multiplier
symbol_name
company_name
exchange
segment
expiry_date
instrument_name
option_type
isin
strike_price
tick_size
price_numerator
price_denominator
gen_numerator
gen_denominator
ui_dev_code
broker_id
region
family_id
ord_src
ip_address
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
cust_firm
partic_id
pan_num
qty_to_fill
price_to_fill
rej_reason
cancelled_qty
total_fill_qty
exch_time_stamp
exch_nsecs
fill_price
fill_avg_price
trigger_price
disc_qty
exch_ord_num
fill_id
ord_remarks
fill_time
trading_symbol_leg_2
trans_type_leg_2
trading_symbol_leg_3
trans_type_leg_3
trading_symbol_leg_4
trans_type_leg_4
token_leg_2
token_leg_3
token_leg_4
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
qty_to_fill_leg_4
price_to_fill_leg_4
fill_leg
total_fill_qty_leg_2
total_fill_qty_leg_3
total_fill_qty_leg_4
fill_avg_price_leg_2
fill_avg_price_leg_3
fill_avg_price_leg_4
lot_size
price_precision
qty_precision
multiplier
symbol_name
company_name
exchange
segment
expiry_date
instrument_name
option_type
isin
strike_price
tick_size
price_numerator
price_denominator
gen_numerator
gen_denominator
*
Acct_id
Trans_ref_num
Init_time_stamp
Src_user_id
Amt
Tran_status
Noren_time_stamp
User_remarks
Bank_acct_type
Bank_acct_num
Bank_name
Broker_id
Admin_remarks
Segment
Exch_seg
Product
Withdraw_success_amt
Bank_ref_number
Aggr_ref_number
Vendor
Vendor_url
Bank_ifsc_code
Customer_name
Mob_num
Email_id
Upi_id
Expiry_time
Customer_ref_number
*
Acct_id
Trans_ref_num
Init_time_stamp
Src_user_id
Amt
Tran_status
Noren_time_stamp
User_remarks
Bank_acct_type
Bank_acct_num
Bank_name
Broker_id
Admin_remarks
Segment
Exch_seg
Product
Withdraw_success_amt
Bank_ref_number
Aggr_ref_number
Vendor
Vendor_url
Bank_ifsc_code
Customer_name
Mob_num
Email_id
Upi_id
Expiry_time
Customer_ref_number
*
SlNo
EntityID
Timestamp
PeakMargin
*
UserId
RefName
MobNum
Email
Lang
NorenTimeStamp
*
EntityID
TotalCash
TotalMtom
MtomPerc
Timestamp
NSec
ProfileName
TotalMarginCash
TotalMarginUsed
MarginPerc
Segment
Product
AlertType
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
cust_firm
partic_id
pan_num
qty_to_fill
price_to_fill
rej_reason
cancelled_qty
fill_qty
total_fill_qty
exch_time_stamp
exch_nsecs
fill_price
fill_avg_price
trigger_price
disc_qty
exch_ord_num
fill_id
ord_remarks
fill_time
trading_symbol_leg_2
trans_type_leg_2
trading_symbol_leg_3
trans_type_leg_3
trading_symbol_leg_4
trans_type_leg_4
token_leg_2
token_leg_3
token_leg_4
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
qty_to_fill_leg_4
price_to_fill_leg_4
fill_leg
total_fill_qty_leg_2
total_fill_qty_leg_3
total_fill_qty_leg_4
fill_avg_price_leg_2
fill_avg_price_leg_3
fill_avg_price_leg_4
lot_size
price_precision
qty_precision
multiplier
symbol_name
company_name
exchange
segment
expiry_date
instrument_name
option_type
isin
strike_price
tick_size
price_numerator
price_denominator
gen_numerator
gen_denominator
ui_dev_code
broker_id
region
family_id
ord_src
ip_address
*
user_id
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
*
user_id
creation_date
noren_time_stamp
login_image
last_password_time
last_login_time
mob_num
display_precision
max_contract_sub
dob
user_login_otp
last_login_mac
user_default_mw
addr_city
addr_state
addr
executing_broker_id
email_id
pan_num
user_access_grp
status
user_ip_addr
user_mac_addr
noren_extras_grp
noren_extras
user_ord_validator
prop_id
user_name
login_password
user_sess_id
src_user_id
last_login_ip
user_privilege
access_type
noren_app_version
last_login_os
broker_id
region
user_sess_otp
login_proc_id
prop_ord_flag
acct_overview
red_super_user
user_2fa_flag
password_reset
last_attempt_count
last_attempt_time
*
user_id
exch_seg
exch_user_info
exch_user_id
red_check
exch_expiry_date
enabled
*
user_id
creation_date
noren_time_stamp
login_image
last_password_time
last_login_time
mob_num
display_precision
max_contract_sub
dob
user_login_otp
last_login_mac
user_default_mw
addr_city
addr_state
addr
executing_broker_id
email_id
pan_num
user_access_grp
status
user_ip_addr
user_mac_addr
noren_extras_grp
noren_extras
user_ord_validator
prop_id
user_name
login_password
user_sess_id
src_user_id
last_login_ip
user_privilege
access_type
noren_app_version
last_login_os
broker_id
region
user_sess_otp
login_proc_id
prop_ord_flag
acct_overview
red_super_user
user_2fa_flag
password_reset
last_attempt_count
last_attempt_time
product
user_accesstype
user_ordtype
fcm_token
user_tag
remarks
totp_sec
last_otp_time
otp_count
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
X
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
X
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
X
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
ActiveUserCount
ClientDelete
ClientDetails
Holdings
INTERFACE_TRADES_STAGING_CUST
Limits
Logins
Logouts
OrderBook
OrderHistory
PayInUpdates
PayoutUpdates
PeakMargin
Refdata
RMSAlerts
TradeBook
UserDelete
UserDetails
UserExchDetails
UserSil
.
选择字段
X