Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: smartschool »Table: students
Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customise browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (519 total, Query took 0.0469 seconds.)
SELECT * FROM `students`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full texts 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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
Edit EditCopy CopyDelete Delete
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
With selected: With selected:
|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query