BMS-HOSxP Community
HOSxP => แจ้งข้อผิดพลาดการทำงานของ HOSxP V3 => ข้อความที่เริ่มโดย: monchai ที่ พฤศจิกายน 09, 2007, 14:24:20 PM
-
เรียน อ.ชัยพร
version 3.50.7.22 ระบบงานห้อง Lab ติกที่ รายงานผลที่ยืนยันแล้ว และ รายงานผลทั้งหมด ทำให้ระบบ HOSxP ทั้งระบบ ช้า ผมส่ง คำสั่ง ที่อ.ให้มา (show create table lab_head,lab_order) มาให้ดูด้วย
lab_head
CREATE TABLE `lab_head` (
`lab_order_number` int(11) NOT NULL default '0',
`doctor_code` varchar(7) collate tis620_bin default NULL,
`lab_items_group_code` int(11) default NULL,
`vn` varchar(13) collate tis620_bin default NULL,
`lab_head_remark` varchar(250) collate tis620_bin default NULL,
`hn` varchar(9) collate tis620_bin default NULL,
`order_date` date default NULL,
`report_date` date default NULL,
`reporter_name` varchar(100) collate tis620_bin default NULL,
`report_time` time default NULL,
`confirm_specimen` char(1) collate tis620_bin default NULL,
`confirm_report` char(1) collate tis620_bin default NULL,
`department` varchar(5) collate tis620_bin default NULL,
`form_name` varchar(200) collate tis620_bin default NULL,
`sub_group_list` varchar(200) collate tis620_bin default NULL,
`order_time` time default NULL,
`receive_date` date default NULL,
`receive_time` time default NULL,
`ward` char(2) collate tis620_bin default NULL,
`result_note` text collate tis620_bin,
`lock_result` char(1) collate tis620_bin default NULL,
`result_rtf` longtext collate tis620_bin,
`order_note` text collate tis620_bin,
`lab_receive_number` int(11) default NULL,
`approve_staff` varchar(25) collate tis620_bin default NULL,
`anonymous` char(1) collate tis620_bin default NULL,
`appointment` char(1) collate tis620_bin default NULL,
`appointment_date` date default NULL,
`appointment_time` time default NULL,
`lis_order_no` varchar(25) collate tis620_bin default NULL,
`confirm_charge_money` char(1) collate tis620_bin default NULL,
`finance_lab_confirm` char(1) collate tis620_bin default NULL,
`lab_order_number_guid` varchar(38) collate tis620_bin default NULL,
`anonymous_request` char(1) collate tis620_bin default NULL,
`clinic` char(3) collate tis620_bin default NULL,
`send_to_cashier` char(1) collate tis620_bin default NULL,
PRIMARY KEY (`lab_order_number`),
UNIQUE KEY `lab_order_number_unique` (`lab_order_number`),
KEY `confirm_specimen` (`confirm_specimen`),
KEY `hn` (`hn`),
KEY `vn` (`vn`),
KEY `ix_order_date` (`order_date`),
KEY `order_date` (`order_date`),
KEY `lab_order_number` (`lab_order_number`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620 COLLATE=tis620_bin
lab_order
CREATE TABLE `lab_order` (
`lab_order_number` int(11) NOT NULL,
`lab_items_code` int(11) NOT NULL,
`lab_order_result` varchar(250) default NULL,
`lab_order_remark` varchar(250) default NULL,
`staff` varchar(50) default NULL,
`confirm` char(1) default NULL,
`lab_items_name_ref` varchar(250) default NULL,
`lab_items_normal_value_ref` varchar(150) default NULL,
`specimen_code` int(11) default NULL,
`lab_items_sub_group_code` int(11) default NULL,
`order_type` char(1) default NULL,
PRIMARY KEY (`lab_order_number`,`lab_items_code`),
UNIQUE KEY `lab_order_number_unique` (`lab_order_number`,`lab_items_code`),
KEY `lab_order_number` (`lab_order_number`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620
-
รู้สึกว่าจะมี index ครบแล้วนะครับ ลอง Trace SQL แล้วส่งคำสั่งที่ช้า เข้ามาใหม่ครับ
-
ส่งให้แล้วครับ
Date Time Type Exec Time SQL Text
50-11-09 14:32:16.328 SQL 325,172 select h.lab_order_number,v.pcode,a.pcode as apcode, h.lab_receive_number,h.vn,h.hn,h.order_date ,h.order_time, h.lock_result,h.receive_time as service13,h.report_time as service14 ,h.confirm_report,d.name as doctor_name, concat(pt.pname,pt.fname,' ',pt.lname) as ptname , h.form_name ,v.rcpt_money as opaid,a.rcpt_money as ipaid , v.age_y as vage_y,a.age_y as aage_y ,h.department,concat(w.name,' - ',adm.bedno) as ward_name from lab_head h left outer join patient pt on pt.hn=h.hn left outer join doctor d on d.code=h.doctor_code left outer join vn_stat v on v.vn=h.vn left outer join an_stat a on a.an=h.vn left outer join ward w on w.ward = a.ward left outer join iptadm adm on adm.an = a.an where h.lab_order_number in (238,239,267,271,270,272,273,274,275,373,411,482,510,519,541,576,591,590,608,821,825,857,858,879,881,882,883,884,885,1016,1017,1024,1025,1026,1027,1028,1029,1030,1048,1053,1063,1179,1210,1223,1225,1311,1310,1314,1335,1340,1341,1342,1343,1344,1345,1449,1466,1516,1528,1529,1626,1629,1639,1642,1677,1678,1899,1932,2033,2048,2068,2069,2070,2072,2173,2176,2208,2211,2213,2261,2475,2512,2593,2595,2607,2630,2633,2634,2635,2676,2705,2708,2740,2829,3020,3088,3093,3110,3114,3128,3157,3156,3186,3271,3382,3383,3423,3486,3487,3513,3530,3609,3689,3738,3742,3743,3744,3750,3762,3878,3933,4069,4091,4134,4180,4187,4193,4339,4357,4373,4450,4463,4465,4466,4567,4589,4590,4592,4603,4631,4659,4729,4730,4799,4876,4892,4894,4907,4927,4931,4939,4941,4946,5009,5195,5196,5269,5291,5444,5510,5513,5519,5520,5521,5522,5523,5524,5525,5527,5528,5529,5530,5531,5532,5533,5544,5585,5596,5597,5647,5648,5664,5706,5913,5939,6018,6019,6020,6107,6134,6147,6161,6173,6217,6259,6268,6283,6292,6327,6328,6387,6389,6427,6476,6477,6490,6500,6508,6528,6565,6654,6692,6696,6712,6725,6737,6780,6785,6790,6809,6829,6830,6876,6906,6907,6912,6914,6923,6959,7115,7126,7130,7131,7144,7148,7151,7155,7176,7181,7220,7224,7249,7267,7485,7488,7600,7641,7650,7651,7652,7675,7864,7988,8023,8048,8058,8079,8088,8182,8415,8425,8428,8429,8439,8520,8523,8530,8584,8589,8593,8599,8609,8623,8624,8630,8637,8651,8652,8658,8660,8699,8718,8727,8750,8751,8752,8761,8762,8806,8857,8896,8903,8907,8923,9011,9028,9059,9060,9096,9165,9190,9193,9281,9303,9307,9308,9320,9321,9440,9639,9767,9768,9796,9804,9805,9817,9818,9835,9856,9933,9968,9974,9994,9999,10000,10016,10078,10080,10132,10133,10140,10271,10385,10386,10388,10401,10402,10484,10487,10628,10755,10756,11020,11361,11528,11633,11720,11728,11729,11738,11853,12123,12137,12158,12270,12424,12431,12520,12530,12842,12859,12986,12996,13027,13382,13405,13420,13439,13448,13564,13565,13810,13830,13831,13832,13833,13834,13835,13836,13837,13838,13839,13846,13871,14504,14638,15096,15101,15110,15138,15143,15145,15267,15579,16067,16075,16086,16200) order by h.order_date,h.order_time
-
ส่งโครงสร้างของทุกตารางจากคำสั่งด้านบนเข้ามาด้วยครับ
-
ส่งให้แล้วครับ ใช่หรือเปล่าครับ
///
CREATE TABLE `patient` (
`hos_guid` varchar(38) NOT NULL default '',
`hn` varchar(9) default NULL,
`pname` varchar(15) default NULL,
`fname` varchar(30) default NULL,
`lname` varchar(30) default NULL,
`occupation` char(3) default NULL,
`citizenship` char(3) default NULL,
`birthday` date default NULL,
`addrpart` varchar(50) default NULL,
`moopart` char(3) default NULL,
`tmbpart` char(2) default NULL,
`amppart` char(2) default NULL,
`chwpart` char(2) default NULL,
`bloodgrp` varchar(5) default NULL,
`clinic` varchar(100) default NULL,
`deathday` date default NULL,
`drugallergy` varchar(50) default NULL,
`familyno` int(11) default NULL,
`fathername` varchar(50) default NULL,
`firstday` date default NULL,
`hometel` varchar(20) default NULL,
`informaddr` varchar(200) default NULL,
`informname` varchar(50) default NULL,
`informrelation` varchar(50) default NULL,
`informtel` varchar(20) default NULL,
`marrystatus` char(1) default NULL,
`mathername` varchar(50) default NULL,
`hn_int` int(11) default NULL,
`nationality` char(3) default NULL,
`opdlocation` varchar(50) default NULL,
`pttype` char(2) default NULL,
`religion` char(2) default NULL,
`sex` char(1) default NULL,
`spsname` varchar(50) default NULL,
`truebirthday` char(1) default NULL,
`workaddr` varchar(50) default NULL,
`worktel` varchar(20) default NULL,
`hcode` varchar(5) default NULL,
`cid` varchar(13) default NULL,
`hid` int(11) default NULL,
`educate` char(1) default NULL,
`family_status` char(1) default NULL,
`labor_type` char(1) default NULL,
`last_update` date default NULL,
`type_area` char(1) default NULL,
`road` varchar(50) default NULL,
`father_cid` varchar(13) default NULL,
`mother_cid` varchar(13) default NULL,
`couple_cid` varchar(13) default NULL,
`person_type` char(2) default NULL,
`private_doctor_name` varchar(75) default NULL,
`legal_action` char(1) default NULL,
`death_code504` char(2) default NULL,
`death_diag` varchar(6) default NULL,
`node_id` char(1) default NULL,
`admit` char(1) default NULL,
`midname` varchar(25) default NULL,
`po_code` varchar(5) default NULL,
`fatherlname` varchar(30) default NULL,
`motherlname` varchar(30) default NULL,
`spslname` varchar(30) default NULL,
`country` char(2) default NULL,
`email` varchar(50) default NULL,
`birthtime` time default NULL,
`mother_hn` varchar(9) default NULL,
`last_visit` date default NULL,
`death` char(1) default NULL,
`height` int(11) default NULL,
`inregion` char(1) default NULL,
`reg_time` time default NULL,
`oldcode` varchar(15) default NULL,
`lang` char(2) default NULL,
`gov_chronic_id` varchar(10) default NULL,
`in_cups` char(1) default NULL,
`patient_type_id` tinyint(4) default NULL,
`addr_soi` varchar(100) default NULL,
`work_addr` varchar(230) default NULL,
`father_hn` varchar(9) default NULL,
`alias_name` varchar(100) default NULL,
`destroyed` char(1) default NULL,
`old_addr` varchar(250) default NULL,
PRIMARY KEY (`hos_guid`),
UNIQUE KEY `hn_unique` (`hn`),
UNIQUE KEY `ix_hn_unique` (`hn`),
KEY `ix_pname` (`pname`),
KEY `ix_fname` (`fname`),
KEY `ix_lname` (`lname`),
KEY `ix_fname_lname` (`fname`,`lname`),
KEY `ix_chwpart` (`chwpart`),
KEY `ix_address` (`chwpart`,`amppart`,`tmbpart`),
KEY `ix_clinic` (`clinic`),
KEY `ix_pttype` (`pttype`),
KEY `ix_hcode` (`hcode`),
KEY `ix_cid` (`cid`),
KEY `ix_deathday` (`deathday`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620
////
CREATE TABLE `doctor` (
`code` varchar(6) NOT NULL default '',
`name` varchar(150) default NULL,
`shortname` varchar(50) default NULL,
`licenseno` varchar(50) default NULL,
`department` varchar(250) default NULL,
`jobposition` varchar(50) default NULL,
`active` char(1) default NULL,
`force_diagnosis` char(1) default NULL,
`oldcode` varchar(10) default NULL,
`search_keyword` varchar(25) default NULL,
`cid` varchar(17) default NULL,
`position_id` int(11) default NULL,
`addrpart` varchar(20) default NULL,
`moopart` varchar(20) default NULL,
`zoipart` varchar(20) default NULL,
`roadpart` varchar(20) default NULL,
`tmbpart` varchar(20) default NULL,
`amppart` varchar(20) default NULL,
`chwpart` varchar(20) default NULL,
`nationality` varchar(20) default NULL,
`doctor_guid` varchar(38) default NULL,
`allow_df_edit` char(1) default NULL,
`force_icd_diagnosis` char(1) default NULL,
`ename` varchar(200) default NULL,
PRIMARY KEY (`code`),
UNIQUE KEY `code_unique` (`code`),
KEY `department` (`department`),
KEY `name` (`name`),
KEY `shortname` (`shortname`),
KEY `search_keyword` (`search_keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620
///
CREATE TABLE `vn_stat` (
`vn` varchar(13) NOT NULL default '',
`hn` varchar(9) default NULL,
`pdx` varchar(6) default NULL,
`gr504` smallint(6) default NULL,
`lastvisit` smallint(6) default NULL,
`accident_code` varchar(6) default NULL,
`dx_doctor` varchar(7) default NULL,
`dx0` varchar(6) default NULL,
`dx1` varchar(6) default NULL,
`dx2` varchar(6) default NULL,
`dx3` varchar(6) default NULL,
`dx4` varchar(6) default NULL,
`dx5` varchar(6) default NULL,
`sex` char(1) default NULL,
`age_y` smallint(6) default NULL,
`age_m` smallint(6) default NULL,
`age_d` smallint(6) default NULL,
`aid` varchar(6) default NULL,
`moopart` varchar(5) default NULL,
`count_in_month` smallint(6) default NULL,
`count_in_year` smallint(6) default NULL,
`pttype` char(2) default NULL,
`income` double(15,3) default NULL,
`paid_money` double(15,3) default NULL,
`remain_money` double(15,3) default NULL,
`uc_money` double(15,3) default NULL,
`item_money` double(15,3) default NULL,
`dba` tinyint(4) default NULL,
`spclty` char(2) default NULL,
`vstdate` date default NULL,
`op0` varchar(6) default NULL,
`op1` varchar(6) default NULL,
`op2` varchar(6) default NULL,
`op3` varchar(6) default NULL,
`op4` varchar(6) default NULL,
`op5` varchar(6) default NULL,
`rcp_no` varchar(10) default NULL,
`print_count` tinyint(4) default NULL,
`print_done` char(1) default NULL,
`pttype_in_region` char(1) default NULL,
`pttype_in_chwpart` char(1) default NULL,
`pcode` char(2) default NULL,
`hcode` varchar(5) default NULL,
`inc01` double(15,3) default NULL,
`inc02` double(15,3) default NULL,
`inc03` double(15,3) default NULL,
`inc04` double(15,3) default NULL,
`inc05` double(15,3) default NULL,
`inc06` double(15,3) default NULL,
`inc07` double(15,3) default NULL,
`inc08` double(15,3) default NULL,
`inc09` double(15,3) default NULL,
`inc10` double(15,3) default NULL,
`inc11` double(15,3) default NULL,
`inc12` double(15,3) default NULL,
`inc13` double(15,3) default NULL,
`inc14` double(15,3) default NULL,
`inc15` double(15,3) default NULL,
`inc16` double(15,3) default NULL,
`hospmain` varchar(5) default NULL,
`hospsub` varchar(5) default NULL,
`pttypeno` varchar(20) default NULL,
`pttype_expire` date default NULL,
`cid` varchar(13) default NULL,
`main_pdx` char(3) default NULL,
`inc17` double(15,3) default NULL,
`inc_drug` double(15,3) default NULL,
`inc_nondrug` double(15,3) default NULL,
`pt_subtype` tinyint(4) default NULL,
`rcpno_list` varchar(25) default NULL,
`ym` varchar(7) default NULL,
`node_id` char(1) default NULL,
`ill_visit` char(1) default NULL,
`count_in_day` tinyint(4) default NULL,
`pttype_begin` date default NULL,
`lastvisit_hour` int(11) default NULL,
`rcpt_money` double(15,3) default NULL,
`discount_money` double(15,3) default NULL,
`old_diagnosis` char(1) default NULL,
`debt_id_list` varchar(50) default NULL,
PRIMARY KEY (`vn`),
UNIQUE KEY `vn_unique` (`vn`),
KEY `hn` (`hn`),
KEY `hospmain` (`hospmain`),
KEY `hospsub` (`hospsub`),
KEY `cid` (`cid`),
KEY `pcode` (`pcode`),
KEY `pttype` (`pttype`),
KEY `vstdate` (`vstdate`),
KEY `ym` (`ym`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620
///
CREATE TABLE `an_stat` (
`an` varchar(9) NOT NULL default '',
`pdx` varchar(6) default NULL,
`hn` varchar(9) default NULL,
`dx0` varchar(6) default NULL,
`dx1` varchar(6) default NULL,
`dx2` varchar(6) default NULL,
`dx3` varchar(6) default NULL,
`dx4` varchar(6) default NULL,
`dx5` varchar(6) default NULL,
`sex` char(1) default NULL,
`age_y` tinyint(4) default NULL,
`age_m` tinyint(4) default NULL,
`age_d` tinyint(4) default NULL,
`aid` varchar(6) default NULL,
`count_in_month` tinyint(4) default NULL,
`count_in_year` tinyint(4) default NULL,
`pttype` char(2) default NULL,
`income` double(15,3) default NULL,
`lastvisit` int(4) default NULL,
`regdate` date default NULL,
`dchdate` date default NULL,
`admdate` int(11) default NULL,
`drg` varchar(6) default NULL,
`rw` double(15,3) default NULL,
`los` double(15,3) default NULL,
`ot` double(15,3) default NULL,
`spclty` char(2) default NULL,
`ward` varchar(4) default NULL,
`print_done` char(1) default NULL,
`print_count` tinyint(4) default NULL,
`paid_money` double(22,3) default NULL,
`remain_money` double(22,3) default NULL,
`uc_money` double(22,3) default NULL,
`item_money` double(22,3) default NULL,
`pttype_in_region` char(1) default NULL,
`pcode` char(2) default NULL,
`op0` varchar(6) default NULL,
`op1` varchar(6) default NULL,
`op2` varchar(6) default NULL,
`op3` varchar(6) default NULL,
`op4` varchar(6) default NULL,
`op5` varchar(6) default NULL,
`op6` varchar(6) default NULL,
`inc01` double(15,3) default NULL,
`inc02` double(15,3) default NULL,
`inc03` double(15,3) default NULL,
`inc04` double(15,3) default NULL,
`inc05` double(15,3) default NULL,
`inc06` double(15,3) default NULL,
`inc07` double(15,3) default NULL,
`inc08` double(15,3) default NULL,
`inc09` double(15,3) default NULL,
`inc10` double(15,3) default NULL,
`inc11` double(15,3) default NULL,
`inc12` double(15,3) default NULL,
`inc13` double(15,3) default NULL,
`inc14` double(15,3) default NULL,
`inc15` double(15,3) default NULL,
`inc16` double(15,3) default NULL,
`dx_doctor` varchar(7) default NULL,
`vn` varchar(13) default NULL,
`inc17` double(15,3) default NULL,
`rcpno_list` varchar(100) default NULL,
`pttypeno` varchar(25) default NULL,
`moopart` char(3) default NULL,
`gr504` smallint(6) default NULL,
`accident_code` varchar(6) default NULL,
`lastvisit_hour` int(11) default NULL,
`rcpt_money` double(15,3) default NULL,
`discount_money` double(15,3) default NULL,
`old_diagnosis` char(1) default NULL,
`debt_id_list` varchar(50) default NULL,
`admit_hour` int(11) default NULL,
PRIMARY KEY (`an`),
UNIQUE KEY `an_unique` (`an`),
KEY `dchdate` (`dchdate`),
KEY `pcode` (`pcode`),
KEY `pttype` (`pttype`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620
///
CREATE TABLE `ward` (
`ward` varchar(4) NOT NULL default '',
`name` varchar(250) default NULL,
`old_code` char(3) default NULL,
`spclty` char(2) default NULL,
`bedcount` int(11) default NULL,
PRIMARY KEY (`ward`),
UNIQUE KEY `ward_unique` (`ward`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620
///
CREATE TABLE `iptadm` (
`an` varchar(9) NOT NULL default '',
`admday` int(11) default NULL,
`bedno` varchar(6) default NULL,
`bedtype` char(2) default NULL,
`indate` date default NULL,
`intime` time default NULL,
`outdate` date default NULL,
`outtime` time default NULL,
`rate` double(22,3) default NULL,
`roomno` varchar(4) default NULL,
PRIMARY KEY (`an`),
UNIQUE KEY `an_unique` (`an`),
KEY `bedno` (`bedno`),
KEY `bedtype` (`bedtype`),
KEY `indate` (`indate`),
KEY `intime` (`intime`),
KEY `outdate` (`outdate`),
KEY `outtime` (`outtime`),
KEY `roomno` (`roomno`),
KEY `roomno_an` (`roomno`,`an`)
) ENGINE=MyISAM DEFAULT CHARSET=tis620
-
ใช้ MySQL version ไหนอยู่ครับ Server RAM เท่าไหร่ ช่วยส่ง แฟ้ม /etc/my.cnf เข้ามาด้วยได้หรือเปล่าครับ
-
HOSxP version 3.50.7.22
mysql 5.0
RAM 1 GB
-
LAB คนไข้ นอก หรือ ใน ครับ
-
ลอง Check table ดูหรือยังครับ
-
ทำการ check Table และ ทำ Re-Index แล้ว
เป็นทั้ง Lab OPD และ Lab IPD
-
ช่วยตรวจสอบข้อมูลตาราง
select h.lab_order_number,v.pcode,a.pcode as apcode, h.lab_receive_number,h.vn,h.hn,h.order_date ,h.order_time, h.lock_result,h.receive_time as service13,h.report_time as service14 ,h.confirm_report,d.name as doctor_name, concat(pt.pname,pt.fname,' ',pt.lname) as ptname , h.form_name ,v.rcpt_money as opaid,a.rcpt_money as ipaid , v.age_y as vage_y,a.age_y as aage_y ,h.department,concat(w.name,' - ',adm.bedno) as ward_name from lab_head h
left outer join patient pt on pt.hn=h.hn
left outer join doctor d on d.code=h.doctor_code
left outer join vn_stat v on v.vn=h.vn
left outer join an_stat a on a.an=h.vn
left outer join ward w on w.ward = a.ward
left outer join iptadm adm on adm.an = a.an where h.lab_order_number in (238,239,267,271,270,272,273,274,275,373,411,482,510,519,541,576,591,590,608,821,825,857,858,879,881,882,883,884,885,1016,1017,1024,1025,1026,1027,1028,1029,1030,1048,1053,1063,1179,1210,1223,1225,1311,1310,1314,1335,1340,1341,1342,1343,1344,1345,1449,1466,1516,1528,1529,1626,1629,1639,1642,1677,1678,1899,1932,2033,2048,2068,2069,2070,2072,2173,2176,2208,2211,2213,2261,2475,2512,2593,2595,2607,2630,2633,2634,2635,2676,2705,2708,2740,2829,3020,3088,3093,3110,3114,3128,3157,3156,3186,3271,3382,3383,3423,3486,3487,3513,3530,3609,3689,3738,3742,3743,3744,3750,3762,3878,3933,4069,4091,4134,4180,4187,4193,4339,4357,4373,4450,4463,4465,4466,4567,4589,4590,4592,4603,4631,4659,4729,4730,4799,4876,4892,4894,4907,4927,4931,4939,4941,4946,5009,5195,5196,5269,5291,5444,5510,5513,5519,5520,5521,5522,5523,5524,5525,5527,5528,5529,5530,5531,5532,5533,5544,5585,5596,5597,5647,5648,5664,5706,5913,5939,6018,6019,6020,6107,6134,6147,6161,6173,6217,6259,6268,6283,6292,6327,6328,6387,6389,6427,6476,6477,6490,6500,6508,6528,6565,6654,6692,6696,6712,6725,6737,6780,6785,6790,6809,6829,6830,6876,6906,6907,6912,6914,6923,6959,7115,7126,7130,7131,7144,7148,7151,7155,7176,7181,7220,7224,7249,7267,7485,7488,7600,7641,7650,7651,7652,7675,7864,7988,8023,8048,8058,8079,8088,8182,8415,8425,8428,8429,8439,8520,8523,8530,8584,8589,8593,8599,8609,8623,8624,8630,8637,8651,8652,8658,8660,8699,8718,8727,8750,8751,8752,8761,8762,8806,8857,8896,8903,8907,8923,9011,9028,9059,9060,9096,9165,9190,9193,9281,9303,9307,9308,9320,9321,9440,9639,9767,9768,9796,9804,9805,9817,9818,9835,9856,9933,9968,9974,9994,9999,10000,10016,10078,10080,10132,10133,10140,10271,10385,10386,10388,10401,10402,10484,10487,10628,10755,10756,11020,11361,11528,11633,11720,11728,11729,11738,11853,12123,12137,12158,12270,12424,12431,12520,12530,12842,12859,12986,12996,13027,13382,13405,13420,13439,13448,13564,13565,13810,13830,13831,13832,13833,13834,13835,13836,13837,13838,13839,13846,13871,14504,14638,15096,15101,15110,15138,15143,15145,15267,15579,16067,16075,16086,16200) order by h.order_date,h.order_time
ไม่ทราบว่ามีการพิมพ์อะไรหรือเปล่าถึงได้ sql น่ี้ออกมา
แล้วช่วยส่งหน้าจอ ที่เกิดปัญหามาให้ดูด้วยครับ
-
HOSxP version 3.50.7.22
mysql 5.0
RAM 1 GB
1 GB นี้แรมของอะไรครับ เครื่อง Pc หรือเครื่อง Server ครับ
-
??? ??? ???
HOSxP version 3.50.7.22
mysql 5.0
RAM 1 GB
1 GB นี้แรมของอะไรครับ เครื่อง Pc หรือเครื่อง Server ครับ
ปี 2007
ขุดกระทู้ข้ามปี -_-" :D :D :D :D :D ;D ;D สงสัยจะอ่านเพลินไปหน่อย ;D :D ;D