abcbots.ngrok.io / 127.0.0.1 / smartschool / online_admissions

`smartschool`.`fees_discounts`
`smartschool`.`staff_leave_details`
`smartschool`.`transport_route`
`smartschool`.`income_head`
`lowa`.`countries`
`smartschool`.`follow_up`
`lowa`.`roles`
`smartschool`.`fee_receipt_no`
`lowa`.`newsletters`
`smartschool`.`school_houses`
 `lowa`.`invoice_items`
 `abcschool33`.`item`
 `abcschool33`.`events`
 `smartschool3`.`item`
 `smartschool`.`reference`
 `smartschool`.`languages`
 `mysql`.`help_category`

  
New
cm9vdA==.YWJjcm9vdA==.YWJj0
abc
cm9vdA==.YWJjc2Nob29sMg==cm9vdA==.YWJjc2Nob29sMg==0
abcschool2
cm9vdA==.YWJjc2Nob29sMzM=cm9vdA==.YWJjc2Nob29sMzM=0
abcschool33
cm9vdA==.YWJjc2Nob29sMzMzcm9vdA==.YWJjc2Nob29sMzMz0
abcschool333
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.bG93YQ==cm9vdA==.bG93YQ==0
lowa
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.c21hcnRzY2hvb2w=cm9vdA==.c21hcnRzY2hvb2w=0
smartschool
cm9vdA==.c21hcnRzY2hvb2wxcm9vdA==.c21hcnRzY2hvb2wx0
smartschool1
cm9vdA==.c21hcnRzY2hvb2wzcm9vdA==.c21hcnRzY2hvb2wz0
smartschool3
cm9vdA==.c21hcnRzY2hvb2wxMTE=cm9vdA==.c21hcnRzY2hvb2wxMTE=0
smartschool111
cm9vdA==.c21hcnRzY2hvb2wyMjI=cm9vdA==.c21hcnRzY2hvb2wyMjI=0
smartschool222
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customise appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Navigation tree

Customise the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers

Servers display options.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »

Database: smartschool »

Table: online_admissions

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

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

Browse mode

Browse mode

Customise browse mode.

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 11 (12 total, Query took 0.0371 seconds.)

SELECT * FROM `online_admissions`

[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]

