competence-rs.com / localhost / hmis / cervicalthorasics

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize 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.
Favorite tables Maximum number of favorite tables; set 0 to disable.

Navigation tree

Customize 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

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: localhost »

Database: hmis »

Table: cervicalthorasics

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:

Do a "query by example" (wildcard: "%")

Column	Type	Collation
id	int(11)

mrno	varchar(20)	latin1_swedish_ci

ipno	varchar(20)	latin1_swedish_ci

report_date_time	datetime

patient_name	varchar(200)	latin1_swedish_ci

sex	varchar(20)	latin1_swedish_ci

age	int(3)

onset_date_of_condition	date

treatment_diagnosis	tinytext	latin1_swedish_ci

post_op_day	varchar(50)	latin1_swedish_ci

post_op_month	varchar(50)	latin1_swedish_ci

post_op_year	varchar(50)	latin1_swedish_ci

primary_diagnosis	varchar(250)	latin1_swedish_ci

physician	varchar(250)	latin1_swedish_ci

medical_history	text	latin1_swedish_ci

surgical_history	text	latin1_swedish_ci

lab_test	text	latin1_swedish_ci

radiology_test	text	latin1_swedish_ci

medications_medicine	varchar(300)	latin1_swedish_ci

medication_duration	varchar(200)	latin1_swedish_ci

precautions	tinytext	latin1_swedish_ci

history_of_present_injury	tinytext	latin1_swedish_ci

chief_complaint	tinytext	latin1_swedish_ci

pain	varchar(300)	latin1_swedish_ci

pain_scale	tinyint(2)

pain_nature	varchar(300)	latin1_swedish_ci

prior_level_of_function	varchar(300)	latin1_swedish_ci

curr_fun_info	tinytext	latin1_swedish_ci

sleeping_position	varchar(300)	latin1_swedish_ci

num_pillows	tinyint(2)

night_pain	varchar(100)	latin1_swedish_ci

night_pain_nature	varchar(300)	latin1_swedish_ci

posture_gross	varchar(20)	latin1_swedish_ci

flexion_ca_prom_t	varchar(50)	latin1_swedish_ci

flexion_ca_rt	varchar(50)	latin1_swedish_ci

extension_ca_prom_t	varchar(50)	latin1_swedish_ci

extension_ca_rt	varchar(50)	latin1_swedish_ci

r_side_bend_ca_prom_t	varchar(50)	latin1_swedish_ci

r_side_bend_ca_rt	varchar(50)	latin1_swedish_ci

l_side_bend_ca_prom_t	varchar(50)	latin1_swedish_ci

l_side_bend_ca_rt	varchar(50)	latin1_swedish_ci

rotation_r_ca_prom_t	varchar(50)	latin1_swedish_ci

rotation_r_ca_rt	varchar(50)	latin1_swedish_ci

rotation_l_ca_prom_t	varchar(50)	latin1_swedish_ci

rotation_l_ca_rt	varchar(50)	latin1_swedish_ci

pro_retraction_ca_prom_t	varchar(50)	latin1_swedish_ci

pro_retraction_ca_rt	varchar(50)	latin1_swedish_ci

retraction_w_ext_ca_prom_t	varchar(50)	latin1_swedish_ci

retraction_w_ext_ca_rt	varchar(50)	latin1_swedish_ci

flexion	varchar(20)	latin1_swedish_ci

extension	varchar(20)	latin1_swedish_ci

lifting	varchar(20)	latin1_swedish_ci

carrying	varchar(20)	latin1_swedish_ci

reading	varchar(20)	latin1_swedish_ci

sleeping	varchar(20)	latin1_swedish_ci

driving	varchar(20)	latin1_swedish_ci

computer_work	varchar(20)	latin1_swedish_ci

am	varchar(20)	latin1_swedish_ci

pm	varchar(20)	latin1_swedish_ci

still	varchar(20)	latin1_swedish_ci

on_the_move	varchar(20)	latin1_swedish_ci

as_day_progress	varchar(20)	latin1_swedish_ci

created_date	datetime

created_by	varchar(20)	latin1_swedish_ci

modified_date	datetime

modified_by	varchar(20)	latin1_swedish_ci

locationname	varchar(20)	latin1_swedish_ci

Select columns (at least one): DISTINCT

Or Add search conditions (body of the "where" clause):

Number of rows per page

Display order:

Ascending

Descending

id
mrno
ipno
report_date_time
patient_name
sex
age
onset_date_of_condition
treatment_diagnosis
post_op_day
post_op_month
post_op_year
primary_diagnosis
physician
medical_history
surgical_history
lab_test
radiology_test
medications_medicine
medication_duration
precautions
history_of_present_injury
chief_complaint
pain
pain_scale
pain_nature
prior_level_of_function
curr_fun_info
sleeping_position
num_pillows
night_pain
night_pain_nature
posture_gross
flexion_ca_prom_t
flexion_ca_rt
extension_ca_prom_t
extension_ca_rt
r_side_bend_ca_prom_t
r_side_bend_ca_rt
l_side_bend_ca_prom_t
l_side_bend_ca_rt
rotation_r_ca_prom_t
rotation_r_ca_rt
rotation_l_ca_prom_t
rotation_l_ca_rt
pro_retraction_ca_prom_t
pro_retraction_ca_rt
retraction_w_ext_ca_prom_t
retraction_w_ext_ca_rt
flexion
extension
lifting
carrying
reading
sleeping
driving
computer_work
am
pm
still
on_the_move
as_day_progress
created_date
created_by
modified_date
modified_by
locationname