ใครเคยเจอปัญหานี้ไหม

[มนตรี บอยรักยุ้ยคนเดียว]

System Message
SQL Error: Column 'hos_guid' cannot be null
select * from vn_stat where vn='531101090750'

หลังจากมีการบันทึกคนไข้

[เข้ม]

ผมไม่เคยเจอครับ อ. บอย
แต่ผมเป็นแบบนี้ครับ

ทดสอบการทำงานของ slave แล้วขึ้นข้อความแบบนี้หมายความว่าอย่างไรครับ

System Message
SQL Error: Duplicate entry '6015273' for key 'PRIMARY'
select * from ksklog where tablename='xxx' limit 1

มีใครเคยเจอมั๊ยครับ

[chk]

   ยังไม่เคยเจอขอรับ 

[bbb3]

ของผมตอนerrorไม่รู้ว่าขึ้นว่าอะไร...แต่ผลที่ได้เป็นดังภาพนะครับ...
หาสาเหตุไม่เจอ....

[kwh]

System Message
SQL Error: Duplicate entry '6015273' for key 'PRIMARY'
select * from ksklog where tablename='xxx' limit 1

ธรรมดาแล้ว table ของ Mysql จะจุได้สูงสุด 2G-4G แล้วแต่ OS  32 , 64 bit
แต่ข้อมูลท่านตอนนี้ 60 ล้านแล้ว น่าจะเกิน 2G แล้ว    ควรจะ  reset เริ่มนับใหม่ได้แล้วมั้งครับ

[manoi]

ลองแก้ไขโดยใช้คำสั่งนี้ดูครับ

alter table vn_stat modify column hos_guid varchar(38) null

[doramon]

ลองแก้ไขโดยใช้คำสั่งนี้ดูครับ

alter table vn_stat modify column hos_guid varchar(38) null

ขอบคุณครับ

[มนตรี บอยรักยุ้ยคนเดียว]

ลองแก้ไขโดยใช้คำสั่งนี้ดูครับ

alter table vn_stat modify column hos_guid varchar(38) null

ขอบคุณครับ

พอดีแก้พร้อมตาราง spclty

System Message
SQL Error: Duplicate entry '6015273' for key 'PRIMARY'
select * from ksklog where tablename='xxx' limit 1

ธรรมดาแล้ว table ของ Mysql จะจุได้สูงสุด 2G-4G แล้วแต่ OS  32 , 64 bit
แต่ข้อมูลท่านตอนนี้ 60 ล้านแล้ว น่าจะเกิน 2G แล้ว    ควรจะ  reset เริ่มนับใหม่ได้แล้วมั้งครับ

ตารางแบบนี้ผมตั้งไว้ 10G สำหรับ MyISAM
และ Innodb ก็ได้ถึง 20G ต่อ ตารางนะครับ

ผม backup เสร็จ
ก็ลบ ตาราง delete  from ที่เป็น_log

[เข้ม]

System Message
SQL Error: Duplicate entry '6015273' for key 'PRIMARY'
select * from ksklog where tablename='xxx' limit 1

ธรรมดาแล้ว table ของ Mysql จะจุได้สูงสุด 2G-4G แล้วแต่ OS  32 , 64 bit
แต่ข้อมูลท่านตอนนี้ 60 ล้านแล้ว น่าจะเกิน 2G แล้ว    ควรจะ  reset เริ่มนับใหม่ได้แล้วมั้งครับ

ตารางแบบนี้ผมตั้งไว้ 10G สำหรับ MyISAM
และ Innodb ก็ได้ถึง 20G ต่อ ตารางนะครับ

ผม backup เสร็จ
ก็ลบ ตาราง delete  from ที่เป็น_log

ไปกำหนดที่ variables ตัวไหนครับ
ใช่ myisam_max_sort_file_size หรือป่าวครับ

[smhos]

ผมเจอ
System Message
SQL Error: Duplicate entry '530002763' for key 'an_unique'
select * from labor where an = '530002763'

ไม่ทราบว่าแก้ไขยังไงคับ
ชี้แนะด้วยคับ ท่านอาจารย์ทั้งหลาย

