mysql 建立视图

版权声明:本文为博主原创文章,遵循 CC 4.0 by-sa 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/u010548619/article/details/82781410

CREATE OR REPLACE VIEW V_HOS_EXPENSE
(advice_id, client_id, sickroom, org_id, code, med_name, med_nname, unit_per, medicare, med_seqid, advice_property, doc_id, amount, send_num, med_price, advice_category, client_name, id_card, birthday, gender, patient_id, jixing, med_spec, hos_patient_id, add_time, list_id, excute_time, spec, execut_id, dd_outp_class, frequency, usage, ward_id, execut_opr_id, num_per, type, add_opr_id)
AS
SELECT * from tablename

展开阅读全文

没有更多推荐了,返回首页