33 lines
468 B
MySQL
33 lines
468 B
MySQL
|
/*
|
||
|
|
truncate table telsale_oper_lst;
|
||
|
|
*/
|
||
|
|
/*
|
||
|
|
INSERT INTO telsale_oper_lst
|
||
|
|
(policy_no,
|
||
|
|
operator_code,
|
||
|
|
operator_name,
|
||
|
|
section_office_code,
|
||
|
|
section_office_name,
|
||
|
|
department_code,
|
||
|
|
department_name,
|
||
|
|
autotrader_code,
|
||
|
|
insruant_name,
|
||
|
|
plate_no,
|
||
|
|
entry_staff_code,
|
||
|
|
entry_date)
|
||
|
|
VALUES
|
||
|
|
(?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
?,
|
||
|
|
'800',
|
||
|
|
SYSDATE)
|
||
|
|
*/
|
||
|
|
SELECT * FROM telsale_oper_lst;
|