967
« เมื่อ: มีนาคม 31, 2007, 07:45:15 AM »
7.1 : Hospital Code = 11339 [รพช. ถ้ำพรรณรา]
Database Type = MySQL
Database Protocol = mysql-4.1
Last 3 SQL Statement
.
No 1 = select * from information_schema.triggers where TRIGGER_SCHEMA = 'hos' and EVENT_OBJECT_TABLE = 'doctor'
.
No 2 = create trigger doctor_trigger3 before delete on doctor for each row begin insert into tmp_doctor_repl set data_type='varchar', trigger_date = current_timestamp,sync_state =0, table_name = 'doctor' ,pkname1 = 'code', pkvalue1 = OLD.code; end;
.
No 3 = create trigger doctor_trigger2 before update on doctor for each row begin insert into tmp_doctor_repl set data_type='varchar', trigger_date = current_timestamp,sync_state =0, table_name = 'doctor' ,pkname1 = 'code', pkvalue1 = OLD.code; end;
.
Server variable
แสดงกระทู้
