pstockmedicine_init.sql

来自「一整套的源代码」· SQL 代码 · 共 24 行

insert into pstockmedicine
(
pstockmedicineid,
samount,
amount,
created,
updated,
medicinestockid,
price,
total
)
select
null,
0,
minamount,
sysdate,
sysdate,
medicinestockid,
0,
null
from
medicinestock
where minamount > 0;