mysql:
举例:insert into sys_z_info(z_id,o_id,z_name) select '固定字段一',o_id,'固定字段2' from sys_z_info where z_id='1234567'
mysql:
举例:insert into sys_z_info(z_id,o_id,z_name) select '固定字段一',o_id,'固定字段2' from sys_z_info where z_id='1234567'
转载于:https://www.cnblogs.com/tbb-pxq/p/7339594.html