Drop files here

SQL upload ( 0 ) x -

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
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `c01_aca_student_basic_details`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts sid chatid roll_number
Roll Number
admission_number
Admission Number
sts_number
STS Number
first_name
First Name
last_name
Last Name
date_of_birth
Date Of Birth
blood_group_id
Blood Group
gender
Gender
nationality_id
Nationality
religion_id
Religion
caste_id
Caste
sub_caste_id
Sub Caste
caste_category_id
Caste Category
father_guardian_name
Father OR Guardian
father_guardian_qualification
Father OR Guardian Qualification
father_guardian_occupation
Father OR Guardian Occupation
mother_name
Mother Name
mother_qualification
Mother Qualification
mother_occupation
Mother Occupation
whatsapp_number
Whatsapp Number
whatsapp_number_new contact_one
Contact One
contact_two
Contact Two
email_address
Email Address
address_one
Address One
address_two
Address Two
city
City
zipcode
Zipcode
country_code
Country Code
student_image
Student Image
std_profile_image facility
Facility
previous_institution mode_of_transport
Mode of Transport
user_id password account_number
Account Number
bank_name
Bank Name
ifsc_code
IFSC Code
mob_app_permit
Mobile App Permit
eclass_id
Eclass
menu_type_id active_status sibling_id
Sibling One
sibling_id_1
Sibling Two
pr_location_id pr_location_name pr_yr_id
Present Year
pr_ac_year
Acadamic Year
pr_inst_type_id
Institution Type
pr_institution_type pr_cgroup_id
Course Group
pr_cgroup_name pr_course_id
Course
pr_course_name pr_section_id
Section
pr_section_name mobile_permission added_by device_type device_token added_at modified_by modified_at lang_compit_type omrexamtype
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 1
1 STDAISKGL1 1 I/1408/2018-19 152 228 884 Aadvika G 2012-05-24 0 3 1 1 1 1 1 Guruprasad A C PUC Business Meghana PUC House wife 9902999059 NULL 9902999059 Raghavendra Enterprises, Main Road Amruthur 0 0 design/app-assets/images/user/1.jpg 2 2 1 32 1 1 0 1 Kunigal 15 2021-22 29 School 87 ICSE 998 IP3 3989 A 1 0 2026-05-24 21:26:57 0 2026-05-24 21:26:57
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 2
2 STDAISKGL2 2 I/1407/2018-19 152 232 192 Aditya M 2012-04-10 0 2 1 1 1 1 1 Manjunatha A C B Com Business Mythri P U C House wife 9900599642 NULL 9900599642 Raghavendra Enterprises, Amruthur main road, Kunig... 0 0 design/app-assets/images/user/2.jpg 2 2 0 32 1 0 0 1 Kunigal 15 2021-22 29 School 87 ICSE 998 IP3 3989 A 0 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 3
3 STDAISKGL3 3 I/1409/2018-19 152 502 787 Advaith G 2012-06-22 0 2 1 1 1 1 1 Guruprasad A C PUC Buisness Meghana PUC House wife 9902999059 NULL 9902999059 0 Raghavendra enterprises, Main road near Swathanthr... 0 0 design/app-assets/images/user/3.jpg 2 2 1 32 1 1 0 1 Kunigal 15 2021-22 29 School 87 ICSE 998 IP3 3989 A 1 0 2026-05-11 18:31:12 0 2026-05-11 18:31:12
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 4
4 STDAISKGL4 4 1510/2018-19 155 011 741 Akshay H N 2012-04-23 0 2 1 1 1 1 1 H V Nagesh IInd PUC Business K J Vidyashree II nd PUC House wife 9742785595 NULL 9742785595 Hosapete , Huliyur durga, Kunigal(tq) Tumkur Dist 0 0 design/app-assets/images/user/4.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5113 A 1 0 2025-05-29 13:05:59 0 2025-05-29 13:05:59
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 5
5 STDAISKGL5 5 I/1571/2018-19 152 254 664 Ankeesh K Ramesh 2011-12-09 0 2 1 1 1 1 1 Ramesh K R Conductor Drakshaini H G House wife 9448745539 NULL 9448745539 KHB Colony, Kunigal , Tumkur Dist 0 0 design/app-assets/images/user/5.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5113 A 1 0 2025-05-09 11:39:07 0 2025-05-09 11:39:07
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 7
7 STDAISKGL7 7 I/1455/2018-19 153 080 236 Balakrishna K G 2012-02-17 0 2 1 1 1 1 1 K H Gangadaraiah BA Agriculture Hemalatha SSLC House wife 9986658742 NULL 9986658742 Kodi palya , Tioppasandra(H) Magadi (tq) Ramanagar... 0 0 design/app-assets/images/user/7.jpg 2 2 1 24 1 1 0 1 Kunigal 19 2025-26 37 School 110 CBSE 1266 CHS1 6642 F 1 0 2025-08-13 11:21:40 0 2025-08-13 11:21:40
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 8
8 STDAISKGL8 8 I/1518/2018-19 152 705 688 Brunda G N 2012-01-21 0 3 1 1 1 1 1 G S Narayan B A Farmer Shobha B N M A Teacher 9900989091 NULL 9900989091 Gangonahalli, Tippasandra Hobli, Magadi taluk, Ram... 0 0 design/app-assets/images/user/8.jpg 1 1 0 32 1 0 0 1 Kunigal 15 2021-22 29 School 87 ICSE 998 IP3 3989 A 0 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 9
9 STDAISKGL9 9 I/1541/2018-19 153 070 354 Chirag Gowda K J 2012-08-07 0 2 1 1 1 1 1 Jagadish K R S S L C BESCOM Shwetha Kumari M TCH Teacher 8310872446 NULL 9880289833 9591376326 8310872446 Kicchavadi, Halevoor post, Huliyur durga Hobli, Ku... 0 0 design/app-assets/images/user/9.jpg 2 2 1 24 1 1 0 1 Kunigal 19 2025-26 37 School 110 CBSE 1266 CHS1 6642 F 1 0 2025-08-05 15:01:50 0 2025-08-05 15:01:50
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 11
11 STDAISKGL11 11 I/1474/2018-19 152 514 336 Davanagiri S R 2011-12-03 0 2 1 1 1 1 1 Revanna T MA BEd Teacher Jyothi H N MA Teacher 9740078010 NULL 9740078010 Opp S L V Tiles , Andanaiah Extension, Kunigal ,Tu... 0 0 design/app-assets/images/user/11.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5113 A 1 0 2026-02-25 14:20:50 0 2026-02-25 14:20:50
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 12
12 STDAISKGL12 12 I/1303/2017-18 130 375 621 Diganth N 2011-06-23 0 2 1 1 1 1 1 Nagesh Bcom Tejaswini BA wife 7022532191 NULL 7022532191 7348844201 Siddemanipalya Kunigal (T) Tumkur(D) 0 0 design/app-assets/images/user/12.jpg 2 2 0 33 1 0 0 1 Kunigal 15 2021-22 29 School 87 ICSE 999 IP4 3993 A 0 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 13
13 STDAISKGL13 13 I/1552/2018-19 155 111 066 Gurunandan C R 2011-12-01 0 2 1 1 1 1 1 Raghavendra C S PUC Agriculture Gnaneshwari R B A House wife 9739154078 NULL 9739154078 Near KSRTC Bus stand , Amruthur, Kunigal (tq) Tumk... 0 0 design/app-assets/images/user/13.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5115 C 1 0 2025-06-17 14:58:57 0 2025-06-17 14:58:57
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 16
16 STDAISKGL16 16 I/1567/2018-19 152 540 972 Kruthika Y S 2012-09-09 0 3 1 1 1 1 1 Siddalingaprabhu Y S B Com Manager Asha P J B A House wife 7019569603 NULL 7019569603 9379519190 Yediyur, Kunigal taluk Tunkur Dist, 0 0 design/app-assets/images/user/16.jpg 2 2 1 36 1 1 0 1 Kunigal 18 2024-25 35 School 105 ICSE 1209 IG3 4833 A 1 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 17
17 STDAISKGL17 17 C/1414/2024-25 152 559 371 Laxman Ram B 2011-04-09 0 2 1 1 1 1 1 Basti Ram 6th std Business Indira 6th std House wife 9449777128 NULL 9449777128 Near ganesha temple , Doddapete, Kunigal, Tumkur ... 0 0 design/app-assets/images/user/17.jpg 2 2 1 24 1 1 0 1 Kunigal 19 2025-26 37 School 110 CBSE 1266 CHS1 6642 F 1 0 2025-07-21 16:24:57 0 2025-07-21 16:24:57
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 18
18 STDAISKGL18 18 I/1617/2018-19 152 300 186 Amrutha Vardhan 2011-11-10 0 3 1 1 1 1 1 Chikkanappa B G JOC Agriculture Manjula H H BA Teacher 8431994298 NULL 8431994298 9632025761 Chikkaramappa B.G, W/O Manjula, Huliyurdurga Near ... 0 0 design/app-assets/images/user/18.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5113 A 1 0 2025-06-06 10:23:13 0 2025-06-06 10:23:13
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 19
19 STDAISKGL19 19 I/1520/2018-19 152 564 432 Mohammed Bilal Shariff 2011-09-22 0 2 1 1 1 1 1 Tawfeeq Ahamed Shariff S S L C Business Seema Banu S S L C Housewife 9844224057 NULL 9844224057 Tanjavoor mohalla, Near Al huda  School, Kunigal ,... 0 0 design/app-assets/images/user/19.jpg 1 1 0 31 1 0 0 1 Kunigal 15 2021-22 29 School 87 ICSE 997 IP2 3985 A 0 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 20
20 STDAISKGL20 20 I/1584/2018-19 153 941 354 Niharika N Gowda 2011-07-11 0 3 1 1 1 1 1 Narasegowda Agriculture Shashikala Housewife 9901706253 NULL 9901706253 Hebbur, Tumkur (Dist) 0 0 design/app-assets/images/user/20.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5114 B 1 0 2025-06-04 12:46:32 0 2025-06-04 12:46:32
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 21
21 STDAISKGL21 21 I/1582/2018-19 153 953 546 Prarthana C J 2011-10-04 0 3 1 1 1 1 1 Jayanth Kumar SSLC Business Saritha H G S S L C House wife 9980424369 NULL 9980424369 Chowdanakuppe, Huliyur durga, Kunigal (tq) Tumkur(... 0 0 design/app-assets/images/user/21.jpg 2 2 1 35 1 1 0 1 Kunigal 17 2023-24 33 School 99 ICSE 1139 IG2 4553 A 1 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 22
22 STDAISKGL22 22 I/1594/2018-19 158 673 752 Punyashree 2011-10-25 0 3 1 1 1 1 1 Ashok SSLC Agriculture Varalakshmi II PUC Housewife 9743477007 NULL 9743477007 Girigowdanapalya, Tarikere(P) Kunigal(tq) Tumkur d... 0 0 design/app-assets/images/user/22.jpg 1 1 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5113 A 1 0 2025-05-21 12:53:43 0 2025-05-21 12:53:43
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 23
23 STDAISKGL23 23 C/1416/2024-25 152 623 746 Samarth Gowda G S 2012-10-25 0 2 1 1 1 1 1 Srinivasamurthy Agriculture Pushpa House wife 9731076616 NULL 9731076616 9902425806 Thippasandra(P) Magadi(tq) Ramanagar(Dist) 0 0 design/app-assets/images/user/23.jpg 2 2 1 24 1 1 0 1 Kunigal 19 2025-26 37 School 110 CBSE 1266 CHS1 6642 F 1 0 2026-02-04 17:51:48 0 2026-02-04 17:51:48
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 24
24 STDAISKGL24 24 C/311/2018-19 153 069 102 Sanjay K M 2011-10-08 0 2 1 1 1 1 1 Manjunatha R B S C Business Mamatha N C SSLC Housewife 9632814130 NULL 9632814130 Sri Siddeshwara Traders , B M Road , Beeraganahall... 0 0 design/app-assets/images/user/24.jpg 2 AIRS 2 1 20 1 1 0 1 Kunigal 15 2021-22 29 School 86 CBSE 986 CP4 3941 A 1 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 25
25 STDAISKGL25 25 I/1538/2018-19 152 625 235 Sathvik N 2012-06-10 0 2 1 1 1 1 1 Nagendra M K B Com Business Shruthi B Com House wife 9480408643 NULL 9480363600 KNK Villa Canarabank road , Kunigal, Tumkur dist. 0 0 design/app-assets/images/user/25.jpg 2 2 1 36 1 1 0 1 Kunigal 18 2024-25 35 School 105 ICSE 1209 IG3 4833 A 1 0 2025-05-12 11:59:42 0 2025-05-12 11:59:42
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 26
26 STDAISKGL26 26 i/1555/2018-19 155 049 625 Shivani Shetty H V 2012-09-26 0 3 1 1 1 1 1 Vittal H S SSLC Auto driver Savitha R SSLC House wife 6363764879 NULL 6363764879 6363757447 #313, K R S agrahara, Bank colony, Kunigal, Tumkur... 0 0 design/app-assets/images/user/26.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5113 A 1 0 2025-05-30 11:35:24 0 2025-05-30 11:35:24
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 27
27 STDAISKGL27 27 I/1453/2018-19 155 102 802 Shreya Gowda U K 2012-08-06 0 3 1 1 1 1 1 Kantharaju LTC Business Uma N K B A Housewife 9980847372 NULL 9980847372 636282384 K R S Agrahara, Bank Colony, Veerabhadra colutry s... 0 0 design/app-assets/images/user/27.jpg 2 2 0 33 1 0 0 1 Kunigal 15 2021-22 29 School 87 ICSE 999 IP4 3993 A 0 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 29
29 STDAISKGL29 29 I/1551/2018-19 154 431 384 Tanay Hruday S 2012-02-13 0 2 1 1 1 1 1 Siddalingappa S R S S L C Agriculture Pavithra M B B A House wife 9743396033 NULL 9743396033 8762323673 Sulekuppe, Tharedakuppe(p)kotthahere(h) Kunigal (t... 0 0 design/app-assets/images/user/29.jpg 2 2 1 37 1 1 0 1 Kunigal 19 2025-26 37 School 111 ICSE 1279 IHS1 5113 A 1 0 2025-08-09 17:26:28 0 2025-08-09 17:26:28
Edit Edit Copy Copy Delete Delete
DELETE FROM c01_aca_student_basic_details WHERE `c01_aca_student_basic_details`.`sid` = 31
31 STDAISKGL31 31 I/1479/2018-19 152 658 026 Varshini B H 2011-11-13 0 3 1 1 1 1 1 Honne Gowda B R SSLC Business Sunanadamma PUC Housewife 9901248564 NULL 9901248564 Sri maruthi provision store, Jaladigere road, Beer... 0 0 design/app-assets/images/user/31.jpg 2 2 1 33 1 1 0 1 Kunigal 15 2021-22 29 School 87 ICSE 999 IP4 3995 C 1 0 2024-06-26 16:51:38 0 2024-06-26 16:51:38
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query