数据库增删改查经验汇总

1、根据数据库中某个字段进行查询，并导出表格

select id,tunnel__id,line_name,line_id,direction,rs_ip,port,internal_nat_ip,external_nat_ip,end_ip,end_port,rs_ip_add,rs_ip_delete,port_add,port_delete,end_ip_add,end_ip_delete,end_port_add,end_port_delete into outfile '/tmp/20210513.xls' from tunnel_application where id between 1272 and 1278;