将文件拖动至此

SQL 上传 ( 0 ) x -

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





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

浏览模式

自定义浏览模式。

文档 仅使用图标、文字或都使用。
文档 仅使用图标、文字或都使用。
文档 设置是否给用户显示一个 "显示所有 (记录)" 的按钮。
文档 浏览结果集时显示的行数。若结果集总行数超过该值，将会显示 "上一页" 和 "下一页" 的链接。
文档 SMART - 即对 TIME、DATE、DATETIME 和 TIMESTAMP 类型的字段递减排序，其它字段递增。
文档 高亮鼠标指针所在的行。
文档 高亮选中的行。
文档
文档
文档 每 X 单元格重复表头，要禁止此功能请设为 0。
文档 浏览非数字字段时最多显示的字数。
文档 这些是编辑、复制和删除链接。
文档 缺少唯一键时是否显示行链接。
文档 默认用主键为表排序。
文档 当浏览表时使用上次的排序方式。
文档 显示选项
正在显示第 0 - 24 行 (共 517 行, 查询花费 0.2314 秒。)
SELECT * FROM `students`
[编辑内嵌] [ 编辑 ] [ 解析 SQL ] [ 创建 PHP 代码 ] [ 刷新]
|
|
|
行数：
过滤行:
按索引排序：
完整内容 idparent_idadmission_noroll_noadmission_datefirstnamelastnamerteimagemobilenoemailstatecitypincodereligioncastdobgendercurrent_addresspermanent_addresscategory_idroute_idschool_house_idblood_groupvehroute_idhostel_room_idadhar_nosamagra_idbank_account_nobank_nameifsc_codeguardian_isfather_namefather_phonefather_occupationmother_namemother_phonemother_occupationguardian_nameguardian_relationguardian_phoneguardian_occupationguardian_addressguardian_emailfather_picmother_picguardian_picis_activeprevious_schoolheightweightmeasurement_datedis_reasonnotedis_noteapp_keyparent_app_keydisable_atcreated_atupdated_at
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 44
44 88 ABC000001 2020-07-06 Victor Mbazo No uploads/student_images/no_image.png 71459579 victormbazo99@gmail.com / victor.mbazo@firstcapita... NULL NULL NULL NULL 1972-02-01 Male 9 0 0 0 0 NULL other Pastor N/A yes 2020-05-06 0 I am the senior pastor of Crown Gospel Ministries ... NULL NULL 0000-00-00 2021-04-06 15:26:49 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 45
45 90 ABC000002 2020-05-06 Letlhogonolo W. Lebotse No uploads/student_images/no_image.png 74251640 prexewisino@gmail.com NULL NULL NULL Christianity NULL 1992-10-06 Male Tlokweng 8 0 0 O+ 0 0 003814523 NULL FIRST NATIONAL BANK (FNB) mother Bridget Kitso Lebotse 71794259 Teacher Lebotse Mother 71616118 President Box 500100
Gaborone		 yes Kgalagadi South Brigade 1.85m 85kg 2020-05-06 0 NULL NULL 0000-00-00 2020-10-14 18:46:37 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 47
47 94 ABC000004 2020-05-14 Tshepo Lisa Gabaikitse No NULL 72989893 tshepogabaikitse@gmail.com NULL NULL NULL Christianity NULL 1991-10-10 Female P O Box 200 Moiyabana P O Box Moiyabana 8 0 0 0 0 293826711 NULL 1832113 Barclays Bank mother Morufeng Gabaikitse 71472910 Plant Foreman Opelo Gabaikitse 71858205 N/A Opelo Gabaikitse Mother 71858205 N/A P O Box 200 Moiyabana yes Botswana Accountancy College 65 2020-05-14 0 NULL NULL 0000-00-00 2021-06-03 15:30:53 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 48
48 96 ABC000005 2020-05-14 Temo Tau No NULL 74105004 norocmedia@gmail.com NULL NULL NULL 1977-02-22 Male 6 0 0 O+ 0 0 father Moroka  Tau 74105004 Pensioner Lillian Tau 72131099 Pensioner Temo Tau Father 74105004 Pensioner Box 499 Gabornoe norocmedia@gmail.com no 2020-05-14 2 Final Test Accounts NULL NULL 0000-00-00 2020-05-16 21:43:06 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 49
49 98 ABC000006 2020-05-14 Mbaakanyi Kenosi No uploads/student_images/no_image.png 73690847 1357kenosi@gmail.com NULL NULL NULL Christianity NULL 1988-05-06 Male PO BOX 20515, Francistown 10 0 0 0 0 124411512 NULL other N/A N/A yes Central University Colege, Degree (2016)
Mater Sp...		 2020-05-14 0 NULL NULL 0000-00-00 2020-05-14 12:38:49 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 50
50 100 ABC000007 2020-05-14 Motiki Ofentse No uploads/student_images/no_image.png 75569313 carportsexclusive@gmail.com NULL NULL NULL Christianity NULL 1980-08-15 Male PO BOX 550409, Mogoditshane 11 0 0 0 0 597319407 NULL other N/A N/A yes University of Botswana, Degree (2006) 2020-05-14 0 NULL NULL 0000-00-00 2022-09-09 11:02:11 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 51
51 102 ABC000008 2020-05-14 Chedu Maliko No uploads/student_images/no_image.png 71245260 highpriestchedumaliko@gmail.com NULL NULL NULL Christianity NULL 1989-03-28 Male Private Bag F237 10 0 0 0 0 982912611 NULL other N/A N/A yes Botswana Accountancy College, AAT (2011)
Botswana...		 2020-05-14 0 NULL NULL 0000-00-00 2020-05-14 12:34:56 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 52
52 104 ABC000009 2020-05-14 Dorido Mokate No uploads/student_images/no_image.png 71650907 mokated@gmail.com NULL NULL NULL Christianity NULL 1966-10-25 Male PO BOX 30365 Francistown 7 0 0 0 0 150213400 NULL other N/A N/A yes Moshupa Senior School, JC (1985) 2020-05-14 0 NULL NULL 0000-00-00 2020-05-14 12:31:25 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 53
53 106 ABC000010 2020-05-14 Mosweu Rekgatlhegile No uploads/student_images/no_image.png 73683586 rekgathegilemosweu@gmail.com NULL NULL NULL Christianity NULL 1984-09-07 Male PO BOX 666 Maun 10 0 0 0 0 000015014 NULL other N/A N/A yes Love Botswana College, Diploma (2019)
Maun Senior...		 2020-05-14 0 NULL NULL 0000-00-00 2020-10-21 10:22:26 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 54
54 108 ABC000011 2020-05-14 Moatlhodi Gabotshetse No uploads/student_images/no_image.png 72575378 NULL NULL NULL Christianity NULL 1973-05-13 Male P O BOX 25416 Gaborone P O BOX 25416 Gaborone 10 0 0 0 0 948715101 NULL other N/A N/A yes Midlands State University, Diploma  (2014) 2020-05-14 0 NULL NULL 0000-00-00 2020-05-14 12:43:19 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 55
55 110 ABC000012 2020-05-14 Mogorosi Boheto No uploads/student_images/no_image.png 76264008 mogorosibohsid@gmail.com NULL NULL NULL Christianity NULL 1983-08-14 Male PO BOX 309 LetlhakengPO BOX 309 Letlhakeng 8 0 0 0 0 108819218 NULL other Tshenolo Boheto N/A dophinalotshwalo@yahoo.com yes Bible Training Center for Pastors, Certificate (20... 2020-05-14 0 NULL NULL 0000-00-00 2020-05-14 12:40:52 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 56
56 112 ABC000013 2020-05-14 Mompati Kgaimena No uploads/student_images/no_image.png 71989294 mompatik@hotmail.com NULL NULL NULL Christianity NULL 1977-10-17 Male PO BOX AE746AEH, Molapo Crossing 9 0 0 0 0 680614603 NULL other N/A N/A yes Botswana Accountancy College, ACCA, (2015) 2020-05-14 0 NULL NULL 0000-00-00 2020-05-14 12:10:23 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 57
57 114 ABC000014 2020-05-14 Bathusi Gabosianelwe No uploads/student_images/no_image.png 73655311 aslambathusi@yahoo.com NULL NULL NULL Christianity NULL 1982-07-14 Male PO BOX 396, Molepolole 6 0 0 0 0 606410110 NULL other N/A N/A yes Kgarisechele Senior school, BGCSE (2002) 2020-05-14 0 NULL NULL 0000-00-00 2020-05-14 12:08:27 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 58
58 116 ABC000015 2020-05-14 James Tladi No uploads/student_images/no_image.png 72644325 jamestladi19@gmail.com NULL NULL NULL Christianity NULL 1969-02-04 Male PO BOX 404033, Gaborone
PO BOX 404033, Gaborone
 6 0 0 0 0 201410201 NULL other N/A N/A yes 2020-05-14 0 NULL NULL 0000-00-00 2020-08-24 11:18:49 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 60
60 120 ABC000017 2020-05-15 Tsaone Lesego Makula No uploads/student_images/no_image.png +267 75 125 350 tsaone.clix@gmail.com NULL NULL NULL Pentecostal NULL 1988-02-14 Male 8 0 0 0 0 052 913 013 NULL other N/A N/A yes Multimedia University 2007  B.I.T (Hon) 2020-05-15 0 NULL NULL 0000-00-00 2020-05-15 15:54:20 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 61
61 122 ABC000018 2020-05-15 Bame Balotlegi No uploads/student_images/no_image.png +267 71 485 277/ +267 75 774 993 balotlegi.b@gmail.com NULL NULL NULL Pentecostal NULL 1996-07-01 Female PO Box 665 Molepolole Lot 1846 8 0 13 0 0 033 120 819 NULL other Lerato Balotlegi 72876816 / 73876816 Lebang Balotlegi 72294760 / 73894760 Lebang Balotlegi Mother 72294760 yes Limkokwing University of creative Technology 2014 ... 50kg 2020-05-15 0 NULL NULL 0000-00-00 2020-06-16 14:31:13 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 62
62 124 ABC000019 2020-05-15 Onkabetse Tshipayagae No NULL 72818899 thusego3@gmail.com NULL NULL NULL 1985-08-18 Male 7 0 0 0 0 other David kgotla 71605047 N/A Nikie Kgotla 72357607 N/A Itumeleng Tshipayagae Brother 71777758 Engineer P O Box 426
Molepolole		 - yes 2020-05-15 0 NULL NULL 0000-00-00 2020-05-16 10:32:24 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 63
63 126 ABC000020 2018-07-16 Tapiwa Joseph No uploads/student_images/no_image.png 72229622 / 75985878 tmompoloki@yahoo.com NULL NULL NULL Christianity NULL 1976-11-15 Female PO BOX 2634 Gaborone 7 0 0 0 0 179926301 NULL other N/A N/A yes Realic Education Center, HRM (2012) 2020-05-16 0 NULL NULL 0000-00-00 2020-05-19 14:54:59 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 64
64 128 ABC000021 2018-07-16 Tirafalo Moipolai No uploads/student_images/no_image.png 77186170 NULL NULL NULL Christianity NULL 1990-09-11 Male PO BOX 546 Letlhakeng 7 0 0 0 0 886017317 NULL other N/A N/A yes 2020-05-16 0 NULL NULL 0000-00-00 2020-05-19 14:55:43 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 65
65 130 ABC000022 2018-07-16 Wellington Basera No uploads/student_images/no_image.png 77719077 wellibasera@gmail.com NULL NULL NULL Christianity NULL 1978-10-05 Male 7 0 0 0 0 EN755288 NULL other N/A N/A yes Tongwe Secondary School (1996)
Nyamuroro Institut...		 2020-05-16 0 NULL NULL 0000-00-00 2020-05-19 14:56:33 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 67
67 134 ABC000024 2020-05-17 Bakganedi Raphuthi No uploads/student_images/67.jpg 77000978 braphuti@gmail.com NULL NULL NULL NULL 1976-05-30 Male 7 0 0 0 0 687910208 NULL other Kenewang Raphuthi 7302570 yes 2020-05-17 0 NULL NULL 0000-00-00 2020-05-17 12:44:00 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 68
68 136 ABC000025 2018-07-16 Frank Masomosomo No uploads/student_images/no_image.png 76370305 / 77795034 frankmasomosomo370@gmail.com NULL NULL NULL Christianity NULL 1989-06-13 Male PO BOX 117 Selebi Phikwe 7 0 0 0 0 080012111 NULL other N/A N/A yes Kang Brigade, NCC (2013)
Letlhabile, JSS (2005)		 2020-05-17 0 NULL NULL 0000-00-00 2020-05-19 14:58:04 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 70
70 140 ABC000027 2018-07-16 Pinkie Onkemetse Thiite No uploads/student_images/no_image.png 75590600 pinkie.thiite@yahoo.com NULL NULL NULL Christianity NULL 1978-09-25 Female PO BOX 334 Gaborone 7 0 0 0 0 481329808 NULL other N/A N/A yes BIAC, (2001) 2020-05-17 0 NULL NULL 0000-00-00 2020-05-19 14:59:56 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 71
71 142 ABC000028 2018-07-16 Kebitsamang Connie Matobolo No uploads/student_images/no_image.png 72596685 connietoya@gmail.com NULL NULL NULL Christianity NULL 1982-11-21 Female PO BOX 1802 Jwaneng 7 0 0 0 0 104820813 NULL other N/A N/A yes CIPS, Diploma, Purchasing (2015)
Limkokwing Unive...		 2020-05-17 0 NULL NULL 0000-00-00 2020-09-18 10:49:34 NULL
编辑 编辑复制 复制删除 删除
DELETE FROM `students` WHERE `students`.`id` = 72
72 144 ABC000029 2018-07-16 Nayang Balebetse No uploads/student_images/no_image.png 71525266 nayangbalebetse@gmail.com NULL NULL NULL Christianity NULL 1980-04-12 Female PO BOX 97 JwanengPO BOX 97 Jwaneng 7 0 0 0 0 050225190 NULL other N/A N/A yes The University of Botswana, DTVE
Speciss College...		 2020-05-17 0 NULL NULL 0000-00-00 2020-05-19 15:02:32 NULL
选中项： 选中项：
|
|
|
行数：
过滤行:
按索引排序：
查询结果操作打印 打印复制到剪贴板 复制到剪贴板导出 导出 显示图表 显示图表 新建视图 新建视图

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