• 表收藏夹为空。

将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 49707 行, 查询花费 0.0211 秒。) [flag: A... - A...]
SELECT * FROM `CompanyMaster` ORDER BY `flag`  ASC
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 fin_codescrip_codescrip_namescrip_groupco_nameind_codeindustryhse_codehousesymbolseriesisinco_short_nameres_formatfin_formatchairmanmdirco_secinc_monthinc_yearfvstatussub_listingbse_scrip_idsec_tokencinbse_sub_listnse_sub_listflag 递增 递减 1
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 131328
131328 531328 KRETTOSYS X Kretto Syscon Ltd. 70 Medical Equipment/Supplies/Accessories 206 Private INE128R01023 Kretto Syscon MAN MAN Tushar Shah Tushar Shah Manya Anup Khetwani - 1994 1.00 Active Active KRETTOSYS 0 L26109GJ1994PLC023061 Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 131840
131840 531840 IEC EDU XT IEC Education Ltd. 63 IT - Education 206 Private INE172B01017 IEC Education MAN SOW Bijoy Kumar Pandit Shrey Rustagi - 1994 10.00 Active Active IECEDU 0 L74899DL1994PLC061053 Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 132352
132352 532352 KIRLOSKAR ML XD Kirloskar Multimedia Ltd. 65 IT - Software 206 Private INE175B01010 Kirl.Mult MAN SOW Sukumar R Kirloskar Ajay S Kirloskar 02-09 1992 10.00 Delisted Delisted KIRLMU 0 L74900KA1992PLC013492 Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 132608
132608 532608 DECCAN CHR Z Deccan Chronicle Holdings Ltd. 112 Printing And Publishing 206 Private DCHL BE INE137G01027 Deccan ChronicleHold MAN MAN T Venkattram Reddy T Vinayak Ravi Reddy 16-12 2002 2.00 Delisted Delisted DCHL 0 L22122AP2002PLC040110 Delisted Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 132864
132864 532864 NELCAST B Nelcast Ltd. 22 Castings/Forgings 206 Private NELCAST EQ INE189I01024 Nelcast MAN MAN Vinod K Dasari P Deepak S K Sivakumar 07-06 1982 2.00 Active Active NELCAST 14761 L27109AP1982PLC003518 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 267008
267008 0 ICICI Prudential Fixed Maturity Plan - Series 74 -... 113 Unspecified 206 Private IPRU2406 MF INF109KA1WM1 IPRU2406 - 10.00 NonEquity Active 4096 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 267264
267264 950446 1175CREDILA F Credila Financial Services Pvt. Ltd. - (1175CREDIL... 113 Unspecified 206 Private INE539K08112 1175CREDILA - 1000000.00 NonEquity Active 1175CREDILA 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 267520
267520 950529 925KMPL15 F Kotak Mahindra Prime Ltd. - (925KMPL15) 113 Unspecified 206 Private INE916DA7EK5 925KMPL15 - 1000000.00 NonEquity Active 925KMPL15 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 268288
268288 0 Harsha Engineers (India) Pvt Ltd. 44 Engineering - Industrial Equipments 206 Private Harsha Engineers (I) MAN MAN 17-07 2008 0.00 Amalgamation Amalgamation 0 U35303GJ2008PTC054503 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 270336
270336 0 Sundaram Fixed Term Plan - DV  - (RLDVDG) 113 Unspecified 206 Private RLDVDG MF INF903J01T54 RLDVDG - 10.00 NonEquity Active 4823 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 205568
205568 523429 BS Appliances Ltd. 30 Consumer Durables - Domestic Appliances 206 Private BS Appliances MAN MAN N Anantha Murthy 27-02 1989 0.00 Delisted Delisted 0 L29302KA1989PLC009887 Delisted A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 271360
271360 935226 0MFL2016D F Manappuram Finance Ltd. - (0MFL2016D) 113 Unspecified 206 Private INE522D07800 0MFL2016D - 1000.00 NonEquity Active 0MFL2016D 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 272128
272128 951315 9SEL2019C F Sadbhav Engineering Ltd. - (9SEL2019C) 113 Unspecified 206 Private INE226H07064 9SEL2019C - 1000000.00 NonEquity Active 9SEL2019C 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 272384
272384 538839 IPRU2571 F ICICI Prudential Growth Fund - Series 5 (Regular P... 113 Unspecified 206 Private INF109KA12K5 IPRU2571 - 10.00 NonEquity Active IPRU2571 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 272896
272896 951594 879MMFSL25 F Mahindra & Mahindra Financial Services Ltd. - (879... 113 Unspecified 206 Private INE774D07KW6 879MMFSL25 - 1000000.00 NonEquity Active 879MMFSL25 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 273152
273152 951678 820PGCIL30 F Power Grid Corporation of India Ltd. - (820PGCIL30... 113 Unspecified 206 Private INE752E07MH7 820PGCIL30 - 1000000.00 NonEquity Active 820PGCIL30 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 207872
207872 544162 BHARTIHEXA B Bharti Hexacom Ltd. 97 Telecommunication - Service  Provider 707 Bharti BHARTIHEXA EQ INE343G01021 Bharti Hexacom Ltd. MAN TEL Jagdish Saksena Deepak 20-04 1995 5.00 Active Active BHARTIHEXA 23489 L74899DL1995PLC067527 Active Active A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 208128
208128 533109 EURO MULTI Z Euro Multivision Ltd. 31 Consumer Durables - Electronics 206 Private EUROMULTI BZ INE063J01011 Euro Multivision MAN MAN Hitesh Shah 29-04 2004 10.00 InActive Suspended EUROMULTI 1665 L32300MH2004PLC145995 Suspended Suspended A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 273664
273664 0 Northern India Media Pvt Ltd. (Amalgamated) 113 Unspecified 206 Private Northern IndiaMedia MAN MAN 16-10 2006 0.00 Amalgamation Amalgamation 0 U22121DL2006PTC154799 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 208384
208384 0 Idea Mobile Communications Ltd. 97 Telecommunication - Service  Provider 206 Private Idea Mobile Communications Ltd. MAN TEL Kapish G Jian 25-05 1995 0.00 Amalgamation Amalgamation 0 U74899DL1995PLC068988 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274176
274176 537716 TFM46PD F TATA Fixed Maturity Plan Series 46 Scheme P - (TFM... 113 Unspecified 206 Private INF277K01O62 TFM46PD - 10.00 NonEquity Active TFM46PD 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274432
274432 0 Canara Robeco Capital Protection Oriented Fund - S... 113 Unspecified 206 Private CRMFCP5DG MF INF760K01HU2 CRMFCP5DG - 10.00 NonEquity Active 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274688
274688 34 S&P Ex BSEIT 147 Index 0 S&P Ex BSEIT - 0.00 Index Active 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 274944
274944 951990 105AAL2020 F Amtek Auto Ltd. - (105AAL2020) 113 Unspecified 206 Private INE130C07275 105AAL2020 - 1000000.00 NonEquity Active 105AAL2020 0 A
编辑 编辑复制 复制删除 删除
DELETE FROM `CompanyMaster` WHERE `CompanyMaster`.`fin_code` = 275968
275968 538255 RFHXXVI17G F Reliance FHF XXVI - Series 17 - (RFHXXVI17G) 113 Unspecified 206 Private INF204KA1X76 RFHXXVI17G - 10.00 NonEquity Active RFHXXVI17G 0 A
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出显示图表 显示图表新建视图 新建视图

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