近期访问
`hmis`.`foreigners`
`herp`.`attendance_complesation`
`hmis`.`doctorconsdetails`
`herp`.`addissue`
`hmis`.`anesthesia_records`
`hmis`.`brandnames`
`hmis`.`batchdetails`
`hmis`.`clinicalfindings`
`hmis`.`block_masters`
`herp`.`account_purchase_billbook`
表收藏夹
表收藏夹为空。
新建
cm9vdA==.aGVycA==
cm9vdA==.aGVycA==
0
herp
cm9vdA==.aG1pcw==
cm9vdA==.aG1pcw==
0
hmis
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==
cm9vdA==.cGhwbXlhZG1pbg==
0
phpmyadmin
cm9vdA==.dGVzdA==
cm9vdA==.dGVzdA==
0
test
导航面板
导航树
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL upload (
0
)
x
-
该处必须启用 Javascript!
服务器: localhost
»
数据库: hmis
结构
SQL
搜索
查询
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库:
hmis
查询时间:
在当前会话期间
SELECT * FROM `drugissue_batch_issues`
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
记录数:
用时:
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
Ok
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库:
查询时间:
+
添加新字段
名字
类型
长度/值
默认
排序规则
属性
空
自增
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
MEDIUMBLOB
BLOB
LONGBLOB
-
ENUM
SET
GEOMETRY
POINT
LINESTRING
POLYGON
MULTIPOINT
MULTILINESTRING
MULTIPOLYGON
GEOMETRYCOLLECTION
Edit ENUM/SET values
无
定义:
NULL
CURRENT_TIMESTAMP
armscii8_bin
armscii8_general_ci
ascii_bin
ascii_general_ci
big5_bin
big5_chinese_ci
binary
cp1250_bin
cp1250_croatian_ci
cp1250_czech_cs
cp1250_general_ci
cp1250_polish_ci
cp1251_bin
cp1251_bulgarian_ci
cp1251_general_ci
cp1251_general_cs
cp1251_ukrainian_ci
cp1256_bin
cp1256_general_ci
cp1257_bin
cp1257_general_ci
cp1257_lithuanian_ci
cp850_bin
cp850_general_ci
cp852_bin
cp852_general_ci
cp866_bin
cp866_general_ci
cp932_bin
cp932_japanese_ci
dec8_bin
dec8_swedish_ci
eucjpms_bin
eucjpms_japanese_ci
euckr_bin
euckr_korean_ci
gb2312_bin
gb2312_chinese_ci
gbk_bin
gbk_chinese_ci
geostd8_bin
geostd8_general_ci
greek_bin
greek_general_ci
hebrew_bin
hebrew_general_ci
hp8_bin
hp8_english_ci
keybcs2_bin
keybcs2_general_ci
koi8r_bin
koi8r_general_ci
koi8u_bin
koi8u_general_ci
latin1_bin
latin1_danish_ci
latin1_general_ci
latin1_general_cs
latin1_german1_ci
latin1_german2_ci
latin1_spanish_ci
latin1_swedish_ci
latin2_bin
latin2_croatian_ci
latin2_czech_cs
latin2_general_ci
latin2_hungarian_ci
latin5_bin
latin5_turkish_ci
latin7_bin
latin7_estonian_cs
latin7_general_ci
latin7_general_cs
macce_bin
macce_general_ci
macroman_bin
macroman_general_ci
sjis_bin
sjis_japanese_ci
swe7_bin
swe7_swedish_ci
tis620_bin
tis620_thai_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_german2_ci
ucs2_hungarian_ci
ucs2_icelandic_ci
ucs2_latvian_ci
ucs2_lithuanian_ci
ucs2_myanmar_ci
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_ci
ucs2_vietnamese_ci
ujis_bin
ujis_japanese_ci
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_german2_ci
utf16_hungarian_ci
utf16_icelandic_ci
utf16_latvian_ci
utf16_lithuanian_ci
utf16_myanmar_ci
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_ci
utf16_vietnamese_ci
utf16le_bin
utf16le_general_ci
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_german2_ci
utf32_hungarian_ci
utf32_icelandic_ci
utf32_latvian_ci
utf32_lithuanian_ci
utf32_myanmar_ci
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_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_german2_ci
utf8_hungarian_ci
utf8_icelandic_ci
utf8_latvian_ci
utf8_lithuanian_ci
utf8_myanmar_ci
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_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_german2_ci
utf8mb4_hungarian_ci
utf8mb4_icelandic_ci
utf8mb4_latvian_ci
utf8mb4_lithuanian_ci
utf8mb4_myanmar_ci
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_ci
utf8mb4_vietnamese_ci
BINARY
UNSIGNED
UNSIGNED ZEROFILL
on update CURRENT_TIMESTAMP
当前数据库的列的中央列表是空的。
添加字段
选择表
ERwe
OPS
abg_settings
acceptissue_details
acceptissues
account_groups
addictions
addresses
adiagnosis
adjust_stock_batches
adjust_stock_items
adjust_stocks
adjustmenttypes
allergies
alternatitemdetails
alternatitems
anesthesia_details
anesthesia_record_grids
anesthesia_records
anesthesia_timings
anesthesias
antenatal_care_clinicals
antenatal_care_instructions
antenatal_cares
anticoagulants
asset_issue
asset_issue_details
asset_return
asset_return_details
assign_checkup_counters
assign_roles
assigncounters
authorizationglobalremarks
authorizationremarks
authorizations
authorizationtests
baby_notes
baseunits
batch_issue_accepts
batchdetails
batchissues
bd_totalquantities
bedallocations
bedcharge_details
bedcharges
beds
bedtypes
bill_classes
bills
birthdetails
block_masters
bloodbanks
bloodcancellations
bloodcomponents
blooddonors
bloodgroups
bloodprofiles
bloodreceives
bloodrejects
bloodsdetails
bloodsecurities
bloodsugar_details
bloodsugars
booking_status
branditems
brandnames
breasons
buckets
businessparameters
camp_contacts
camp_masters
camp_types
cancelappointments
categories
category_masters
category_types
categoryrates
cervicalthorasics
cfpreferances
checklists
checkup_counters
chemistries
cities
clientvisitdetails
clinicalfindings
closecntreports
closecounters
cnssidetails
comparative_details
comparatives
complications
componentdetails
consentdetails
consultations
consumable_batch_details
consumable_batch_entries
consumable_entries
consumable_item_entries
consumables
counsellings
counter_masters
countries
country_masters
create_vendor_quotation_details
create_vendor_quotations
creditnote_details
creditnotes
cssd_issue_items
cssd_issue_process_items
cssd_issue_processes
cssd_issues
cssd_item_storages
cssd_process_maps
cssd_process_masters
cssd_request_items
cssd_requests
cssd_schedule_details
cssd_schedule_transaction_items
cssd_schedule_transactions
cssd_schedules
cssd_set_items
cssd_sets
cssd_status_masters
cssd_sterile_methods
cssd_tech_masters
cssd_type_masters
cssd_user_process_maps
current_medications
currentmedications
dailyappointments
dailybedcensus
dailyregistrations
dailyserviceorders
dappointments
day_care_pre_bed_slots
day_care_pre_beds
dcupdates
death_permanent_adds
death_police_cases
death_present_adds
death_responsible_adds
deathpostings
deaths
debitnote_details
debitnotes
department_masters
designation_details
designations
devtests
diagnoses
diagnsspreferances
diet_assessment_details
diet_assessment_lab_details
diet_assessments
diet_schedulers
diet_ticket_details
diet_tickets
discharge_medicines
dischargesummaries
disposable_items
districts
doctor_masters
doctor_progress_forms
doctorcommision_details
doctorcommisions
doctorconsdetails
doctorconsultations
doctortypeforms
document_masters
documents
donors
drgroups
drug_administration_details
drug_administrations
drugissue_amounts
drugissue_batch_issues
drugissue_details
drugissuebalanceitems
drugissueitems
drugissueothers
drugissues
drugorder_details
drugorders
drugs
dvoucherdetails
employee_masters
employees
emr_allergynotes
emr_anticoagulantnotes
emr_dietplans
emr_extranotes
emr_fhnotes
emr_generalnotes
emr_ivdailynotes
emr_problems
emr_ptatgnotes
emrnotes
emrs
evaluation_masters
eye_operations
familyhistories
fbills
finalbill_bed_details
finalbill_details
finalbill_doc_details
finalbill_rev_details
finalbill_voucher_details
finalbills
fixedvalues
follicle_masters
followupreports
food_groups
food_item_masters
foreigners
forms
general_payment_receipts
generalnotes
generalnoticeboards
generics
grade_details
grade_masters
group_masters
grouporganismlink_details
grouporganismlinks
gynaecologies
gynaecology_instructions
homes
hourlyservices
ifirsts
indent_details
indents
input_output_tax_masters
insurance_details
insurance_masters
insurances
intake_details
intake_iv_masters
intake_masters
intakes
intrimbills
intubations
ip_bed_charge_postings
ipadmission_beds
ipadmission_numbers
ipadmissionlists
ipadmissions
ipbillheaders
ipd_bedcharges
ipd_house_keeping_remarks
ipd_nurse_note_diagnose_logs
ipd_nurse_note_diagnoses
ipd_nurse_note_dialysis_diet_logs
ipd_nurse_note_dialysis_diets
ipd_nurse_note_indwelling_logs
ipd_nurse_note_indwellings
ipd_nurse_note_logs
ipd_nurse_note_surgeries
ipd_nurse_note_surgery_logs
ipd_nurse_note_vital_sign_logs
ipd_nurse_note_vital_signs
ipd_nurse_notes
ipdtreatments
ipmanagements
ipservices
iseconds
issuebloodbanks
issueindent_details
issueindents
item_details
itembrands
itemdetails
itemforms
itemnames
items
itemtaxes
itemtypeforms
itemtypes
ithirds
ivf_care_instructions
ivf_cares
ivf_follicle_headers
ivf_follicle_options
ivf_follicles
job_types
jobsites
lab_machine_masters
lab_method_masters
labgroups
laboratories
labour_checklists
labour_safety_checklists
labreports
labs
labtests
labtypes
laundry_master_details
laundry_masters
laundry_receive_details
laundry_receives
laundry_washline_details
laundry_washlines
lenses
level_schedule_details
level_schedule_entries
level_schedules
level_section_mappings
level_sections
levels
linkservforms
locations
log_ivf_care_instructions
log_ivf_cares
logcalerrors
loundry_patient_request_details
loundry_patient_requests
loundry_rate_masters
loundry_receive_details
loundry_receives
loundry_schedule_details
loundry_schedules
lowerextremities
lservices
lumberspineevoluations
majerminer_masters
majors
manufacturers
map_vendor_details
map_vendors
master_anaesthesist_rates
master_captions
master_forms
master_instructions
master_resultformat_options
master_resultformats
master_voucher_details
master_voucher_types
master_vouchers
material_receipt_note_batch_details
material_receipt_note_details
material_receipt_notes
mbresulttryentries
mdpreferances
medicalhistories
medication_group_details
medication_groups
medicine_items
medicines
medicolegals
microbrentries
modules
monitorings
mpayment_details
mrdetails
mrsearches
msb_dependends
msbs
musculoskelevalutions
name_masters
nondisposable_items
nurse_progress_forms
nursemasters
nursenotes
obstetrical_histories
obstetrical_history_details
onlytest
opd_vital_signs
opds
opencounters
operation_anesthesias
operation_anesthesiastypes
operation_procs
operation_surgeons
operation_techinicians
operation_timings
operationdetails
operationmasters
operationnotes
operations
opiptestorders
opservices
opthal_masters
org_authorities
organization_details
organizations
orginisms
orthopfirstnotes
orthoponenotes
orthoprogressnotes
orthopthreenotes
orthoptwonotes
otbook_slots
otbooks
otexpenses
other_details
outpatient_numbers
outpatient_refers
outpatients
p_package_doc_details
p_package_docs
p_package_lab_details
p_package_labs
p_package_med_details
p_package_meds
p_package_other_details
p_package_others
p_package_proc_details
p_package_procs
p_package_radio_details
p_package_radios
p_package_regs
p_package_room_details
p_package_rooms
p_package_surg_details
p_package_surgs
pac_details
package_doctor_visits
package_group_masters
package_laboratories
package_medicines
package_other_charges
package_other_services
package_payment_details
package_radiologies
package_rooms
package_services
package_surgeries
package_transfers
package_voucher_details
package_voucher_headers
packages
pages
pappointments
partpayments
partpreports
patient_advances
patient_ot_schedules
patientaccounts
patientdetails
patientdischarges
patientintakes
patientreactions
patienttransfers
pay_out_cal_pays
pay_out_cals
pay_out_doctor_pay_outs
pay_out_ot_pay_outs
pay_out_radio_pay_outs
pay_out_service_pay_outs
pay_outs
payment_details
payment_numbers
payment_procedures
payment_receipt_details
payment_receipt_transactions
payment_terms
payment_transfers
paymentreversals
pediatric_histories
pediatric_instructions
pediatrics
pomaterial_receipt_note_batch_details
pomaterial_receipt_note_details
pomaterial_receipt_notes
posta
postanesthesias
postopcondition_inouts
postopconditions
posts
ppreports
pptestreports
pre_diseases
preanesthesias
prefixes
preflabtests
premedication_drugs
premedications
prenatal_or_antinatal_progresses
prenatal_progress_details
prenatal_progresses
preoperationorders
preoperative_checklists
preopnotes
prescriptions
prevanesthesias
prevhistories
prevmedications
problems
profiletestlink_details
profiletestlinks
proftests
ptactnotes
purch_account_ledgers
purch_categories
purch_tds_classification_detail_masters
purch_tds_classification_masters
purch_tds_deducti_types
purch_vendor_contact_people
purch_vendor_general_details
purch_vendor_taxation_details
purchase_order_details
purchase_orders
purchase_requisition_details
purchase_requisitions
radiology_schedules
radiologyresults
radiologytest_details
radiologytestpics
radiologytests
radreports
rates
reasons
refers
registration_numbers
registration_packages
registration_treatment_cost_n_estimations
registrations
regreports
regstatics
reports
requisition_details
requisitions
respaddresses
resulttryentries
resulttrytests
returntypes
reversal_numbers
reversaldetails
reversals
rolemaster_details
rolemasters
roles
rolestorelinks
rooms
ropresults
rosterdetails
rosterdetails_0910
rostermasters
rostermasters_0910
rpaneltests
rservices
salary_allowances
salary_deductions
salary_structures
samplecollections
samplectests
samples
sappointments
sequences
service_categories
services
settings
shifts
sitembrands
sitembrands_copy
sitemdetails
sitemdetails_copy
sitemheaders
sitemheaders_copy
slot_times
smajors
sorders
specilizations
srdetailreports
staff_fund_payouts
standardvalues
states
store_masters
storebatchdetails
storecounters
storeitems
strength_contents
sub_group_masters
subcodes
suppliermajors
suppliers
supplierstores
surgeonnotes
surgical_safety_checklists
surgicalhistories
symptoms
symptpreferances
tablename1
tax_master_services
tax_masters
tax_masters_original
test
testcsv
testorders
testpanels
testparameterlinks
testparameters
testreversals
tests
theater_schedules
theaterdetails
theaters
third_isolates
tpa_approval_details
tpa_approval_payments
tpa_approval_service_details
tpa_approvals
tpas
tpr_entries
transfusions
transporter_masters
treatment_clinical_findings
treatment_cost_n_estimation_surgeries
treatment_cost_n_estimations
treatment_diagnoses
treatment_final_diagnoses
treatment_medicine_others
treatment_medicines
treatment_symptoms
treatment_test_profiles
treatments
under_conditions
under_terms
unit_codes
uperextremities
user
user_locations
user_logs
user_payment_transfers
user_wise_queries
userlabtests
userrolls
userrolls_nurse_sttns
uwregistrations
va_auto_refs
va_auto_refs_masters
va_checkups
va_diluted_accepts
va_diluted_masters
va_diseases
va_doctor_heads
va_doctor_vision_heads
va_doctors
va_entries
va_entry_details
va_entry_masters
va_medicals
va_refraction_masters
va_refrection_details
va_refrections
va_retinoscopies
va_retinoscopy_masters
vaccine_masters
vaccine_schedule_chart_details
vaccine_schedule_charts
vaccine_schedule_descriptions
vaccine_times
vacutainers
vdetailreports
ventilator_logs
ventilators
vision_counter_masters
voucher_details
voucher_diets
voucher_discount_approval_details
voucher_discount_approvals
voucher_discounts
voucher_headers
voucher_sequences
voucherlists
voucherreversals
vprevreports
vrevreports
wards
wardtowardbatches
wardtowards
wardtowardstores
wdiagnosis
wings
z_log_acceptissue_details
z_log_addresses
z_log_assigncounters
z_log_batchdetails
z_log_bedcharge_details
z_log_bedcharges
z_log_beds
z_log_bedtransfers
z_log_birthdetails
z_log_categoryrates
z_log_closecounters
z_log_dischargesummaries
z_log_doctorconsdetails
z_log_doctorconsultations
z_log_drugissue_batch_issues
z_log_drugissue_details
z_log_finalbill_details
z_log_finalbills
z_log_ipadmissions
z_log_itemforms
z_log_mpayment_details
z_log_opservices
z_log_outpatients
z_log_package_doctor_visits
z_log_package_laboratories
z_log_package_medicines
z_log_package_other_charges
z_log_package_radiologies
z_log_package_rooms
z_log_package_surgeries
z_log_packages
z_log_partpayments
z_log_patientdischarges
z_log_payment_details
z_log_payment_receipt_details
z_log_payment_receipt_transactions
z_log_paymentreversals
z_log_registrations
z_log_storeitems
z_log_treatment_clinical_findings
z_log_treatment_cost_n_estimations
z_log_treatment_diagnoses
z_log_treatment_final_diagnoses
z_log_treatment_medicine_others
z_log_treatment_medicines
z_log_treatment_symptoms
z_log_treatment_test_profiles
z_log_treatments
选择字段。