sql语句没看明白 请各位先森 指教！

Question

select GOODS_VILDATE_NDAYS,goods_id,goods_code,goods_bar,goods_mcode,goods_name,goods_short_name,goods_model,goods_unit,goods_taxflag,goods_hstock,goods_lstock,goods_slot_hl,goods_stock_load_qty,goods_weight,goods_price,goods_warehouse_id,goods_area_id,goods_abc,goods_type,goods_fax_flag,goods_remark,goods_standard,goods_cess,goods_unit_group,goods_sort,(goods_spack_num*goods_mpack_num*goods_lpack_num) as js from wms_base_goods where goods_id = '" + id + "'"; 是什么意思

Answer 1

就是把 wms_base_goods 表中 满足goods_id = '" + id + "'"条件 的这些字段 OODS_VILDATE_NDAYS,goods_id,goods_code,goods_bar,goods_mcode,goods_name,goods_short_name,goods_model,goods_unit,goods_taxflag,goods_hstock,goods_lstock,goods_slot_hl,goods_stock_load_qty,goods_weight,goods_price,goods_warehouse_id,goods_area_id,goods_abc,goods_type,goods_fax_flag,goods_remark,goods_standard,goods_cess,goods_unit_group,goods_sort,(goods_spack_num*goods_mpack_num*goods_lpack_num) as js都查出来