将文件拖动至此

SQL 上传 ( 0 ) x -

服务器: localhost »数据库: NorenDB »表: OrderBook
页面相关设置 点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询 按 Enter 执行查询
递增排序
递减排序
命令：
调试 SQL
数量
运行顺序
用时
排序条件：
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 数量 用时
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库 : 查询时间 :

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 1706 行, 查询花费 0.0044 秒。) [token_leg_4: NULL... - NULL...]
SELECT * FROM `OrderBook` ORDER BY `token_leg_4`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 noren_ord_numnoren_time_stampnoren_nsecserefnoren_kid_idord_statusreport_typeacct_iduser_idtrading_symbolexch_segtokentrans_typeprice_typeproductord_durationcust_firmpartic_idpan_numqty_to_fillprice_to_fillrej_reasoncancelled_qtytotal_fill_qtyexch_time_stampexch_nsecsfill_pricefill_avg_pricetrigger_pricedisc_qtyexch_ord_numfill_idord_remarksfill_timetrading_symbol_leg_2trans_type_leg_2trading_symbol_leg_3trans_type_leg_3trading_symbol_leg_4trans_type_leg_4token_leg_2token_leg_3token_leg_4 递增 递减 1qty_to_fill_leg_2price_to_fill_leg_2qty_to_fill_leg_3price_to_fill_leg_3qty_to_fill_leg_4price_to_fill_leg_4fill_legtotal_fill_qty_leg_2total_fill_qty_leg_3total_fill_qty_leg_4fill_avg_price_leg_2fill_avg_price_leg_3fill_avg_price_leg_4lot_sizeprice_precisionqty_precisionmultipliersymbol_namecompany_nameexchangesegmentexpiry_dateinstrument_nameoption_typeisinstrike_pricetick_sizeprice_numeratorprice_denominatorgen_numeratorgen_denominatorui_dev_codebroker_idregionfamily_idord_srcip_address
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22072900000512
22072900000512 1659087553 117700952 0 1 56 56 PRATHI1 PRATHIBHA CANBK-EQ NSE NA B LMT M DAY C NA 50 21000 ORA:User PRATHIBHA signed off 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 NULL NA NA NA FIX NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001024
22091400001024 1663136859 985109602 1145 1 50 49 NARESHTEST NARESHINV2 BANKNIFTY15SEP22C41000 NFO 51892 B LMT M DAY C AAAAA1111A 75 133900 NULL 0 75 1663136859 984706581 130000 130000 0 0 216 259 NULL 14-09-2022 11:57:39 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 15-SEP-2022 OPTIDX CE NULL 4100000 5 0 0 0 0 NOREN_WEB KSPL KSPL1 KSPL WEB NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001280
22091400001280 1663144575 51243810 0 1 56 56 SHR1 SHRUTHI ZOMATO-EQ NSE NA S LMT P DAY C NA 1 6000 ORA:User SHRUTHI signed off 0 0 0 0 0 0 0 0 NULL NULL 2:03 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 NULL NA NA NA TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001536
22091400001536 1663145847 805648197 11483 1 52 52 PRATHI1 VENUGOPAL NIFTY29SEP22F NFO 37517 B 2L M IOC C AAAAA1234A 50 1700600 16388 Order Cancelled By System 50 0 315513000 0 0 0 0 0 0 NULL test1_2L NULL NIFTY27OCT22F S NULL NULL NULL NULL 51951 NULL NULL 50 1700200 0 0 0 0 0 0 0 0 0 0 0 50 0 0 0 NIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL VIDDU MONI TEA NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001792
22091400001792 1663148040 760877182 0 1 56 56 SHR1 SHRUTHI BANKNIFTY29SEP22F NFO 37516 S DS P DAY C QQQQQQQQQQ 25 0 ORA: request has exceeded throttle limit of 25 per... 0 0 0 0 0 0 0 0 NULL NULL 3:02 NULL BANKNIFTY27OCT22F B NULL NULL NULL NULL 51942 NULL NULL 25 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL MANGLORE MANGLORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400002048
22091400002048 1663158028 379581449 11978 1 48 48 TA0139 SHRIAD BANKNIFTY29SEP22F NFO 37516 B LMT M DAY C AKLPA3752A 25 4000000 NULL 0 0 1663158028 379271994 0 0 0 0 311 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL BANGALORE ONLINE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22072900000513
22072900000513 1659088013 468776824 0 1 56 56 POORNIC POORNIUSR ACRYSIL-EQ NSE NA S LMT C DAY C NA 1000 70000 ORA:User POORNIUSR signed off 0 0 0 0 0 0 0 990 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 NULL NA NA NA TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001025
22091400001025 1663136860 82984814 1146 1 50 49 NARESHTEST NARESHINV2 BANKNIFTY15SEP22P39400 NFO 51810 B LMT M DAY C AAAAA1111A 50 11640 NULL 0 50 1663136860 82726165 11300 11300 0 0 217 261 NULL 14-09-2022 11:57:40 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 15-SEP-2022 OPTIDX PE NULL 3940000 5 0 0 0 0 NOREN_WEB KSPL KSPL1 KSPL WEB NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001281
22091400001281 1663144575 112169818 0 1 56 56 SHR1 SHRUTHI ZOMATO-EQ NSE NA S LMT P DAY C NA 1 6000 ORA:User SHRUTHI signed off 0 0 0 0 0 0 0 0 NULL NULL 2:03 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 NULL NA NA NA TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001537
22091400001537 1663145852 812536184 11484 1 52 52 PRATHI1 VENUGOPAL NIFTY29SEP22F NFO 37517 B 2L M IOC C AAAAA1234A 50 1700600 16388 Order Cancelled By System 50 0 315513000 0 0 0 0 0 0 NULL test1_2L NULL NIFTY27OCT22F S NULL NULL NULL NULL 51951 NULL NULL 50 1700200 0 0 0 0 0 0 0 0 0 0 0 50 0 0 0 NIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL VIDDU MONI TEA NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001793
22091400001793 1663148040 760900744 0 1 56 56 SHR1 SHRUTHI BANKNIFTY29SEP22F NFO 37516 S DS P DAY C QQQQQQQQQQ 25 0 ORA: request has exceeded throttle limit of 25 per... 0 0 0 0 0 0 0 0 NULL NULL 3:02 NULL BANKNIFTY27OCT22F B NULL NULL NULL NULL 51942 NULL NULL 25 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL MANGLORE MANGLORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400002049
22091400002049 1663158092 245029645 11979 1 48 48 WILMA SHRI BANKNIFTY29SEP22F NFO 37516 S LMT I DAY C AAAAA1234A 25 4000000 NULL 0 0 1663158092 244661520 0 0 0 0 18011 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL MANGALORE SHRI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22072900000514
22072900000514 1659088076 711978316 10393 1 56 56 TESTINVREG SHRI 5PAISA-EQ NSE 445 B LMT I DAY C AAAAA1234A 1 22000 RED:Missing PROFILE for C-TESTINVREG 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 5PAISA NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL MANGAL SHRI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001026
22091400001026 1663136860 192633679 0 1 56 56 NARESHTEST NARESHINV2 BANKNIFTY15SEP22C41300 NFO 51917 S MKT M DAY C AAAAA1111A 75 0 ORA:AMO is stopped 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 15-SEP-2022 OPTIDX CE NULL 4130000 5 0 0 0 0 NOREN_WEB KSPL KSPL1 KSPL WEB NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001282
22091400001282 1663144575 181233476 0 1 56 56 SHR1 SHRUTHI ZOMATO-EQ NSE NA S LMT P DAY C NA 1 6000 ORA:User SHRUTHI signed off 0 0 0 0 0 0 0 0 NULL NULL 2:03 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 NULL NA NA NA TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001538
22091400001538 1663145857 816667206 11485 1 52 52 PRATHI1 VENUGOPAL NIFTY29SEP22F NFO 37517 B 2L M IOC C AAAAA1234A 50 1700600 16388 Order Cancelled By System 50 0 315513000 0 0 0 0 0 0 NULL test1_2L NULL NIFTY27OCT22F S NULL NULL NULL NULL 51951 NULL NULL 50 1700200 0 0 0 0 0 0 0 0 0 0 0 50 0 0 0 NIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL VIDDU MONI TEA NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001794
22091400001794 1663148040 760929110 0 1 56 56 SHR1 SHRUTHI BANKNIFTY29SEP22F NFO 37516 S DS P DAY C QQQQQQQQQQ 25 0 ORA: request has exceeded throttle limit of 25 per... 0 0 0 0 0 0 0 0 NULL NULL 3:02 NULL BANKNIFTY27OCT22F B NULL NULL NULL NULL 51942 NULL NULL 25 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL MANGLORE MANGLORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400002050
22091400002050 1663158125 982695938 11980 1 48 48 WILMA SHRI BANKNIFTY29SEP22F NFO 37516 S LMT I DAY C AAAAA1234A 25 3800000 NULL 0 0 1663158125 982416721 0 0 0 0 18012 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL MANGALORE SHRI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22072900000515
22072900000515 1659088082 21623379 10394 1 48 48 RKN3 RAKSH CANBK-EQ NSE 10794 B LMT M DAY C NSPcode AAAAA0000A 50 21500 NULL 0 0 1659088082 21220250 0 0 0 0 40 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 CANBK NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TAN NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001027
22091400001027 1663136897 22181475 1147 1 48 117 NARESHTEST NARESHINV2 BANKNIFTY15SEP22C41000 NFO 51892 B LMT M DAY C AAAAA1111A 75 133900 NULL 0 0 1663136897 21914291 0 0 0 0 218 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 15-SEP-2022 OPTIDX CE NULL 4100000 5 0 0 0 0 NOREN_WEB KSPL KSPL1 KSPL WEB NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001283
22091400001283 1663144575 241288282 0 1 56 56 SHR1 SHRUTHI ZOMATO-EQ NSE NA S LMT P DAY C NA 1 6000 ORA:User SHRUTHI signed off 0 0 0 0 0 0 0 0 NULL NULL 2:03 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 NULL NA NA NA TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001539
22091400001539 1663145862 823887754 11486 1 52 52 PRATHI1 VENUGOPAL NIFTY29SEP22F NFO 37517 B 2L M IOC C AAAAA1234A 50 1700600 16388 Order Cancelled By System 50 0 315513000 0 0 0 0 0 0 NULL test1_2L NULL NIFTY27OCT22F S NULL NULL NULL NULL 51951 NULL NULL 50 1700200 0 0 0 0 0 0 0 0 0 0 0 50 0 0 0 NIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL VIDDU MONI TEA NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400001795
22091400001795 1663148040 760951309 0 1 56 56 SHR1 SHRUTHI BANKNIFTY29SEP22F NFO 37516 S DS P DAY C QQQQQQQQQQ 25 0 ORA: request has exceeded throttle limit of 25 per... 0 0 0 0 0 0 0 0 NULL NULL 3:02 NULL BANKNIFTY27OCT22F B NULL NULL NULL NULL 51942 NULL NULL 25 0 0 0 0 0 0 0 0 0 0 0 0 25 0 0 0 BANKNIFTY NULL NSE DER 29-SEP-2022 FUTIDX XX NULL -1 5 0 0 0 0 NULL KSPL MANGLORE MANGLORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22091400002051
22091400002051 1663158582 771539058 11985 3 52 52 SAN1520 SAN1510 ACCELYA-EQ NSE 7053 B SL-MKT I DAY C 12345678910 ERTY34456G 1 0 NULL 1 0 1663158582 771011084 0 0 130000 0 607 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACCELYA NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL SURATHKAL KSPL TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `OrderBook` WHERE `OrderBook`.`noren_ord_num` = 22072900000516
22072900000516 1659088096 336153149 10395 1 48 48 POORNIC POORNIUSR ACRYSIL-EQ NSE 1879 S LMT C DAY C AAAAA2222S 1000 70000 NULL 0 0 1659088096 335160037 0 0 0 990 41 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 ACRYSIL NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL KSPL MANGLORE TT NULL
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

将此 SQL 查询加为书签 将此 SQL 查询加为书签