ประมาณนี้อ่ะครับพี่โก้
update allergy_confirm set staff = 'xxx' where staff = 'zzz';
update ar_detail set staff = 'xxx' where staff = 'zzz';
update blood_pay_detail set staff = 'xxx' where staff = 'zzz';
update clinic_cormobidity_list set staff = 'xxx' where staff = 'zzz';
update custom_pttype set staff = 'xxx' where staff = 'zzz';
update depression_screen set staff = 'xxx' where staff = 'zzz';
update doctor_cert set staff = 'xxx' where staff = 'zzz';
update doctor_consult set staff = 'xxx' where staff = 'zzz';
update doctor_fee_list set staff = 'xxx' where staff = 'zzz';
update doctor_order_print set staff = 'xxx' where staff = 'zzz';
update doctor_order_print_head set staff = 'xxx' where staff = 'zzz';
update doctor_order_print_head_queue set staff = 'xxx' where staff = 'zzz';
update doctor_order_print_queue set staff = 'xxx' where staff = 'zzz';
update doctor_schedule set staff = 'xxx' where staff = 'zzz';
update drug_counseling_list set staff = 'xxx' where staff = 'zzz';
update drug_due_list set staff = 'xxx' where staff = 'zzz';
update drugeval set staff = 'xxx' where staff = 'zzz';
update drugstore_detail set staff = 'xxx' where staff = 'zzz';
update drugstore_head set staff = 'xxx' where staff = 'zzz';
update ds_opdscreen_drink set staff = 'xxx' where staff = 'zzz';
update dt_ipd_list set staff = 'xxx' where staff = 'zzz';
update dtmain set staff = 'xxx' where staff = 'zzz';
update dw_emr_log set staff = 'xxx' where staff = 'zzz';
update edoc_revolve_list set staff = 'xxx' where staff = 'zzz';
update edoc_user_list set staff = 'xxx' where staff = 'zzz';
update enoc_member set staff = 'xxx' where staff = 'zzz';
update enoc_member_dw set staff = 'xxx' where staff = 'zzz';
update eye_screen set staff = 'xxx' where staff = 'zzz';
update finance_deposit set staff = 'xxx' where staff = 'zzz';
update finance_ticket_visit set staff = 'xxx' where staff = 'zzz';
update health_med_queue set staff = 'xxx' where staff = 'zzz';
update hipdata_service_ds set staff = 'xxx' where staff = 'zzz';
update his_ovst set staff = 'xxx' where staff = 'zzz';
update incoth_summary_head set staff = 'xxx' where staff = 'zzz';
update ipd_df set staff = 'xxx' where staff = 'zzz';
update ipd_nurse_note set staff = 'xxx' where staff = 'zzz';
update ipt set staff = 'xxx' where staff = 'zzz';
update ipt_admit_queue set staff = 'xxx' where staff = 'zzz';
update ipt_chart_location_log set staff = 'xxx' where staff = 'zzz';
update ipt_diagnosis_log set staff = 'xxx' where staff = 'zzz';
update ipt_pttype set staff = 'xxx' where staff = 'zzz';
update ipt_vital_sign set staff = 'xxx' where staff = 'zzz';
update ipt_vital_sign_history set staff = 'xxx' where staff = 'zzz';
update iptdiag set staff = 'xxx' where staff = 'zzz';
update kpi_detail set staff = 'xxx' where staff = 'zzz';
update kpi_save set staff = 'xxx' where staff = 'zzz';
update lab_access_log set staff = 'xxx' where staff = 'zzz';
update lab_app_order set staff = 'xxx' where staff = 'zzz';
update lab_entry_log set staff = 'xxx' where staff = 'zzz';
update lab_order set staff = 'xxx' where staff = 'zzz';
update lab_order_print set staff = 'xxx' where staff = 'zzz';
update medication_reconciliation set staff = 'xxx' where staff = 'zzz';
update money_mamber set staff = 'xxx' where staff = 'zzz';
update nurse_confirm_rx set staff = 'xxx' where staff = 'zzz';
update oapp_cancel set staff = 'xxx' where staff = 'zzz';
update oapp_pending_log set staff = 'xxx' where staff = 'zzz';
update opd_hn_change set staff = 'xxx' where staff = 'zzz';
update opd_order_no set staff = 'xxx' where staff = 'zzz';
update opd_regist_sendlist set staff = 'xxx' where staff = 'zzz';
update opdcard_location set staff = 'xxx' where staff = 'zzz';
update opdcard_not_found set staff = 'xxx' where staff = 'zzz';
update opdcard_print_log set staff = 'xxx' where staff = 'zzz';
update opdscreen_bp set staff = 'xxx' where staff = 'zzz';
update opdscreen_cc_history set staff = 'xxx' where staff = 'zzz';
update opdscreen_pregnancy set staff = 'xxx' where staff = 'zzz';
update operation_anes_problem set staff = 'xxx' where staff = 'zzz';
update operation_cancel set staff = 'xxx' where staff = 'zzz';
update operation_list set staff = 'xxx' where staff = 'zzz';
update operation_postpone set staff = 'xxx' where staff = 'zzz';
update operation_schedule set staff = 'xxx' where staff = 'zzz';
update opitemrece set staff = 'xxx' where staff = 'zzz';
update opitemrece_arc set staff = 'xxx' where staff = 'zzz';
update opitemrece_bak set staff = 'xxx' where staff = 'zzz';
update opitemrece_delete_log set staff = 'xxx' where staff = 'zzz';
update opitemrece_delta set staff = 'xxx' where staff = 'zzz';
update opitemrece_finance_delete set staff = 'xxx' where staff = 'zzz';
update opitemrece_finance_log set staff = 'xxx' where staff = 'zzz';
update opitemrece_ipd set staff = 'xxx' where staff = 'zzz';
update opitemrece_log set staff = 'xxx' where staff = 'zzz';
update opitemrece_trx set staff = 'xxx' where staff = 'zzz';
update ovst set staff = 'xxx' where staff = 'zzz';
update ovst_department set staff = 'xxx' where staff = 'zzz';
update ovst_sks_confirm set staff = 'xxx' where staff = 'zzz';
update ovst_vaccine set staff = 'xxx' where staff = 'zzz';
update ovstdiag set staff = 'xxx' where staff = 'zzz';
update patient_allergy_pcu_screen set staff = 'xxx' where staff = 'zzz';
update patient_emr_log set staff = 'xxx' where staff = 'zzz';
update patient_file set staff = 'xxx' where staff = 'zzz';
update patient_foreignworker set staff = 'xxx' where staff = 'zzz';
update patient_hospital_refer set staff = 'xxx' where staff = 'zzz';
update patient_ipd_scan set staff = 'xxx' where staff = 'zzz';
update patient_log set staff = 'xxx' where staff = 'zzz';
update patient_nc set staff = 'xxx' where staff = 'zzz';
update patient_opd_scan set staff = 'xxx' where staff = 'zzz';
update patient_realname set staff = 'xxx' where staff = 'zzz';
update patient_special_prop set staff = 'xxx' where staff = 'zzz';
update patient_vaccine set staff = 'xxx' where staff = 'zzz';
update pcu_reporttemplate set staff = 'xxx' where staff = 'zzz';
update person_dmht_risk_screen_head set staff = 'xxx' where staff = 'zzz';
update person_ht011 set staff = 'xxx' where staff = 'zzz';
update person_ipd_home set staff = 'xxx' where staff = 'zzz';
update person_screen_form set staff = 'xxx' where staff = 'zzz';
update person_screen_head set staff = 'xxx' where staff = 'zzz';
update pq_doctor set staff = 'xxx' where staff = 'zzz';
update pq_ipd_rxorder set staff = 'xxx' where staff = 'zzz';
update pq_ipdorder set staff = 'xxx' where staff = 'zzz';
update pq_opdcard set staff = 'xxx' where staff = 'zzz';
update pq_opdcard_tag set staff = 'xxx' where staff = 'zzz';
update pq_rxorder set staff = 'xxx' where staff = 'zzz';
update pq_screen set staff = 'xxx' where staff = 'zzz';
update pt_consult set staff = 'xxx' where staff = 'zzz';
update pt_medication_history set staff = 'xxx' where staff = 'zzz';
update ptdepart set staff = 'xxx' where staff = 'zzz';
update pttype_log set staff = 'xxx' where staff = 'zzz';
update rcpt_arrear set staff = 'xxx' where staff = 'zzz';
update rcpt_credit set staff = 'xxx' where staff = 'zzz';
update rcpt_current set staff = 'xxx' where staff = 'zzz';
update rcpt_debt set staff = 'xxx' where staff = 'zzz';
update rcpt_debt_cancel set staff = 'xxx' where staff = 'zzz';
update rcpt_debt_finance set staff = 'xxx' where staff = 'zzz';
update referin set staff = 'xxx' where staff = 'zzz';
update reporttemplate_history set staff = 'xxx' where staff = 'zzz';
update rx_pay_template set staff = 'xxx' where staff = 'zzz';
update screen_doctor set staff = 'xxx' where staff = 'zzz';
update service_time set staff = 'xxx' where staff = 'zzz';
update social_aid set staff = 'xxx' where staff = 'zzz';
update stock_adjust_head set staff = 'xxx' where staff = 'zzz';
update stock_check_warehouse_head set staff = 'xxx' where staff = 'zzz';
update stock_manual_head set staff = 'xxx' where staff = 'zzz';
update stock_ovst set staff = 'xxx' where staff = 'zzz';
update stock_warehouse_adj_head set staff = 'xxx' where staff = 'zzz';
update surveil_member set staff = 'xxx' where staff = 'zzz';
update surveil_member_507 set staff = 'xxx' where staff = 'zzz';
update surveil_member_dw set staff = 'xxx' where staff = 'zzz';
update universal_form set staff = 'xxx' where staff = 'zzz';
update universal_head set staff = 'xxx' where staff = 'zzz';
update village_school_shift set staff = 'xxx' where staff = 'zzz';
update visit_plan set staff = 'xxx' where staff = 'zzz';
update visit_pttype set staff = 'xxx' where staff = 'zzz';
update visit_pttype_change set staff = 'xxx' where staff = 'zzz';
update vital_sign_data set staff = 'xxx' where staff = 'zzz';
update xray_appointment set staff = 'xxx' where staff = 'zzz';
update xray_film_staff set staff = 'xxx' where staff = 'zzz';
update xray_order set staff = 'xxx' where staff = 'zzz';
update xray_report set staff = 'xxx' where staff = 'zzz';
update rcpt_abort set user = 'xxx' where user = 'zzz';
update rcpt_print set user = 'xxx' where user = 'zzz';
update sp_use set user = 'xxx' where user = 'zzz';
update rx_operator set login = 'xxx' where login = 'zzz';
update drug_user_check set loginname = 'xxx' where loginname = 'zzz';
update edoc_activity_list set loginname = 'xxx' where loginname = 'zzz';
update ir_prepare set loginname = 'xxx' where loginname = 'zzz';
update ksklog set loginname = 'xxx' where loginname = 'zzz';
update lab_items_report_right set loginname = 'xxx' where loginname = 'zzz';
update micnp set loginname = 'xxx' where loginname = 'zzz';
update onlineuser set loginname = 'xxx' where loginname = 'zzz';
update onlineuser_dshos set loginname = 'xxx' where loginname = 'zzz';
update opduser set loginname = 'xxx' where loginname = 'zzz';
update opduser_default set loginname = 'xxx' where loginname = 'zzz';
update opduser_right set loginname = 'xxx' where loginname = 'zzz';
update printserver set loginname = 'xxx' where loginname = 'zzz';
update readmit set loginname = 'xxx' where loginname = 'zzz';
update report_access_log set loginname = 'xxx' where loginname = 'zzz';
update risk_user_access set loginname = 'xxx' where loginname = 'zzz';
update stock_user set loginname = 'xxx' where loginname = 'zzz';
update user_finger_template set loginname = 'xxx' where loginname = 'zzz';
update web_pwd set loginname = 'xxx' where loginname = 'zzz';
เพราะผมเคยอัพเดตข้อมูลในฐาน แต่ไม่รู้ว่าหลังๆจะมีเพิ่มมาอีกหรือเปล่า
หัวข้อ: เปลี่ยนความกว้างของ column staff ในทุกตาราง (อ่าน 14231 ครั้ง)