[doramon]

agriculture_member_type.hos_guid varchar (38)
an_stat.hos_guid varchar (38)
bedno.hos_guid varchar (38)
clinic_cormobidity.hos_guid varchar (38)
clinic_cormobidity_list.hos_guid varchar (38)
clinic_member_status.hos_guid varchar (38)
clinic_persist_icd.hos_guid varchar (38)
clinic_subtype.hos_guid varchar (38)
clinic_visit.hos_guid varchar (38)
clinicmember.hos_guid varchar (38)
code506.hos_guid varchar (38)
dbchronic_nationality.hos_guid varchar (38)
dbchronic_occupation.hos_guid varchar (38)
dchstts.hos_guid char (38)
dchtype.hos_guid char (38)
death.hos_guid varchar (38)
dental_month_report.hos_guid varchar (38)
dental_report.hos_guid varchar (38)
diagtype.hos_guid varchar (38)
doctor_order_print.hos_guid varchar (38)
doctor_order_print_queue.hos_guid varchar (38)
dtmain_report.hos_guid varchar (38)
dw_refer_list.hos_guid varchar (38)
education.hos_guid varchar (38)
epi_vaccine.hos_guid varchar (38)
er_regist_oper.hos_guid varchar (38)
family.hos_guid varchar (38)
finger_scan.hos_guid varchar (38)
finger_template.hos_guid varchar (38)
hospital_executive_detail.hos_guid varchar (38)
hospital_observe_activity.hos_guid varchar (38)
hospital_observe_activity_class.hos_guid varchar (38)
hospital_observe_activity_member.hos_guid varchar (38)
hospital_person.hos_guid varchar (38)
hospital_profile.hos_guid varchar (38)
hospital_speciality.hos_guid varchar (38)
hospital_speciality_detail.hos_guid varchar (38)
hospital_volunteer.hos_guid varchar (38)
hospital_volunteer_excellent.hos_guid varchar (38)
hospital_volunteer_excellent_type.hos_guid varchar (38)
hospital_volunteer_expert.hos_guid varchar (38)
hospital_volunteer_expert_type.hos_guid varchar (38)
hospital_volunteer_observe_activity.hos_guid varchar (38)
hospital_volunteer_observe_activity_class.hos_guid varchar (38)
hospital_volunteer_observe_member.hos_guid varchar (38)
house.hos_guid varchar (38)
house_animal.hos_guid varchar (38)
house_animal_type.hos_guid varchar (38)
house_container.hos_guid varchar (38)
house_container_type.hos_guid varchar (38)
house_deed.hos_guid varchar (38)
house_deed_survey.hos_guid varchar (38)
house_drink_water.hos_guid varchar (38)
house_drink_water_survey.hos_guid varchar (38)
house_herb.hos_guid varchar (38)
house_herb_type.hos_guid varchar (38)
house_image.hos_guid varchar (38)
house_invest.hos_guid varchar (38)
house_invest_survey.hos_guid varchar (38)
house_location_area.hos_guid varchar (38)
house_mosquitoes_advice.hos_guid varchar (38)
house_mosquitoes_prevent.hos_guid varchar (38)
house_mosquitoes_survey.hos_guid varchar (38)
house_owner.hos_guid varchar (38)
house_owner_survey.hos_guid varchar (38)
house_plant.hos_guid varchar (38)
house_plant_survey.hos_guid varchar (38)
house_plant_water.hos_guid varchar (38)
house_plant_water_survey.hos_guid varchar (38)
house_regist_type.hos_guid varchar (38)
house_supply_water.hos_guid varchar (38)
house_supply_water_sufficient.hos_guid varchar (38)
house_supply_water_sufficient_survey.hos_guid varchar (38)
house_supply_water_survey.hos_guid varchar (38)
house_survey.hos_guid varchar (38)
house_survey_detail.hos_guid varchar (38)
house_survey_garbage.hos_guid varchar (38)
house_survey_health.hos_guid varchar (38)
house_survey_item.hos_guid varchar (38)
house_survey_summary.hos_guid varchar (38)
house_survey_toilet.hos_guid varchar (38)
house_survey_water.hos_guid varchar (38)
house_survey_yesno.hos_guid varchar (38)
house_type.hos_guid varchar (38)
immigration_checkup.hos_guid varchar (38)
immigration_checkup_result.hos_guid varchar (38)
incoth.hos_guid varchar (38)
ipd_presc_machine.hos_guid varchar (38)
ipt_admit_stat.hos_guid char (38)
ipt_finance_opi.hos_guid varchar (38)
ipt_labour_infant.hos_guid varchar (38)
ipt_medication_type.hos_guid char (38)
ipt_newborn.hos_guid varchar (38)
ipt_nurse_oper.hos_guid varchar (38)
ipt_order_no.hos_guid char (38)
ipt_order_type.hos_guid char (38)
ipt_pregnancy.hos_guid varchar (38)
ipt_pttype.hos_guid char (38)
ipt_type.hos_guid char (38)
ipt_ward_stat.hos_guid char (38)
iptadm.hos_guid varchar (38)
iptdiag.hos_guid varchar (38)
iptoprt.hos_guid varchar (38)
kskdepartment.hos_guid varchar (38)
lab_department.hos_guid char (38)
lab_form.hos_guid char (38)
lab_form_head.hos_guid char (38)
lab_head.hos_guid varchar (38)
lab_items.hos_guid varchar (38)
lab_items_doctor.hos_guid char (38)
lab_items_group.hos_guid char (38)
lab_items_normal_list.hos_guid char (38)
lab_items_specimen.hos_guid char (38)
lab_items_sub_group.hos_guid char (38)
lab_items_sub_group_list.hos_guid char (38)
lab_opitemrece.hos_guid varchar (38)
lab_order.hos_guid varchar (38)
lab_order_print.hos_guid varchar (38)
lab_perform_status.hos_guid char (38)
lab_priority.hos_guid char (38)
lab_room.hos_guid char (38)
lab_specimen.hos_guid char (38)
lab_specimen_items.hos_guid char (38)
lab_status.hos_guid char (38)
labor_ba.hos_guid char (38)
labor_drug.hos_guid char (38)
labor_place.hos_guid char (38)
labor_status.hos_guid char (38)
labour_amniotic_type.hos_guid char (38)
labour_complication.hos_guid char (38)
labour_deliver_abnormal_type.hos_guid char (38)
labour_delivery_type.hos_guid char (38)
labour_lab.hos_guid char (38)
labour_membrane_type.hos_guid char (38)
labour_perineum_type.hos_guid char (38)
labour_place.hos_guid char (38)
labour_placenta_desc.hos_guid char (38)
labour_placenta_type.hos_guid char (38)
labour_position.hos_guid char (38)
labour_pregnancy_nst.hos_guid char (38)
labour_pregnancy_position.hos_guid char (38)
labour_sac_type.hos_guid char (38)
labour_stage.hos_guid char (38)
labour_sulture_type.hos_guid char (38)
marrystatus.hos_guid varchar (38)
medpay_ipd.hos_guid varchar (38)
medplan_ipd.hos_guid char (38)
moo_home.hos_guid varchar (38)
name506.hos_guid varchar (38)
nationality.hos_guid varchar (38)
ncd_history_type.hos_guid varchar (38)
occupation.hos_guid varchar (38)
opd_allergy.hos_guid varchar (38)
opd_hn_change.hos_guid varchar (38)
opd_ipd_transfer.hos_guid varchar (38)
opd_presc_machine.hos_guid varchar (38)
opdscreen.hos_guid varchar (38)
opdscreen_revisit.hos_guid varchar (38)
opduser.hos_guid varchar (38)
operation_agent.hos_guid varchar (38)
operation_airway_problem.hos_guid varchar (38)
operation_airway_solution.hos_guid varchar (38)
operation_anes.hos_guid varchar (38)
operation_anes_asa.hos_guid varchar (38)
operation_anes_detail.hos_guid varchar (38)
operation_anes_invent.hos_guid varchar (38)
operation_anes_monitor.hos_guid varchar (38)
operation_anes_oper.hos_guid varchar (38)
operation_anes_oper_list.hos_guid varchar (38)
operation_anes_physical_status.hos_guid varchar (38)
operation_anes_problem.hos_guid varchar (38)
operation_anes_technique.hos_guid varchar (38)
operation_anes_type.hos_guid varchar (38)
operation_blood.hos_guid varchar (38)
operation_cancel.hos_guid varchar (38)
operation_cancel_type.hos_guid varchar (38)
operation_complication.hos_guid varchar (38)
operation_complication_type.hos_guid varchar (38)
operation_consciousness.hos_guid varchar (38)
operation_detail.hos_guid varchar (38)
operation_detail_position.hos_guid varchar (38)
operation_disease.hos_guid varchar (38)
operation_disease_list.hos_guid varchar (38)
operation_emergency.hos_guid varchar (38)
operation_group.hos_guid varchar (38)
operation_holidays.hos_guid varchar (38)
operation_image.hos_guid varchar (38)
operation_intra_complication.hos_guid varchar (38)
operation_invent.hos_guid varchar (38)
operation_item.hos_guid varchar (38)
operation_item_type.hos_guid varchar (38)
operation_list.hos_guid varchar (38)
operation_patient_position.hos_guid varchar (38)
operation_position.hos_guid varchar (38)
operation_premed.hos_guid varchar (38)
operation_preop_problem.hos_guid varchar (38)
operation_recovery_dch.hos_guid varchar (38)
operation_recovery_room.hos_guid varchar (38)
operation_recovery_room_problem.hos_guid varchar (38)
operation_recovery_status.hos_guid varchar (38)
operation_respiration.hos_guid varchar (38)
operation_room.hos_guid varchar (38)
operation_scan.hos_guid varchar (38)
operation_scan_image.hos_guid varchar (38)
operation_schedule.hos_guid varchar (38)
operation_schedule_resource.hos_guid varchar (38)
operation_screen_in.hos_guid varchar (38)
operation_specimen.hos_guid varchar (38)
operation_specimen_type.hos_guid varchar (38)
operation_status.hos_guid varchar (38)
operation_stock.hos_guid varchar (38)
operation_team.hos_guid varchar (38)
operation_time_type.hos_guid varchar (38)
operation_type.hos_guid varchar (38)
operation_wound.hos_guid varchar (38)
opi_acpc.hos_guid char (38)
opi_dispense.hos_guid varchar (38)
opi_dose_usage_unit.hos_guid char (38)
opi_frequency_code.hos_guid char (38)
opi_time_code.hos_guid char (38)
opi_usage_code.hos_guid char (38)
opi_usage_unit_code.hos_guid char (38)
opitemrece.hos_guid varchar (38)
opitemrece_arc.hos_guid varchar (38)
opitemrece_bak.hos_guid varchar (38)
opitemrece_charge.hos_guid varchar (38)
opitemrece_delta.hos_guid varchar (38)
opitemrece_finance_delete.hos_guid varchar (38)
opitemrece_idr.hos_guid varchar (38)
opitemrece_medplan.hos_guid varchar (38)
opitemrece_sticker_log.hos_guid varchar (38)
opitemrece_sticker_stat.hos_guid varchar (38)
opitemrece_summary.hos_guid varchar (38)
opitemrece_trx.hos_guid varchar (38)
ovst.hos_guid varchar (38)
ovst_seq.hos_guid varchar (38)
ovstdiag.hos_guid varchar (38)
ovstist.hos_guid varchar (38)
ovstost.hos_guid varchar (38)
patient.hos_guid varchar (38)
patient_allergy_pcu_screen.hos_guid varchar (38)
patient_image.hos_guid varchar (38)
pcu_dw_track.hos_guid varchar (38)
pcu_home.hos_guid varchar (38)
person.hos_guid varchar (38)
person_anc.hos_guid varchar (38)
person_anc_lab.hos_guid varchar (38)
person_anc_labor_detail.hos_guid varchar (38)
person_anc_preg_care.hos_guid varchar (38)
person_anc_risk.hos_guid varchar (38)
person_anc_screen.hos_guid varchar (38)
person_anc_service.hos_guid varchar (38)
person_anc_service_detail.hos_guid varchar (38)
person_behavior.hos_guid varchar (38)
person_behavior_list.hos_guid varchar (38)
person_behavior_value_list.hos_guid varchar (38)
person_bf_survey.hos_guid varchar (38)
person_bf_survey_list.hos_guid varchar (38)
person_bw_survey.hos_guid varchar (38)
person_bw_survey_list.hos_guid varchar (38)
person_card_request.hos_guid varchar (38)
person_chronic.hos_guid varchar (38)
person_chronic_visit.hos_guid varchar (38)
person_death.hos_guid varchar (38)
person_deformed.hos_guid varchar (38)
person_deformed_detail.hos_guid varchar (38)
person_deformed_money_aid_type.hos_guid varchar (38)
person_deformed_need_aid.hos_guid varchar (38)
person_deformed_need_aid_type.hos_guid varchar (38)
person_deformed_no_regist_type.hos_guid varchar (38)
person_deformed_refer_type.hos_guid varchar (38)
person_deformed_type.hos_guid varchar (38)
person_development_list.hos_guid varchar (38)
person_dm_fgc_screen.hos_guid varchar (38)
person_dm_fpg_screen.hos_guid varchar (38)
person_dm_risk_screen.hos_guid varchar (38)
person_dm_risk_screen_detail.hos_guid varchar (38)
person_dm_screen_status.hos_guid varchar (38)
person_dmht_cormobidity.hos_guid varchar (38)
person_dmht_cormobidity_screen_detail.hos_guid varchar (38)
person_dmht_risk_screen_head.hos_guid varchar (38)
person_dmht_screen_summary.hos_guid varchar (38)
person_duty.hos_guid varchar (38)
person_elder_activity.hos_guid varchar (38)
person_elder_activity_type.hos_guid varchar (38)
person_elder_club.hos_guid varchar (38)
person_elder_club_member.hos_guid varchar (38)
person_elder_club_type.hos_guid varchar (38)
person_epi.hos_guid varchar (38)
person_epi_nutrition.hos_guid varchar (38)
person_epi_place.hos_guid varchar (38)
person_epi_vaccine.hos_guid varchar (38)
person_epi_vaccine_list.hos_guid varchar (38)
person_finger_scan.hos_guid varchar (38)
person_finger_template.hos_guid varchar (38)
person_health_club.hos_guid varchar (38)
person_health_club_bmi.hos_guid varchar (38)
person_health_club_bmi_summary.hos_guid varchar (38)
person_health_club_member.hos_guid varchar (38)
person_house_history.hos_guid varchar (38)
person_house_position.hos_guid varchar (38)
person_ht011.hos_guid varchar (38)
person_image.hos_guid varchar (38)
person_image_other.hos_guid varchar (38)
person_labour.hos_guid varchar (38)
person_labour_doctor_type.hos_guid varchar (38)
person_labour_place.hos_guid varchar (38)
person_labour_type.hos_guid varchar (38)
person_parent.hos_guid varchar (38)
person_screen_head.hos_guid varchar (38)
person_screen_result.hos_guid varchar (38)
person_senile.hos_guid varchar (38)
person_senile_club_type.hos_guid varchar (38)
person_senile_helper_type.hos_guid varchar (38)
person_senile_money_aid_type.hos_guid varchar (38)
person_senile_self_type.hos_guid varchar (38)
person_thyroid_result.hos_guid varchar (38)
person_vaccine.hos_guid varchar (38)
person_vaccine_list.hos_guid varchar (38)
person_village_duty.hos_guid varchar (38)
person_visit.hos_guid varchar (38)
person_wbc.hos_guid varchar (38)
person_wbc_post_care.hos_guid varchar (38)
person_wbc_post_care_screen.hos_guid varchar (38)
person_wbc_service.hos_guid varchar (38)
person_wbc_service_detail.hos_guid varchar (38)
person_wbc_service_summary.hos_guid varchar (38)
person_wbc_vaccine_detail.hos_guid varchar (38)
person_women.hos_guid varchar (38)
person_women_breast_cancer_check.hos_guid varchar (38)
person_women_breast_cancer_test.hos_guid varchar (38)
person_women_service.hos_guid varchar (38)
person_women_vaccine_list.hos_guid varchar (38)
person_women_vagina_cancer_test.hos_guid varchar (38)
physic_list.hos_guid varchar (38)
physic_list_ipd.hos_guid varchar (38)
physic_main_ipd.hos_guid varchar (38)
provis_anc.hos_guid varchar (38)
provis_appoint.hos_guid varchar (38)
provis_card.hos_guid varchar (38)
provis_chronic.hos_guid varchar (38)
provis_death.hos_guid varchar (38)
provis_diag.hos_guid varchar (38)
provis_drug.hos_guid varchar (38)
provis_epi.hos_guid varchar (38)
provis_fp.hos_guid varchar (38)
provis_home.hos_guid varchar (38)
provis_mch.hos_guid varchar (38)
provis_nutri.hos_guid varchar (38)
provis_person.hos_guid varchar (38)
provis_pp.hos_guid varchar (38)
provis_proced.hos_guid varchar (38)
provis_service.hos_guid varchar (38)
provis_surveil.hos_guid varchar (38)
provis_women.hos_guid varchar (38)
pt_subtype.hos_guid varchar (38)
ptcardno.hos_guid varchar (38)
referin.hos_guid varchar (38)
referout.hos_guid varchar (38)
religion.hos_guid varchar (38)
roomno.hos_guid varchar (38)
row_number_counter.hos_guid varchar (38)
service_time.hos_guid varchar (38)
sex.hos_guid varchar (38)
stock_adjust_detail.hos_guid varchar (38)
stock_adjust_head.hos_guid varchar (38)
stock_adjust_item.hos_guid varchar (38)
stock_bdg_year.hos_guid varchar (38)
stock_borrow.hos_guid varchar (38)
stock_borrow_item.hos_guid varchar (38)
stock_budget.hos_guid varchar (38)
stock_card.hos_guid varchar (38)
stock_class.hos_guid varchar (38)
stock_cutpay.hos_guid varchar (38)
stock_cutpay_item.hos_guid varchar (38)
stock_cutpay_list.hos_guid varchar (38)
stock_deliver.hos_guid varchar (38)
stock_deliver_detail.hos_guid varchar (38)
stock_department.hos_guid varchar (38)
stock_department_item.hos_guid varchar (38)
stock_department_item_level.hos_guid varchar (38)
stock_department_route.hos_guid varchar (38)
stock_draw.hos_guid varchar (38)
stock_draw_item.hos_guid varchar (38)
stock_draw_list.hos_guid varchar (38)
stock_drug_item.hos_guid varchar (38)
stock_expire.hos_guid varchar (38)
stock_group_standard.hos_guid varchar (38)
stock_item.hos_guid varchar (38)
stock_item_cost_type.hos_guid varchar (38)
stock_item_drugitems.hos_guid varchar (38)
stock_item_history.hos_guid varchar (38)
stock_item_list.hos_guid varchar (38)
stock_item_regist.hos_guid varchar (38)
stock_item_standard.hos_guid varchar (38)
stock_item_type.hos_guid varchar (38)
stock_item_unit.hos_guid varchar (38)
stock_item_warehouse.hos_guid varchar (38)
stock_manual_detail.hos_guid varchar (38)
stock_manual_head.hos_guid varchar (38)
stock_manual_item.hos_guid varchar (38)
stock_opitemrece.hos_guid varchar (38)
stock_opitemrece_err.hos_guid varchar (38)
stock_opitemrece_list.hos_guid varchar (38)
stock_ovst.hos_guid varchar (38)
stock_paid_status.hos_guid varchar (38)
stock_plan.hos_guid varchar (38)
stock_plan_list.hos_guid varchar (38)
stock_po.hos_guid varchar (38)
stock_po_detail.hos_guid varchar (38)
stock_po_item_type.hos_guid varchar (38)
stock_po_type.hos_guid varchar (38)
stock_proviso.hos_guid varchar (38)
stock_proviso_item.hos_guid varchar (38)
stock_purchase_type.hos_guid varchar (38)
stock_remain_summary.hos_guid varchar (38)
stock_request.hos_guid varchar (38)
stock_request_list.hos_guid varchar (38)
stock_return.hos_guid varchar (38)
stock_return_cutpay.hos_guid varchar (38)
stock_return_cutpay_list.hos_guid varchar (38)
stock_return_item.hos_guid varchar (38)
stock_return_list.hos_guid varchar (38)
stock_return_stock.hos_guid varchar (38)
stock_return_stock_item.hos_guid varchar (38)
stock_right.hos_guid varchar (38)
stock_snapshot_detail.hos_guid varchar (38)
stock_snapshot_head.hos_guid varchar (38)
stock_subdraw.hos_guid varchar (38)
stock_subdraw_list.hos_guid varchar (38)
stock_subdraw_type.hos_guid varchar (38)
stock_supplier.hos_guid varchar (38)
stock_supplier_agent.hos_guid varchar (38)
stock_supplier_item.hos_guid varchar (38)
stock_user.hos_guid varchar (38)
stock_user_department.hos_guid varchar (38)
stock_user_right.hos_guid varchar (38)
stock_user_warehouse.hos_guid varchar (38)
stock_warehouse.hos_guid varchar (38)
stock_warehouse_adj_detail.hos_guid varchar (38)
stock_warehouse_adj_head.hos_guid varchar (38)
stockconfig.hos_guid varchar (38)
student_anemia_check.hos_guid varchar (38)
student_anemia_check_list.hos_guid varchar (38)
student_dental_check.hos_guid varchar (38)
student_dental_check_list.hos_guid varchar (38)
student_ear_check.hos_guid varchar (38)
student_ear_check_list.hos_guid varchar (38)
student_eye_check.hos_guid varchar (38)
student_eye_check_list.hos_guid varchar (38)
student_lice_check.hos_guid varchar (38)
student_lice_check_list.hos_guid varchar (38)
student_regulation_check.hos_guid varchar (38)
student_regulation_period_report.hos_guid varchar (38)
student_regulation_period_report_summary.hos_guid varchar (38)
student_self_check.hos_guid varchar (38)
student_self_check_list.hos_guid varchar (38)
student_thalassemia_check.hos_guid varchar (38)
student_thalassemia_check_list.hos_guid varchar (38)
student_vaccine.hos_guid varchar (38)
student_vaccine_place.hos_guid varchar (38)
universal_detail.hos_guid varchar (38)
universal_detail_subvalue.hos_guid varchar (38)
universal_form.hos_guid varchar (38)
universal_form_department.hos_guid varchar (38)
universal_form_design.hos_guid varchar (38)
universal_form_type.hos_guid varchar (38)
universal_head.hos_guid varchar (38)
universal_item.hos_guid varchar (38)
universal_item_class.hos_guid varchar (38)
universal_item_value_list.hos_guid varchar (38)
village.hos_guid varchar (38)
village_agri_group_type.hos_guid varchar (38)
village_agri_surveillance.hos_guid varchar (38)
village_agri_surveillance_member.hos_guid varchar (38)
village_basis_doctor.hos_guid varchar (38)
village_basis_health_center.hos_guid varchar (38)
village_club.hos_guid varchar (38)
village_club_member.hos_guid varchar (38)
village_drug_store.hos_guid varchar (38)
village_drug_store_picture.hos_guid varchar (38)
village_drug_store_type.hos_guid varchar (38)
village_map_point.hos_guid varchar (38)
village_market_survey.hos_guid varchar (38)
village_market_type.hos_guid varchar (38)
village_news_tower.hos_guid varchar (38)
village_organization.hos_guid varchar (38)
village_organization_member.hos_guid varchar (38)
village_organization_member_service.hos_guid varchar (38)
village_organization_type.hos_guid varchar (38)
village_priest.hos_guid varchar (38)
village_priest_type.hos_guid varchar (38)
village_radio_tower.hos_guid varchar (38)
village_school.hos_guid varchar (38)
village_school_class.hos_guid varchar (38)
village_school_room.hos_guid varchar (38)
village_school_shift.hos_guid varchar (38)
village_school_type.hos_guid varchar (38)
village_store.hos_guid varchar (38)
village_store_cfgt_evaluate.hos_guid varchar (38)
village_store_food_sample.hos_guid varchar (38)
village_store_location_type.hos_guid varchar (38)
village_store_summary.hos_guid varchar (38)
village_store_training.hos_guid varchar (38)
village_store_training_course.hos_guid varchar (38)
village_store_type.hos_guid varchar (38)
village_student.hos_guid varchar (38)
village_student_screen.hos_guid varchar (38)
village_student_vaccine.hos_guid varchar (38)
village_student_vaccine_list.hos_guid varchar (38)
village_survey_detail.hos_guid varchar (38)
village_temple.hos_guid varchar (38)
village_temple_type.hos_guid varchar (38)
village_toilet_survey.hos_guid varchar (38)
village_toilet_survey_image.hos_guid varchar (38)
village_toilet_type.hos_guid varchar (38)
village_water.hos_guid varchar (38)
visit_pttype.hos_guid char (38)
vn_stat.hos_guid varchar (38)
ward.hos_guid varchar (38)
wbc_development_assess.hos_guid varchar (38)
wbc_transfer.hos_guid varchar (38)
wbc_vaccine.hos_guid varchar (38)
women_birth_control.hos_guid varchar (38)
xray_appointment.hos_guid varchar (38)
xray_class_rent.hos_guid varchar (38)
xray_class_xn.hos_guid varchar (38)
xray_contrast_media.hos_guid varchar (38)
xray_contrast_media_use.hos_guid varchar (38)
xray_damage.hos_guid varchar (38)
xray_film.hos_guid varchar (38)
xray_film_staff.hos_guid varchar (38)
xray_head.hos_guid varchar (38)
xray_image.hos_guid varchar (38)
xray_items.hos_guid varchar (38)
xray_items_doctor.hos_guid varchar (38)
xray_items_film.hos_guid varchar (38)
xray_items_group.hos_guid varchar (38)
xray_keeper.hos_guid varchar (38)
xray_order.hos_guid varchar (38)
xray_pack.hos_guid varchar (38)
xray_priority.hos_guid varchar (38)
xray_pt_status.hos_guid varchar (38)
xray_rent.hos_guid varchar (38)
xray_rent_department.hos_guid varchar (38)
xray_rent_status.hos_guid varchar (38)
xray_rent_type.hos_guid varchar (38)
xray_report.hos_guid varchar (38)
xray_report_film.hos_guid varchar (38)
xray_report_type.hos_guid varchar (38)
xray_room.hos_guid varchar (38)
xray_service_charge.hos_guid varchar (38)
xray_side.hos_guid varchar (38)
xray_status.hos_guid varchar (38)
xray_template.hos_guid varchar (38)
xray_time_type.hos_guid varchar (38)
xray_type.hos_guid varchar (38)
xray_type_film.hos_guid varchar (38)
xrayexam.hos_guid varchar (38)
xrayxn.hos_guid varchar (38)

[เข้ม]

อ.อ๊อด กำลังจะเล่าอะไรให้ฟังหรือครับ ...

[มดตานอย ครับ..]

เป็น ปริศนา ธรรมหรือปล่า   

[Khuad]

... ต่อไปเราใช้ hos_guid เชื่อมโยงกันได้ทุกตาราง ...    ....

[เกื้อกูล ครับ..]

... ต่อไปเราใช้ hos_guid เชื่อมโยงกันได้ทุกตาราง ...    ....

โอ..พระเจ้า..get แล้ว...

[SIWIT]

System Message
SQL Error: Column 'hos_guid' cannot be null
select * from vn_stat where vn='531101090750'

หลังจากมีการบันทึกคนไข้

ผมเพิ่งเจอครับเกิดจากอะไรหรอครับ