将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 500 行, 查询花费 0.0029 秒。) [price_numerator: 0... - 0...]
SELECT * FROM `TradeBook` ORDER BY `price_numerator`  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_qtyfill_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_4qty_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_numerator 递增 递减 1price_denominatorgen_numeratorgen_denominatorui_dev_codebroker_idregionfamily_idord_srcip_address
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400001024 AND `TradeBook`.`fill_id` = \'259\'
22091400001024 1663136859 985109602 1145 1 50 49 NARESHTEST NARESHINV2 BANKNIFTY15SEP22C41000 NFO 51892 B LMT M DAY C AAAAA1111A 75 133900 NULL 0 75 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 `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400001025 AND `TradeBook`.`fill_id` = \'261\'
22091400001025 1663136860 82984814 1146 1 50 49 NARESHTEST NARESHINV2 BANKNIFTY15SEP22P39400 NFO 51810 B LMT M DAY C AAAAA1111A 50 11640 NULL 0 50 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 `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002052 AND `TradeBook`.`fill_id` = \'876\'
22091400002052 1663158330 868368349 11982 1 50 49 TA0139 SHRIAD ACC-EQ NSE 22 B LMT M DAY C AKLPA3752A 20 250000 NULL 0 20 20 1663158330 868126122 250000 250000 0 0 608 876 14-09-2022 17:55:30 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 ACC NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL BANGALORE ONLINE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002053 AND `TradeBook`.`fill_id` = \'875\'
22091400002053 1663158330 868345353 11983 1 50 49 WILMA SHRI ACC-EQ NSE 22 S LMT I DAY C AAAAA1234A 20 250000 NULL 0 20 20 1663158330 868055502 250000 250000 0 0 609 875 14-09-2022 17:55:30 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 ACC NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL MANGALORE SHRI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000518 AND `TradeBook`.`fill_id` = \'106\'
22072900000518 1659088199 686068239 10397 1 50 49 POORNIINV POORNIINV AGI-EQ NSE 1412 B LMT I DAY C POORNIINV1NSEPCODE BCXPK7252C 1 30700 NULL 0 1 1 1659088199 770037954 30700 30700 0 0 43 106 29-07-2022 15:19:59 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 AGI NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL KSPL KSPL TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400001030 AND `TradeBook`.`fill_id` = \'264\'
22091400001030 1663137022 846691391 1149 1 50 49 CLLI1 SHRE_DEALER AARTIIND29SEP22F NFO 37528 B LMT M DAY C AAAAA1111A 850 98000 NULL 0 850 850 1663136964 846308070 98000 98000 0 0 220 264 14-09-2022 12:00:22 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 850 0 0 0 AARTIIND NULL NSE DER 29-SEP-2022 FUTSTK XX NULL -1 5 0 0 0 0 NULL KSPL MANAGALORE KSPL TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000519 AND `TradeBook`.`fill_id` = \'105\'
22072900000519 1659088199 684919406 10398 1 48 49 POORNIC POORNIUSR AGI-EQ NSE 1412 S LMT M DAY C AAAAA2222S 1000 30700 NULL 0 1 1 1659088199 684655840 30700 30700 0 990 44 105 29-07-2022 15:19:59 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 AGI NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL KSPL MANGLORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400001031 AND `TradeBook`.`fill_id` = \'263\'
22091400001031 1663137022 846677005 1150 1 50 49 WILMA TESTMASTER AARTIIND29SEP22F NFO 37528 S LMT S DAY C AAAAA1234A 850 98000 NULL 0 850 850 1663137022 846285087 98000 98000 0 0 221 263 14-09-2022 12:00:22 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 850 0 0 0 AARTIIND NULL NSE DER 29-SEP-2022 FUTSTK XX NULL -1 5 0 0 0 0 NULL KSPL MANGALORE SHRI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000530 AND `TradeBook`.`fill_id` = \'290\'
22072900000530 1659094913 540818061 10412 1 50 49 VISHWA VISHWA RSYSTEMINT BSE 532735 B LMT M EOS C BKKPA8012K 1 25000 NULL 0 1 1 1659094912 540393193 25000 25000 0 0 176 290 29-07-2022 17:11:53 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 RSYSTEMINT NULL BSE EQT NULL B NULL NULL 0 5 0 0 0 0 NULL KSPL MANAGALORE MANGALORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000531 AND `TradeBook`.`fill_id` = \'289\'
22072900000531 1659094913 540790085 10413 1 50 49 VISHWA VISHWA RSYSTEMINT BSE 532735 S LMT M EOS C BKKPA8012K 1 25000 NULL 0 1 1 1659094913 540355555 25000 25000 0 0 177 289 29-07-2022 17:11:53 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 RSYSTEMINT NULL BSE EQT NULL B NULL NULL 0 5 0 0 0 0 NULL KSPL MANAGALORE MANGALORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000533 AND `TradeBook`.`fill_id` = \'292\'
22072900000533 1659094925 703349548 10415 1 50 49 VISHWA VISHWA RSYSTEMINT BSE 532735 S LMT M EOS C BKKPA8012K 100 19015 NULL 0 100 100 1659094925 703070284 19015 19015 0 0 179 292 29-07-2022 17:12:05 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 RSYSTEMINT NULL BSE EQT NULL B NULL NULL 0 5 0 0 0 0 NULL KSPL MANAGALORE MANGALORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000534 AND `TradeBook`.`fill_id` = \'291\'
22072900000534 1659094925 703332376 10416 1 50 49 VISHWA VISHWA RSYSTEMINT BSE 532735 B LMT M IOC C BKKPA8012K 100 25000 NULL 0 100 100 1659094925 703029029 19015 19015 0 0 180 291 G 29-07-2022 17:12:05 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 RSYSTEMINT NULL BSE EQT NULL B NULL NULL 0 5 0 0 0 0 NULL KSPL MANAGALORE MANGALORE TAN NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002070 AND `TradeBook`.`fill_id` = \'878\'
22091400002070 1663159325 51826328 12002 1 50 49 RKN3 VISHWA RSYSTEMS-EQ NSE 13414 B LMT M DAY C INST AAAAA0000A 1 20000 NULL 0 1 1 1663159325 971167590 20000 20000 0 0 611 878 14-09-2022 18:12:05 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 RSYSTEMS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002071 AND `TradeBook`.`fill_id` = \'877\'
22091400002071 1663159325 51805050 12003 1 50 49 RKN3 VISHWA RSYSTEMS-EQ NSE 13414 S LMT M DAY C INST AAAAA0000A 1 20000 NULL 0 1 1 1663159325 51583658 20000 20000 0 0 612 877 14-09-2022 18:12:05 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 RSYSTEMS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002072 AND `TradeBook`.`fill_id` = \'102\'
22091400002072 1663159603 732721273 12004 1 48 49 TA0020 SHRI GOLD05OCT22 MCX 233972 S LMT M DAY C AJPPA8055P 10 5 NULL 0 1 1 1663159365 948873854 1 1 0 0 2 102 TTRED 14-09-2022 18:16:43 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 0 0 GOLD NULL MCX COM 05-OCT-2022 FUTCOM XX NULL 0 100 0 0 0 0 NULL KSPL TNCB01 ONLINE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002072 AND `TradeBook`.`fill_id` = \'104\'
22091400002072 1663159713 642558484 12004 1 50 49 TA0020 SHRI GOLD05OCT22 MCX 233972 S LMT M DAY C AJPPA8055P 10 5 NULL 0 9 10 1663159365 948873854 1 1 0 0 2 104 TTRED 14-09-2022 18:18:33 NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 0 0 GOLD NULL MCX COM 05-OCT-2022 FUTCOM XX NULL 0 100 0 0 0 0 NULL KSPL TNCB01 ONLINE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002073 AND `TradeBook`.`fill_id` = \'880\'
22091400002073 1663159407 625991994 12005 1 50 49 RKN3 VISHWA RSYSTEMS-EQ NSE 13414 B LMT M DAY C INST AAAAA0000A 100 21000 NULL 0 100 100 1663159407 625719189 21000 21000 0 0 613 880 14-09-2022 18:13:27 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 RSYSTEMS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002074 AND `TradeBook`.`fill_id` = \'879\'
22091400002074 1663159407 625972262 12006 1 50 49 RKN3 VISHWA RSYSTEMS-EQ NSE 13414 S LMT M DAY C INST AAAAA0000A 100 21000 NULL 0 100 100 1663159407 625680708 21000 21000 0 0 614 879 14-09-2022 18:13:27 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 RSYSTEMS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002075 AND `TradeBook`.`fill_id` = \'886\'
22091400002075 1663159955 617239545 12007 1 50 49 VISHWA VISHWA RSYSTEMS-EQ NSE 13414 B LMT M DAY C 122344 BKKPA8012K 5 28000 NULL 0 5 5 1663159955 627683192 28000 28000 0 0 615 886 NULL 14-09-2022 18:22:35 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 RSYSTEMS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL MANAGALORE MANGALORE TAN NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000540 AND `TradeBook`.`fill_id` = \'294\'
22072900000540 1659094972 813522921 10422 1 50 49 VISHWA VISHWA RSYSTEMINT BSE 532735 S LMT M EOS C BKKPA8012K 50 19500 NULL 0 50 50 1659094972 812552005 19500 19500 0 0 186 294 29-07-2022 17:12:52 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 RSYSTEMINT NULL BSE EQT NULL B NULL NULL 0 5 0 0 0 0 NULL KSPL MANAGALORE MANGALORE TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400000540 AND `TradeBook`.`fill_id` = \'664\'
22091400000540 1663135860 383570409 540 1 50 49 RKN3 VISHWA RSYSTEMS-EQ NSE 13414 S LMT M DAY C INST AAAAA0000A 20000 25000 NULL 0 14201 20000 1663135860 941830201 25000 25000 0 0 279 664 14-09-2022 11:41:00 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 RSYSTEMS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002076 AND `TradeBook`.`fill_id` = \'881\'
22091400002076 1663159553 117937030 12008 1 50 49 RKN3 VISHWA 20MICRONS-EQ NSE 16921 B LMT M DAY C INST AAAAA0000A 1 9400 NULL 0 1 1 1663159553 117728443 9400 9400 0 0 616 881 14-09-2022 18:15:53 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 20MICRONS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22072900000541 AND `TradeBook`.`fill_id` = \'293\'
22072900000541 1659094972 812708931 10423 1 50 49 VISHWA VISHWA RSYSTEMINT BSE 532735 B LMT M IOC C BKKPA8012K 50 25000 NULL 0 50 50 1659094972 812520521 19500 19500 0 0 187 293 G 29-07-2022 17:12:52 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 RSYSTEMINT NULL BSE EQT NULL B NULL NULL 0 5 0 0 0 0 NULL KSPL MANAGALORE MANGALORE TAN NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400001053 AND `TradeBook`.`fill_id` = \'180\'
22091400001053 1663137287 163535344 1168 1 50 49 RKN2 VISHWA TATAMOTORS BSE 500570 B LMT M EOS C INST AAAAA0000A 1 50000 NULL 0 1 1 1663137285 735667796 50000 50000 0 0 103 180 14-09-2022 12:04:47 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 TATAMOTORS NULL BSE EQT NULL A NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBook` WHERE `TradeBook`.`noren_ord_num` = 22091400002077 AND `TradeBook`.`fill_id` = \'884\'
22091400002077 1663159599 191108349 12009 1 50 49 RKN3 VISHWA 20MICRONS-EQ NSE 16921 S LMT M DAY C INST AAAAA0000A 1 9100 NULL 0 1 1 1663159599 427800080 9100 9100 0 0 617 884 14-09-2022 18:16:39 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 20MICRONS NULL NSE EQT NULL EQ NULL NULL 0 5 0 0 0 0 NULL KSPL VIDDU MONI TT NULL
选中项： 选中项：
|
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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