Recent
`surena_edbroad_old`.`api_student`
`sgm_crm`.`user_financial_years`
`sgm_crm`.`django_session`
`surena_crm`.`transaction_receipt_vouchers_old`
`surena_crm`.`sales_settings`
`sgm_crm`.`mastergst_tokens`
`surena_edbroad_old`.`users`
`sgm_crm`.`ledger_keys`
`sgm_crm`.`django_admin_log`
`sgm_crm`.`subsidy_scheme_documents`
Favourites
There are no favourite tables.
New
information_schema
mysql
payitsea_jnablr
performance_schema
phpmyadmin
rajkamal_crm
sgm_crm
surena
surena_code_editor
surena_crm
edbroad
surena_edbroad_1
surena_edbroad_old
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customise appearance of the navigation panel.
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
).
main
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.
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.
Servers
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.
Databases
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.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: payitsea_jnablr
Structure
SQL
Search
Query
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
(current)
Console
Clear
History
Options
Bookmarks
Debug SQL
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
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Showing rows 1 - 0.
Loading
ENUM/SET editor
Create view
-
Add new column
Name
Type
Length/Value
Default
Collation
Attribute
Null
A_I
INT
VARCHAR
TEXT
DATE
TINYINT
SMALLINT
MEDIUMINT
INT
BIGINT
-
DECIMAL
FLOAT
DOUBLE
REAL
-
BIT
BOOLEAN
SERIAL
DATE
DATETIME
TIMESTAMP
TIME
YEAR
CHAR
VARCHAR
-
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT
-
BINARY
VARBINARY
-
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB
-
ENUM
SET
GEOMETRY
POINT
LINESTRING
POLYGON
MULTIPOINT
MULTILINESTRING
MULTIPOLYGON
GEOMETRYCOLLECTION
JSON
Edit ENUM/SET values
None
As defined:
NULL
CURRENT_TIMESTAMP
armscii8_bin
armscii8_general_ci
armscii8_general_nopad_ci
armscii8_nopad_bin
ascii_bin
ascii_general_ci
ascii_general_nopad_ci
ascii_nopad_bin
big5_bin
big5_chinese_ci
big5_chinese_nopad_ci
big5_nopad_bin
binary
cp1250_bin
cp1250_croatian_ci
cp1250_czech_cs
cp1250_general_ci
cp1250_general_nopad_ci
cp1250_nopad_bin
cp1250_polish_ci
cp1251_bin
cp1251_bulgarian_ci
cp1251_general_ci
cp1251_general_cs
cp1251_general_nopad_ci
cp1251_nopad_bin
cp1251_ukrainian_ci
cp1256_bin
cp1256_general_ci
cp1256_general_nopad_ci
cp1256_nopad_bin
cp1257_bin
cp1257_general_ci
cp1257_general_nopad_ci
cp1257_lithuanian_ci
cp1257_nopad_bin
cp850_bin
cp850_general_ci
cp850_general_nopad_ci
cp850_nopad_bin
cp852_bin
cp852_general_ci
cp852_general_nopad_ci
cp852_nopad_bin
cp866_bin
cp866_general_ci
cp866_general_nopad_ci
cp866_nopad_bin
cp932_bin
cp932_japanese_ci
cp932_japanese_nopad_ci
cp932_nopad_bin
dec8_bin
dec8_nopad_bin
dec8_swedish_ci
dec8_swedish_nopad_ci
eucjpms_bin
eucjpms_japanese_ci
eucjpms_japanese_nopad_ci
eucjpms_nopad_bin
euckr_bin
euckr_korean_ci
euckr_korean_nopad_ci
euckr_nopad_bin
gb2312_bin
gb2312_chinese_ci
gb2312_chinese_nopad_ci
gb2312_nopad_bin
gbk_bin
gbk_chinese_ci
gbk_chinese_nopad_ci
gbk_nopad_bin
geostd8_bin
geostd8_general_ci
geostd8_general_nopad_ci
geostd8_nopad_bin
greek_bin
greek_general_ci
greek_general_nopad_ci
greek_nopad_bin
hebrew_bin
hebrew_general_ci
hebrew_general_nopad_ci
hebrew_nopad_bin
hp8_bin
hp8_english_ci
hp8_english_nopad_ci
hp8_nopad_bin
keybcs2_bin
keybcs2_general_ci
keybcs2_general_nopad_ci
keybcs2_nopad_bin
koi8r_bin
koi8r_general_ci
koi8r_general_nopad_ci
koi8r_nopad_bin
koi8u_bin
koi8u_general_ci
koi8u_general_nopad_ci
koi8u_nopad_bin
latin1_bin
latin1_danish_ci
latin1_general_ci
latin1_general_cs
latin1_german1_ci
latin1_german2_ci
latin1_nopad_bin
latin1_spanish_ci
latin1_swedish_ci
latin1_swedish_nopad_ci
latin2_bin
latin2_croatian_ci
latin2_czech_cs
latin2_general_ci
latin2_general_nopad_ci
latin2_hungarian_ci
latin2_nopad_bin
latin5_bin
latin5_nopad_bin
latin5_turkish_ci
latin5_turkish_nopad_ci
latin7_bin
latin7_estonian_cs
latin7_general_ci
latin7_general_cs
latin7_general_nopad_ci
latin7_nopad_bin
macce_bin
macce_general_ci
macce_general_nopad_ci
macce_nopad_bin
macroman_bin
macroman_general_ci
macroman_general_nopad_ci
macroman_nopad_bin
sjis_bin
sjis_japanese_ci
sjis_japanese_nopad_ci
sjis_nopad_bin
swe7_bin
swe7_nopad_bin
swe7_swedish_ci
swe7_swedish_nopad_ci
tis620_bin
tis620_nopad_bin
tis620_thai_ci
tis620_thai_nopad_ci
ucs2_bin
ucs2_croatian_ci
ucs2_croatian_mysql561_ci
ucs2_czech_ci
ucs2_danish_ci
ucs2_esperanto_ci
ucs2_estonian_ci
ucs2_general_ci
ucs2_general_mysql500_ci
ucs2_general_nopad_ci
ucs2_german2_ci
ucs2_hungarian_ci
ucs2_icelandic_ci
ucs2_latvian_ci
ucs2_lithuanian_ci
ucs2_myanmar_ci
ucs2_nopad_bin
ucs2_persian_ci
ucs2_polish_ci
ucs2_roman_ci
ucs2_romanian_ci
ucs2_sinhala_ci
ucs2_slovak_ci
ucs2_slovenian_ci
ucs2_spanish2_ci
ucs2_spanish_ci
ucs2_swedish_ci
ucs2_thai_520_w2
ucs2_turkish_ci
ucs2_unicode_520_ci
ucs2_unicode_520_nopad_ci
ucs2_unicode_ci
ucs2_unicode_nopad_ci
ucs2_vietnamese_ci
ujis_bin
ujis_japanese_ci
ujis_japanese_nopad_ci
ujis_nopad_bin
utf16_bin
utf16_croatian_ci
utf16_croatian_mysql561_ci
utf16_czech_ci
utf16_danish_ci
utf16_esperanto_ci
utf16_estonian_ci
utf16_general_ci
utf16_general_nopad_ci
utf16_german2_ci
utf16_hungarian_ci
utf16_icelandic_ci
utf16_latvian_ci
utf16_lithuanian_ci
utf16_myanmar_ci
utf16_nopad_bin
utf16_persian_ci
utf16_polish_ci
utf16_roman_ci
utf16_romanian_ci
utf16_sinhala_ci
utf16_slovak_ci
utf16_slovenian_ci
utf16_spanish2_ci
utf16_spanish_ci
utf16_swedish_ci
utf16_thai_520_w2
utf16_turkish_ci
utf16_unicode_520_ci
utf16_unicode_520_nopad_ci
utf16_unicode_ci
utf16_unicode_nopad_ci
utf16_vietnamese_ci
utf16le_bin
utf16le_general_ci
utf16le_general_nopad_ci
utf16le_nopad_bin
utf32_bin
utf32_croatian_ci
utf32_croatian_mysql561_ci
utf32_czech_ci
utf32_danish_ci
utf32_esperanto_ci
utf32_estonian_ci
utf32_general_ci
utf32_general_nopad_ci
utf32_german2_ci
utf32_hungarian_ci
utf32_icelandic_ci
utf32_latvian_ci
utf32_lithuanian_ci
utf32_myanmar_ci
utf32_nopad_bin
utf32_persian_ci
utf32_polish_ci
utf32_roman_ci
utf32_romanian_ci
utf32_sinhala_ci
utf32_slovak_ci
utf32_slovenian_ci
utf32_spanish2_ci
utf32_spanish_ci
utf32_swedish_ci
utf32_thai_520_w2
utf32_turkish_ci
utf32_unicode_520_ci
utf32_unicode_520_nopad_ci
utf32_unicode_ci
utf32_unicode_nopad_ci
utf32_vietnamese_ci
utf8_bin
utf8_croatian_ci
utf8_croatian_mysql561_ci
utf8_czech_ci
utf8_danish_ci
utf8_esperanto_ci
utf8_estonian_ci
utf8_general_ci
utf8_general_mysql500_ci
utf8_general_nopad_ci
utf8_german2_ci
utf8_hungarian_ci
utf8_icelandic_ci
utf8_latvian_ci
utf8_lithuanian_ci
utf8_myanmar_ci
utf8_nopad_bin
utf8_persian_ci
utf8_polish_ci
utf8_roman_ci
utf8_romanian_ci
utf8_sinhala_ci
utf8_slovak_ci
utf8_slovenian_ci
utf8_spanish2_ci
utf8_spanish_ci
utf8_swedish_ci
utf8_thai_520_w2
utf8_turkish_ci
utf8_unicode_520_ci
utf8_unicode_520_nopad_ci
utf8_unicode_ci
utf8_unicode_nopad_ci
utf8_vietnamese_ci
utf8mb4_bin
utf8mb4_croatian_ci
utf8mb4_croatian_mysql561_ci
utf8mb4_czech_ci
utf8mb4_danish_ci
utf8mb4_esperanto_ci
utf8mb4_estonian_ci
utf8mb4_general_ci
utf8mb4_general_nopad_ci
utf8mb4_german2_ci
utf8mb4_hungarian_ci
utf8mb4_icelandic_ci
utf8mb4_latvian_ci
utf8mb4_lithuanian_ci
utf8mb4_myanmar_ci
utf8mb4_nopad_bin
utf8mb4_persian_ci
utf8mb4_polish_ci
utf8mb4_roman_ci
utf8mb4_romanian_ci
utf8mb4_sinhala_ci
utf8mb4_slovak_ci
utf8mb4_slovenian_ci
utf8mb4_spanish2_ci
utf8mb4_spanish_ci
utf8mb4_swedish_ci
utf8mb4_thai_520_w2
utf8mb4_turkish_ci
utf8mb4_unicode_520_ci
utf8mb4_unicode_520_nopad_ci
utf8mb4_unicode_ci
utf8mb4_unicode_nopad_ci
utf8mb4_vietnamese_ci
BINARY
UNSIGNED
UNSIGNED ZEROFILL
on update CURRENT_TIMESTAMP
COMPRESSED=zlib
The central list of columns for the current database is empty
Add column
Select a table
a01_set_locations
a01_set_school_code
a01_set_school_info
a02_set_academic_year
a03_set_institutiontype
a04_set_course_group
a05_set_course_r_batch
a06_set_course_section
a07_set_course_r_batch_start_date
a07_set_header_group
a08_set_header
a09_set_lang_compit_list
a09_set_templates
a10_set_template_module
a11_set_ltnwise_assign_template
a12_set_ltnwise_asign_exam_grp
a13_set_ltnwise_asign_course_sec_grp
a14_set_ltnwise_asign_header
a15_set_ltnwise_asign_exam_grade_grp
a15_set_ltnwise_asign_exam_grade_grp_part_b
a16_set_ltnwise_asign_fee_grp
a17_set_ltnwise_remove_mob_menu
a18_set_ltnwise_asign_school_info
aa01_payroll_shift
aa01_payroll_shift_cron
aa02_payroll_shift_details
aa03_payroll_shift_halfday_value
aa04_payroll_salary_group
aa05_payroll_salary_group_earnings
aa06_payroll_salary_group_earnings_value
aa07_payroll_salary_group_deductions
aa08_payroll_salary_group_deductions_value
aa09_payroll_salary_group_tax
aa10_payroll_salary_group_tax_value
aa11_payroll_salary_advance
aa12_payroll_basic_salary
aa13_payroll_public_holidays
aa14_payroll_leave_types
aa15_payroll_assign_shifts
aa16_payroll_emp_leave_details
aa17_payroll_date_settings
aa18_payroll_weekends
aa19_payroll_report_formats
add_new_occupation
app_settings
attendancelog
attendancelog_bck
attendance_login_details
attendance_logout_details
b01_set_exam_parta_group
b01_set_exam_parta_terms
b02_set_exam_parta_mainactivity
b03_set_exam_parta_mainsubject
b04_set_exam_parta_coresubject
b05_set_exam_parta_subactivity
b06_set_exam_partbcd_type
b07_set_exam_partb_subjects
b08_set_exam_partbcd_activity
b09_set_exam_grade_method
b09_set_exam_grade_method_part_b
b09_set_exam_grade_method_view
b10_set_exam_grade_details
b10_set_exam_grade_details_part_b
b10_set_exam_grade_details_view
b11_set_compit_exam_master
b12_set_class_timetable_subject
b12_set_timetable_exams
b12_set_timetable_exam_details
b12_set_timetable_exam_subject
b12_set_timetable_notes
c01_aca_student_abstract_certificate
c01_aca_student_basic_details
c01_aca_student_study_certificate
c01_aca_student_transfer_certificate
c02_aca_student_other_details
c03_aca_student_custom_details
c05_aca_student_attendance_device
c06_aca_student_attendance
c06_aca_student_attendance_settings
c07_aca_student_apply_leave
c08_aca_student_attendance_verify
c08_attendance_verify_calendar_employee
c08_attendance_verify_calendar_student
c10_aca_student_application
c10_aca_student_application_online
c10_aca_student_application_online_payment_details
c11_aca_student_application_fee
c12_aca_main_events
c12_aca_sub_events
c13_aca_homework
c13_aca_homework_chapters
c13_aca_homework_done_students
c13_aca_homework_subject
c14_aca_gallery_album
c14_aca_homework_merged_pdf
c14_aca_photo_gallery
c14_aca_video_gallery
c14_aca_video_gallery_youtube
c15_aca_circular
c16_aca_public_holidays
d01_exam_parta_marks_entry
d02_exam_partbcd_marks_entry
d03_exam_parta_absentees
d04_exam_partb_absentees
d05_exam_health_status
d05_exam_remarks_entry
d05_marks_entry_history
d05_student_achivements_entry
d05_student_achivement_levels
d05_student_achivement_place
d05_student_achivement_portfolio
d05_student_remarks_category
d05_student_remarks_entry
d06_exam_attendance_entry
da8_co_scholastic_subjects
da8_exam_group
da8_exam_type
da8_scholastic_subjects
devices
e01_set_online_fee_group
e02_set_fee_feecategory
e02_set_online_fee_mainfee
e03_set_online_fee_payout_accounts
e03_set_online_fee_payout_splitdetails
e03_set_online_fee_subfee
e04_set_online_fee_feecategory
e05_set_fee_monthly_fee
e06_set_fee_months
e07_set_fee_monthlyfee_master
e08_set_fee_hostelfee
e08_set_fee_hostel_min_day_calc
e09_set_fee_hostelfee_master
e10_assign_hostel_to_students
e10_set_hostel_master
e10_set_online_fee_hostelfee_std_allot
e11_set_fee_individual_fee
e13_set_fee_individual_fee_assign_class
e13_set_hostel_fee_assign_class
e13_set_monthly_fee_assign_class
e13_set_online_fee_assign_feeto_class
e14_set_fee_individaul_fee_std_allot
e15_set_online_fee_transport_group
e16_set_fee_transport_min_day_calc
e17_set_fee_transport_months
e18_set_online_fee_transport_area
e19_set_online_fee_transport_area_amount
e20_set_online_fee_transport_assign_student
e21_fee_transcations
e22_fee_concession
f01_set_aca_bloodgroup
f02_set_aca_gender
f03_set_aca_caste
f04_set_aca_sub_caste
f05_set_aca_caste_category
f07_set_aca_oldnew
f08_set_aca_nationality
f09_set_aca_religion
f10_set_aca_attendance_sessions
f10_set_aca_attendance_value
f11_set_aca_attendance_data_fetch_type
f12_set_aca_mobile_app_type
f12_set_aca_mobile_menu
f13_set_aca_set_mobile_assign_menu
g01_set_emp_category
g02_set_emp_position
g03_set_emp_department
h01_emp_basic_details
h01_emp_documnet_details
h01_emp_language_details
h02_emp_batch_sec_permition
h02_emp_office_details
h03_emp_attendance
h04_emp_attendance_sessions
h05_emp_attendance_verify
h06_aca_emp_apply_leave
h06_emp_apply_leave
i01_set_payroll_emp_lop_wdays
i02_set_payroll_leave_types
i03_set_payroll_calc_settings
i04_set_payroll_salary_category
i05_set_payroll_salary_components
i06_set_payroll_gross_salary
j01_set_sms_category
j02_set_sms_category_message
j03_set_sms_sender_id
j04_set_sms_gateway
j04_set_sms_menu_list
k01_send_sms_details
k01_send_sms_details_individual
k01_sms_delivery_status
m01_set_omr_1-10
m01_set_omr_2-10
m02_set_omr_11-15
m03_set_omr_16-20
main_menu
mandatory_field_settings
mobile_menu_permission
mobile_menu_user_permission
omr_omrsms
opay_upi_response
otp_verify
parent_menu
pdf_list
report_login
report_user_login
sample_table
sb_ca_academics_classinfo
sb_ca_accounts_fee_master
sb_ca_accounts_hostel_transport_receiptformat
sb_ca_account_feetransaction_receipt
sb_ca_class_schoolname
sb_ca_settings_syllabusmaster
send_sms_status_record
sms_history
sub_menu
tally
user_menu_permission
user_role
user_role_permission
whatsapp_history
y01_eclass_category
y01_eclass_class
y01_eclass_subject
y02_eclass_chapters
y03_eclass_chapters_video
y03_eclass_chapters_video_youtube
y04_eclass_chapters_notes
y05_eclass_chapters_textbook
y11_eclass_test_questions
y12_eclass_test_choices
zoomtoken
zoom_credentials
zoom_credentials_web
z_dashboard_flashcard_wishes
z_mobile_aboutus
z_mobile_app_feedback
z_mobile_class_timetable
z_mobile_class_timetable_periods
z_mobile_class_timetable_update
z_mobile_eclass_menu_permission
z_mobile_emp_basic_details
z_mobile_emp_submenu_permission
z_mobile_exam_category
z_mobile_exam_result
z_mobile_fee_agreegator
z_mobile_fee_cal_conyenacefee
z_mobile_fee_ccavenue_payment_details
z_mobile_fee_transcations
z_mobile_fee_transcations_sessions1
z_mobile_fee_transcations_settlement
z_mobile_fee_transcations_status
z_mobile_flash_screen
z_mobile_help
z_mobile_home_menu_permission
z_mobile_live_class_groups
z_mobile_live_class_group_participants
z_mobile_live_class_hosts
z_mobile_live_class_schedule
z_mobile_logout_details
z_mobile_logout_schedule_date
z_mobile_menu_permission
z_mobile_notification
z_mobile_notification_individuals
z_mobile_online_exam_assign_pdfpaper
z_mobile_online_exam_assign_qtns
z_mobile_online_exam_category
z_mobile_online_exam_master
z_mobile_online_exam_master_omr
z_mobile_online_exam_master_omr_new
z_mobile_online_exam_omr_subjects
z_mobile_online_exam_omr_subjects_master
z_mobile_online_exam_std_upload_anspdf
z_mobile_online_exam_std_upload_anspdf_omr
z_mobile_online_exam_std_upload_anspdf_omrtempalte
z_mobile_online_exam_student_ans
z_mobile_online_fee_remarks
z_mobile_online_fixed_fee
z_mobile_online_fixed_fee_bck
z_mobile_online_fixed_fee_discount
z_mobile_online_fixed_fee_other
z_mobile_online_fixed_fee_tmp
z_mobile_online_oem_recent
z_mobile_online_oem_recent_omr
z_mobile_online_paying_amount
z_mobile_online_sub_fee_amount
z_mobile_online_upi_qrcode_details
z_mobile_question_paper_assign_qtns
z_mobile_question_paper_exam_master
z_mobile_question_paper_main_questions
z_mobile_question_paper_questions
z_mobile_reports
z_mobile_reports_user_group
z_mobile_student_basic_details
z_mobile_student_feedback_category
Select a column.