Filter rows:

			id	admission_no	roll_no	admission_date	firstname	lastname	rte	image	mobileno	email	state	city	pincode	religion	cast	dob	gender	current_address	permanent_address	category_id	class_section_id	route_id	school_house_id	blood_group	vehroute_id	hostel_room_id	adhar_no	samagra_id	bank_account_no	bank_name	ifsc_code	guardian_is	father_name	father_phone	father_occupation	mother_name	mother_phone	mother_occupation	guardian_name	guardian_relation	guardian_phone	guardian_occupation	guardian_address	guardian_email	father_pic	mother_pic	guardian_pic	is_enroll	previous_school	height	weight	note	measurement_date	app_key	document	disable_at	created_at	updated_at
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 4	4	ABC000004		2020-05-14	Tshepo	Gabaikitse	No	NULL	72989893	tshepogabaikitse@gmail.com	NULL	NULL	NULL	Christianity		1991-10-10	Female	P O Box 200 Moiyabana	P O Box Moiyabana	8	53	0	0		0	0	293826711	293826711	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					1	Botswana Accountancy College		65		2020-05-14	NULL	NULL	0000-00-00	2020-05-14 10:02:45	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 8	8	ABC000019		2020-05-15	Onkabetse	Tshipayagae	No	NULL	72818899	thusego3@gmail.com	NULL	NULL	NULL			1985-08-18	Male			7	105	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	-				1					2020-05-15	NULL	7f7112d5dd604b0297be3846a6a4378f.pdf	0000-00-00	2020-05-16 10:32:24	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 11	11	ABC000024		2020-05-17	Bakganedi	Raphuthi	No	NULL	77000978	braphuti@gmail.com	NULL	NULL	NULL			1976-05-30	Male			7	105	0	0		0	0						other							Kenewang Raphuthi		7302570							1					2020-05-17	NULL	ab1a30a27e8a97f134ade1da045d1185.pdf	0000-00-00	2020-05-17 12:38:32	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 13	13	ABC000131		2020-05-19	KEFILWE	MOLAODI	No	NULL			NULL	NULL	NULL			1988-07-01	Female			0	94	0	0		0	0						other	TEKONYANE MOLAODI	74755325	PENSIONER	PUPENYANE G. MOLAODI	71149480	PENSIONER	REBECCA S.KGENGWENYANE	SISTER	72553661	SENIOUR HOSPITAL ORDERLY	PO BOX 123 DIGAWANA					1					2020-05-19	NULL	NULL	0000-00-00	2020-05-27 12:31:27	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 14	14	ABC000132		2020-05-27	TSHEPO	MOBEA	No	NULL			NULL	NULL	NULL			1989-06-27	Female			0	81	0	0		0	0						mother				JOYCE MOSALAKATANE	72191606	N/A	JOYCE MOSALAKATANE	Mother	72191606	N/A	P O BOX 3412 GABORONE					1					2020-05-27	NULL	fb5607f2ee337901ca7ec7a4c9f8d0cc.pdf	0000-00-00	2020-05-27 12:32:26	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 16	16	ABC000164		2020-06-18	Kaone	Mahuma	No	NULL			NULL	NULL	NULL			1980-11-28	Male			0	241	0	0		0	0						other		71844349		Bino Mahuma	71436878	NL	Gosego Mahuma	Spouse	73844349	Teacher	Box 14BBG Molapowabojang	gosegomahuma@gmail.com				1					2020-06-18	NULL	NULL	0000-00-00	2020-08-03 09:15:14	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 18	18	ABC000147		2020-06-25	SETLOTLEGENG	NYONI	No	NULL	75223331	setlotlegengnyoni@yahoo.co.uk	NULL	NULL	NULL	Pentecostal		1973-12-15	Female			0	105	0	0		0	0						other	GABOFETSWE BEMOLE	LATE		MASALELA BEMOLE	74304850	FARMER	ADMIRE NYONI	HUSBAND	75223333	DIRECTOR	P O Box 653 Letlhakane	adnyoni@yahoo.com				1					2020-06-25	NULL	cc2e9aa773ea14aa75fd62ead993edf9.PDF	0000-00-00	2020-06-25 11:10:01	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 24	24	NULL	NULL	2020-07-03	Moses L. G.	Letso	No	NULL	NULL	NULL	NULL	NULL	NULL	NULL		1975-09-19	Male	NULL	NULL	NULL	149	0	NULL		0	0	NULL	NULL	NULL	NULL	NULL	other	Letso Rakapo	N/A	Deceased	Neo Maria Rakapo	N/A	Deceased	Rebaone J. Rakapo-Tshupelo	Sister	71734396	Senior Registration Officer	P O Box 20970, Gaborone	Rjtshupelo@gov.bw				0	NULL				2020-07-03	NULL	33827923abd29074bc5706c5edf11f06.pdf	0000-00-00	2020-07-03 02:41:00	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 25	25	ABC000206		2021-03-23	DITIRO	Kethamile	No	NULL			NULL	NULL	NULL			2000-02-03	Male			0	257	0	0		0	0						mother		74512287					Mpekene serokolo	Mother	71867486	Sos mother	30202					1					2021-03-23	NULL	NULL	0000-00-00	2021-04-06 16:11:34	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 27	27	NULL		2021-04-16	Stephen	Macharia	No	NULL			NULL	NULL	NULL			1982-08-14	Male			0	201	0	0		0	0						mother	Elijohn Ngugi Njomo	+254722465853	Deceased	Milkah Njeri Kuria	+2540716350564	Business	Milkah Njeri Kuria	Mother	+2540716350564	Business	Kenya	nlsdoc@yahoo.com				0					2021-04-16	NULL	NULL	0000-00-00	2021-05-24 14:26:26	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 29	29	ABC000229		2021-06-10	Gomolemo Jackson	Smarts	No	NULL			NULL	NULL	NULL			1981-04-15	Male			0	257	0	0		0	0						other							Betty Pearl Smarts	Spouse	75910291	Self Employed	P O Box 73 Ranaka	bettysmarts45@gmail.com				1					2021-06-10	NULL	NULL	0000-00-00	2021-06-11 08:54:29	NULL
Edit	Copy	Delete DELETE FROM `online_admissions` WHERE `online_admissions`.`id` = 30	30	NULL	NULL	2021-07-31	Leonard	Sebake	No	NULL	NULL	NULL	NULL	NULL	NULL	NULL		1988-11-04	Male	NULL	NULL	NULL	325	0	NULL		0	0	NULL	NULL	NULL	NULL	NULL	mother	Non	Non	Non	Bosele Sebake	71351655	Retired	Bosele Sebake	Mother	71351655	Retired	Block 8	lsebake@ymail.com				0	NULL				2021-07-31	NULL	NULL	0000-00-00	2021-07-31 02:23:41	NULL

Check all With selected:

Filter rows:

Query results operations