Recent
`mycbtexamdb`.`setcbtexamquestionstb`
`performance_schema`.`setup_objects`
`cbtserver`.`terms`
`mysql`.`event`
`mycbtexamdb`.`viewanswerstb`
`cbtserver`.`subjects`
`mycbtexamdb`.`passwordtb`
`cbt_platform`.`question_solutions`
`mysql`.`transaction_registry`
`performance_schema`.`events_statements_summary_by_user_by_event_name`
Favorites
There are no favorite tables.
New
cbtserver
cbtserver2
cbt_platform
cbt_platform
cbt_platform_hub
information_schema
mycbtexamdb
mysql
performance_schema
phpmyadmin
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
Customize 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.
Favorite tables
Maximum number of favorite tables; set 0 to disable.
Navigation panel width
Set to 0 to collapse navigation panel.
Navigation tree
Customize 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: cbt_platform
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
log_id
user_id
action
details
ip_address
user_agent
created_at
*
category_id
category_name
created_at
*
class_id
category_id
level_id
arm_id
created_at
*
arm_id
arm_name
created_at
*
level_id
category_id
level_name
created_at
*
attempt_id
parameter_id
student_id
attempt_number
question_order
status
started_at
last_activity_at
submitted_at
time_remaining_seconds
current_question_index
ip_address
device_info
*
parameter_id
school_id
session_id
term_id
exam_type_id
class_id
subject_id
teacher_id
question_mode
is_class_bank
duration_seconds
total_questions
pass_mark
max_score
randomize_questions
randomize_options
questions_locked
answers_locked
rewrite_allowed
max_attempts
result_visible
status
created_at
updated_at
*
id
source_parameter_id
target_parameter_id
question_count
created_at
*
id
parameter_id
class_id
added_at
*
exam_type_id
type_name
created_at
*
violation_id
attempt_id
violation_type
occurred_at
*
attempt_id
username
ip_address
success
attempted_at
*
notification_id
user_id
title
message
type
is_read
created_at
*
id
parameter_id
student_id
assigned_by
assigned_at
*
id
parameter_id
student_id
granted_by
granted_at
*
passage_id
parameter_id
title
body
image_path
created_at
*
reset_id
user_id
token_hash
expires_at
used
created_at
*
question_id
parameter_id
passage_id
question_text
question_image
option_count
difficulty
topic
version
is_active
sort_order
created_at
updated_at
*
option_id
question_id
option_label
option_text
option_image
is_correct
sort_order
created_at
*
solution_id
question_id
explanation
image_path
video_url
reference_url
created_at
*
result_id
attempt_id
parameter_id
student_id
total_questions
correct_count
wrong_count
skipped_count
score
percentage
grade
remark
passed
time_used_seconds
class_rank
created_at
*
role_id
role_name
description
created_at
*
session_id
session_name
is_current
created_at
*
setting_key
setting_value
created_at
*
answer_id
attempt_id
question_id
selected_option_id
option_order
status
is_correct
answered_at
*
subject_id
subject_name
subject_code
status
created_at
*
id
teacher_id
subject_id
class_id
created_at
*
term_id
term_name
created_at
*
user_id
school_id
section
role_id
surname
first_name
middle_name
gender
admission_number
staff_id
username
password_hash
must_change_password
phone
email
class_id
session_id
photo_path
status
last_login_at
last_login_ip
created_at
updated_at
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
audit_logs
categories
classes
class_arms
class_levels
exam_attempts
exam_parameters
exam_parameter_question_shares
exam_parameter_shared_arms
exam_types
exam_violations
login_attempts
notifications
parameter_students
parameter_student_rewrites
passages
password_resets
questions
question_options
question_solutions
results
roles
sessions_academic
settings
student_answers
subjects
teacher_subjects
terms
users
.
select column