• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 72 行, 查询花费 0.0057 秒。)
SELECT * FROM `TradeBookNSE`
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
|
行数：
过滤行:
按索引排序：
完整内容 FillIdReportTypeSymbolNameSeriesTradingSymbolInstrumentTypeBookTypeMarketTypeUserIdBranchIdTransactionTypeFillSizeFillPriceCustomerFirmAccountIdExecutingBrokerAuctionPartTypeAuctionNoSettlementPeriodEntryDateTimeModifiedDateTimeExchOrdIdCPIdOrderDateTimeDMAIndicatorSourceNorenDateTimeExchAccountIdDealSlipNoBasketIdSublineIdLineIdSecondaryOrderIdClearingAccountSymbolExchUser115_OnBehalfOfCompID116_OnBehalfOfSubIDFixTag_49mnmTOMReceiptTimeChannelTypemnmLocationIdmnmLotSizeFixOrderType_15005FixOrderRefId_15004NorenOrderNumberOrderGenerationTypeOrderSource5011_Root_Order_ID5012_Root_SystemFixTag_5688PriceTypeStrategyCode
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000034\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000030
100000034 11 HAVELLS EQ HAVELLS-EQ 0 1 1 KRITHIINV MANGAL 2 1 1071.90 C KRITHIINV N 0 1 13 MAY 2026 15:00:13 13 MAY 2026 15:00:13 29 13-May-2026 15:00:13 KAMBALA 2026-05-13 15:00:13.613 NULL 9819 11111 111111111111000 1 26051300000030 SNO L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000024\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000070
100000024 11 TANLA EQ TANLA-EQ 0 1 1 ORDERFLOW1 KSPL 1 1 500.00 C ACLIENT1 N 0 1 13 MAY 2026 11:58:47 13 MAY 2026 11:58:47 50 13-May-2026 11:58:47 4 KAMBALA 2026-05-13 11:58:47.727 NULL 13976 11111 111111111111100 1 26051300000070 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000023\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000071
100000023 11 TANLA EQ TANLA-EQ 0 1 1 ORDERFLOW1 KSPL 2 1 500.00 C ACLIENT2 N 0 1 13 MAY 2026 11:58:47 13 MAY 2026 11:58:47 51 13-May-2026 11:58:47 4 KAMBALA 2026-05-13 11:58:47.727 NULL 13976 11111 111111111111100 1 26051300000071 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000026\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000073
100000026 11 TANLA EQ TANLA-EQ 0 1 1 ORDERFLOW1 KSPL 1 1 500.00 C ACLIENT1 N 0 1 13 MAY 2026 12:03:12 13 MAY 2026 12:03:12 53 13-May-2026 12:03:12 4 KAMBALA 2026-05-13 12:03:12.992 NULL 13976 11111 111111111111100 1 26051300000073 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000025\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000074
100000025 11 TANLA EQ TANLA-EQ 0 1 1 ORDERFLOW1 KSPL 2 1 500.00 C ACLIENT2 N 0 1 13 MAY 2026 12:03:12 13 MAY 2026 12:03:12 54 13-May-2026 12:03:12 4 KAMBALA 2026-05-13 12:03:12.992 NULL 13976 11111 111111111111100 1 26051300000074 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000028\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000079
100000028 11 TANLA EQ TANLA-EQ 0 1 1 ORDERFLOW1 KSPL 1 1 500.00 C ACLIENT1 N 0 1 13 MAY 2026 12:10:51 13 MAY 2026 12:10:51 57 13-May-2026 12:10:51 4 KAMBALA 2026-05-13 12:10:51.451 NULL 13976 11111 111111111111100 1 26051300000079 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000027\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000080
100000027 11 TANLA EQ TANLA-EQ 0 1 1 ORDERFLOW1 KSPL 2 1 500.00 C ACLIENT2 N 0 1 13 MAY 2026 12:10:51 13 MAY 2026 12:10:51 58 13-May-2026 12:10:51 4 KAMBALA 2026-05-13 12:10:51.451 NULL 13976 11111 111111111111100 1 26051300000080 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000030\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000093
100000030 11 INFY EQ INFY-EQ 0 1 1 DEEKSHAMST MANGLORE 1 1 1200.00 C DEEKSHAINV 1 N 0 1 13 MAY 2026 13:45:39 13 MAY 2026 13:45:39 64 13-May-2026 13:45:39 4 KAMBALA 2026-05-13 13:45:39.139 NULL 1594 11111 111111111111100 1 26051300000093 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000029\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000094
100000029 11 INFY EQ INFY-EQ 0 1 1 DEEKSHAMST KSPL 2 1 1200.00 C KKSINV N 0 1 13 MAY 2026 13:45:39 13 MAY 2026 13:45:39 65 13-May-2026 13:45:39 4 KAMBALA 2026-05-13 13:45:39.139 NULL 1594 11111 111111111111100 1 26051300000094 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000032\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000109
100000032 11 INFY EQ INFY-EQ 0 1 1 GROOT MANGLORE 2 1 1164.00 C DEEKSHAINV 1 N 0 1 13 MAY 2026 15:00:13 13 MAY 2026 15:00:13 71 13-May-2026 15:00:13 KAMBALA 2026-05-13 15:00:13.613 NULL 1594 11111 111111111111100 1 26051300000109 RED L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000031\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000110
100000031 11 INFY EQ INFY-EQ 0 1 1 GROOT KSPL 1 1 1164.00 C KKSINV N 0 1 13 MAY 2026 15:00:13 13 MAY 2026 15:00:13 72 13-May-2026 15:00:13 KAMBALA 2026-05-13 15:00:13.613 NULL 1594 11111 111111111111100 1 26051300000110 RED L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000033\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000111
100000033 11 HAVELLS EQ HAVELLS-EQ 0 1 1 GROOT MANGAL 1 1 1071.90 C KRITHIINV N 0 1 13 MAY 2026 15:00:13 13 MAY 2026 15:00:13 73 13-May-2026 15:00:13 KAMBALA 2026-05-13 15:00:13.613 NULL 9819 11111 111111111111100 1 26051300000111 RED L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000036\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000189
100000036 15 SAILIFE EQ SAILIFE-EQ 0 1 1 ANANYARAMA Mangalore 1 1 1300.00 ANANYAKALL N 0 1 13 MAY 2026 17:52:48 13 MAY 2026 17:52:48 100 13-May-2026 17:52:48 4 KAMBALA 2026-05-13 17:52:48.968 NULL 27839 11111 1 26051300000189 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000035\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000190
100000035 15 SAILIFE EQ SAILIFE-EQ 0 1 1 ANANYARAMA MANGALO 2 1 1300.00 ANANYADEAL N 0 1 13 MAY 2026 17:53:48 13 MAY 2026 17:53:48 101 13-May-2026 17:53:48 4 KAMBALA 2026-05-13 17:53:48.028 NULL 27839 11111 1 26051300000190 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000038\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000197
100000038 11 SAIL EQ SAIL-EQ 0 1 1 ANANYARAMA Mangalore 1 1 190.00 C ANANYADEAL N 0 1 13 MAY 2026 17:46:18 13 MAY 2026 17:46:18 105 13-May-2026 17:46:18 4 KAMBALA 2026-05-13 17:46:18.578 NULL 2963 11111 111111111111100 1 26051300000197 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000037\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051300000198
100000037 11 SAIL EQ SAIL-EQ 0 1 1 ANANYARAMA Mangalore 2 1 190.00 C ANANYAADMIN abcdef N 0 1 13 MAY 2026 17:46:18 13 MAY 2026 17:46:18 106 13-May-2026 17:46:18 4 KAMBALA 2026-05-13 17:46:18.578 AAAA NULL 2963 11111 111111111111100 1 26051300000198 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000002\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000010
100000002 15 ACE EQ ACE-EQ 0 1 1 ANANYARAMA MANGALURU 1 1 1000.00 ANANYAKALL N 0 1 01 JAN 1980 00:00:00 01 JAN 1980 00:00:00 9 14-May-2026 09:53:50 4 KAMBALA 2026-05-14 09:53:50.630 NULL 13587 11111 1 26051400000010 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000001\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000011
100000001 12 ACE EQ ACE-EQ 0 1 1 ANANYARAMA Mangaluru 2 1 1000.00 ANANYARAMA N 0 1 01 JAN 1980 00:00:00 01 JAN 1980 00:00:00 10 14-May-2026 11:03:22 4 KAMBALA 2026-05-14 11:03:22.802 NULL 13587 11111 1 26051400000011 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000004\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000014
100000004 11 AUTOIND EQ AUTOIND-EQ 0 1 1 DHANUSHINVES KARKALA 1 1 75.85 C DHANUSHINVES N 0 1 14 MAY 2026 10:30:35 14 MAY 2026 10:30:35 13 14-May-2026 10:30:35 KAMBALA 2026-05-14 10:30:35.835 NULL 14106 11111 333333333333100 1 26051400000014 MOB L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000003\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000018
100000003 11 AUTOIND EQ AUTOIND-EQ 0 1 1 DHANUSHMASTER mangalore 2 1 75.85 C DHANUINV N 0 1 14 MAY 2026 10:30:35 14 MAY 2026 10:30:35 17 14-May-2026 10:30:35 4 KAMBALA 2026-05-14 10:30:35.835 NULL 14106 11111 222222222222100 1 26051400000018 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000006\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000026
100000006 11 STANLEY EQ STANLEY-EQ 0 1 1 DHANUSHINVES KARKALA 1 1 158.50 C DHANUSHINVES N 0 1 14 MAY 2026 10:43:14 14 MAY 2026 10:43:14 25 14-May-2026 10:43:14 KAMBALA 2026-05-14 10:43:14.594 NULL 24226 11111 333333333333100 1 26051400000026 MOB L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000005\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000027
100000005 11 STANLEY EQ STANLEY-EQ 0 1 1 DHANUSHMASTER mangalore 2 1 158.50 C DHANUINV N 0 1 14 MAY 2026 10:43:14 14 MAY 2026 10:43:14 26 14-May-2026 10:43:14 4 KAMBALA 2026-05-14 10:43:14.594 NULL 24226 11111 222222222222100 1 26051400000027 TT L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000008\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000035
100000008 11 AUTOIND EQ AUTOIND-EQ 0 1 1 DHANUSHINVES KARKALA 1 1 79.65 C DHANUSHINVES N 0 1 14 MAY 2026 10:48:31 14 MAY 2026 10:48:31 33 14-May-2026 10:48:31 KAMBALA 2026-05-14 10:48:31.911 NULL 14106 11111 333333333333100 1 26051400000035 MOB L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000007\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000036
100000007 11 AUTOIND EQ AUTOIND-EQ 0 1 1 DHANUSHINVES KARKALA 2 1 79.65 C DHANUSHINVES N 0 1 14 MAY 2026 10:48:31 14 MAY 2026 10:48:31 34 14-May-2026 10:48:31 KAMBALA 2026-05-14 10:48:31.911 NULL 14106 11111 333333333333100 1 26051400000036 MOB L
编辑 编辑复制 复制删除 删除
DELETE FROM `TradeBookNSE` WHERE `TradeBookNSE`.`FillId` = \'100000010\' AND `TradeBookNSE`.`NorenOrderNumber` = 26051400000040
100000010 12 AARTIIND EQ AARTIIND-EQ 0 1 1 ANANYARAMA Mangaluru 1 1 500.00 ANANYARAMA3 N 0 1 14 MAY 2026 11:03:36 14 MAY 2026 11:03:36 37 14-May-2026 11:03:36 4 KAMBALA 2026-05-14 11:03:36.816 AAAB NULL 7 11111 1 26051400000040 TT L
选中项： 选中项：
|
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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